Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / January 2004

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
linked workbook28 Jan 2004 21:37 GMT1
Can you link a workbook off of a linked workbook?
Source>linked book >linked book
Thanks
Making one cell display multiple things28 Jan 2004 21:24 GMT1
If I knew anything about coding checkboxes in excel, then this problem
probably wouldn't exist, but unfortunately i don't, so here goes:
Ok, if cell B1 isn't blank, then I need Cell A1 to display "damaged".
If cell C1 isn't blank then I need Cell A1 to display "defective"
Sort by month, ignore year28 Jan 2004 21:23 GMT7
I have a big spreadsheet that has dates ranging from
01/01/95 all the way to 12/31/06.  What I need it to do
is sort by month only, and ignore the year.  So I would
have a list of all in January, etc, not including the
formula needed28 Jan 2004 21:22 GMT5
I have a spreadsheet that calculates our attendance, time
off, overtime etc. and I need to count the following:
If ST1 OR ST2 OR ST3 (this stands for 'straight time' and
the number of hours worked) is typed in a cell, I need a
Named Range in 3-D Formula28 Jan 2004 21:22 GMT3
I have need to insert a named range into a 3-D formula such as this
='C:\Work\[DataFile.xls]Sheet1'!$A$
replacing the column reference "A" with a named range (let's call it "NewColumn") that has a value for a new column reference, i.e. "B"
Logically, the new formula should look ...
Pivot Table Formatting28 Jan 2004 21:13 GMT1
Is it possible to custom format a pivot table output?  It
would be like using the auto format but only with
customized fonts and color scheme.
Duplicate Records28 Jan 2004 21:01 GMT4
I think I described my scenario wrong...excuse me, English is not my
first language. I'll try this again. Every member has a unique seven
digit number but some members have two.
For example:
Compare worksheets?28 Jan 2004 20:57 GMT1
Is there any way to compare one worksheet with another
worksheet to determine which cells have different values
between the two worksheets?
I have a worksheet full of names and addresses which I've
IF(AND(OR28 Jan 2004 20:56 GMT6
HOW DO I FIX THIS FORMULA SO I DO NOT GET A FALSE ANSWER.
=IF(AND(D4=25),IF(OR(E4=100,F4=75),1,0))
 D      E       F        G
 20    100    75    FALSE
Excel inter-relating Worksheet IF functions....28 Jan 2004 20:28 GMT5
I have a workbook with a Orders sheet,  products sheet (for referenc
on the orders page)
I need a formula to give the price of a product automatically on th
order page by using the Product number.
Formula Displayed Rather Than Result28 Jan 2004 20:04 GMT4
I am trying to do a simple formula to concatenate the text
string in column A with the same from column B, separated
by a space. The formula is correct.
=concatenate(a2," ",b2)
Formula's in text28 Jan 2004 20:00 GMT1
I have a gift certificate template in excel.  I have a cell that has a string of text that says "to redeem $xx off your next purchase"  I would like to have the dollar amount reflect a cell inside the workbook so that I only have to change one cell and it changes the value in ...
F-Test without population28 Jan 2004 19:51 GMT6
    Can I run an F-Test if I know just the population count, average and
population standard deviation? There are a lot of numbers in my Access
database, and I'd like to leave them there.
ion
Sorting the contents of a cell28 Jan 2004 19:38 GMT3
I would like to sort the contents of a cell.
For example, let us assume that cell A1 contains the
text "SORTS".  In cell B1 I would like to get the result
as "ORSST" i.e. the contents of cell A1 but sorted.
Locating duplicate entries using specific criteria28 Jan 2004 19:23 GMT3
I have a spreadsheet with multiple columns.  I want to
write a formula that will identify a duplicate entry based
on the satisfaction of specific criteria (i.e., same
payment amount, same adjuster name & same invoice
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2010 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.