|
|
|
September 11th, 2006 12:32 PM
by Ashwini
|
6 |
152 |
|
|
LOOKUP a phone number? by
Laura
Is this possible?
I would like to create a LOOKUP formula that would tell me the phone number
if I put in the name.
For instance, I have one worksheet that...
|
September 8th, 2006 07:18 PM
by Biff
|
6 |
144 |
|
|
VLOOKUP, INDEX & MATCH ERROR HELP by
sahafi
Hi All,
I keep getting #N/A error every time I execute this formula. Here's the
situation:
My lookup range data resides in 'Data' sheet, and my formulas in...
|
September 12th, 2006 11:26 PM
by sahafi
|
6 |
136 |
|
|
Convert Dates by
Jo Anna
How do you convert a Julian date with a 4 digit year into a standard calendar
date?
|
|
6 |
155 |
|
|
tricky search and replace by
john
I need to search for a particular string in a very large spreadsheet, and
when I find it I need to replace it with the contents of, or a reference to,
the cell...
|
September 11th, 2006 04:41 PM
by john
|
6 |
117 |
|
|
|
|
6 |
100 |
|
|
|
|
6 |
122 |
|
|
Autosum and Manual Sum not working by
Gaileen
I want to simply add several rows in a column - all containing currency
formatted cells. No matter what I do the total always appears as "0.00". My
formula...
|
September 11th, 2006 11:06 PM
by Gaileen
|
6 |
75 |
|
|
Change second digit from 4 to 6 by
Steved
Hello from Steved
I have 5401 to 5499 and need it to be 5601 to 5699 please
If there a formula I can use to acheive the above.
Thanks
|
September 11th, 2006 10:01 PM
by Steved
|
6 |
139 |
|
|
#N/A in calculations by
JonR
Hi
I'm trying to work around some #N/A values in calculations. Columns A and B
are populated with a conditional formula, and I'm trying to sum them in...
|
|
6 |
106 |
|
|
|
September 9th, 2006 09:00 AM
by Syndrome
|
6 |
100 |
|
|
GETPIVOTDATA() with relative reference by
Sune Fibaek
Hi,
Is there a way of cheating GETPIVOTDATA() into using a cell reference as the
data field argument? As in =GETPIVOTDATA(J8;$A$7;"Rep";$J$9:$L$9). I've...
|
September 3rd, 2006 10:39 PM
by Max
|
6 |
135 |
|
|
alphanumeric range by
[email protected]
I have more than 3 different choices, ( ab, cd, ef, ghij, kl). They
are also aphanumeric, (.01 ab, 6 cd, .50 ef, 8 ghij),etc. The numbers
may range from .01...
|
|
6 |
77 |
|
|
CONVERT TO (###) ###-#### by
JSM123456
How do you convert a phone number in this format xxx-xxx-xxxx to (###)
###-####? I've tried format, cells, custom, (###) ###-#### and "(###)
###-####" but...
|
August 31st, 2006 08:45 PM
by Sloth
|
6 |
50 |
|
|
problem conditional formatting? by
_Bigred
I have a sheet that has approx 7,000 rows.
Until I get all the data into it many columns will contain: #DIV/0! or
#VALUE!
I would like to do some...
|
September 4th, 2006 06:02 AM
by Max
|
6 |
133 |
|
|
|
|
6 |
108 |
|
|
automatically fill in blank cells?? by
AlaskaMX
Can I type info in 1 cell and have it automatically put different info in the
next cell? Kinda like autofill but not that exact option. This would be...
|
|
6 |
71 |
|
|
Problems with MAX by
carlo
Hi all
got a problem with the MAX statement:
have a range with let's say 20 cells.
Each cell has a formula, which either produces
a Number or "". If i want to...
|
September 5th, 2006 12:51 PM
by carlo
|
6 |
86 |
|
|
Delete first two characters in a cell... by
ChuckF
I have a spreadsheet which shows the first inital and a space for
everyone in our company. I am trying to cut that down to simply show
the last name. Can...
|
September 5th, 2006 08:46 PM
by bj
|
6 |
87 |
|
|
Detect Presence Formula by
Ken
I need a formula that will detect the presence of a value in an unsorted
named array.
Column A would be the named array.
Column B would be the value I want...
|
September 12th, 2006 06:43 PM
by Ken
|
6 |
136 |