|
|
Comparing dates in an IF function by
Paula
Could someone kindly give me some guidance on the below:
I have two columns, one a list of dates, and the other which is supposed to
show a 'Y' if the date in...
|
|
3 |
267 |
|
|
|
January 12th, 2005 03:59 PM
by JulieD
|
1 |
258 |
|
|
Pulling data from 1 sheet to another by
Dave1155
I am working with several large excel sheets(stats, employees etc.). I am
trying to tie all 4 of these sheets into 1 sheet that will pull data from the
main...
|
|
1 |
1,107 |
|
|
Formatting Cells by
Randy Balch
I have created a payroll spreadsheet that calculates FICA and MEDICARE W/H.
I formatted the cells to 2 places. The MEDICARE W/H formula calculates to...
|
|
1 |
144 |
|
|
|
January 12th, 2005 06:43 PM
by
|
1 |
98 |
|
|
Can't get simple macro to run by
Abi
Okay. Pretend I'm a totally idiot and and can't seem to get anything to work
right! :)
Now, I have done a few macros before (basically just recording them...
|
January 12th, 2005 07:37 PM
by Abi
|
5 |
501 |
|
|
|
|
1 |
95 |
|
|
|
January 12th, 2005 08:06 PM
by Dave R.
|
4 |
328 |
|
|
|
|
3 |
90 |
|
|
geomean ignoring blank cells and chars by
Stan Altshuller
Hi!
How can I make geomean(1+D2:D37) count ONLY the cells with numbers?
I am trying =GEOMEAN(1+IF(ISNUMBER(D2:D37),D2:D37))^12-1 using array
formula, its not...
|
|
1 |
246 |
|
|
Array Help by
Airfive
Having a brain Fuzz…….
What am I missing…..The following array should return “5” if cell A1
contains “ABC” and cell B1 contains “DEF” and...
|
January 12th, 2005 09:47 PM
by Airfive
|
5 |
123 |
|
|
IF Function Help due to 7 limit by
John F
Using Excel 2003
Using the following formula
It works great Except that when the input cell is blank ( or "deleted"), a
Zero
is entered in cell "W?"
This...
( 1 2)
|
January 12th, 2005 10:07 PM
by John F
|
11 |
144 |
|
|
pivot table row vs column headings by
mrs.champ
I would like my pivot table to use the fields down the first column. Pivot
Tables default to usung the headings across the columns, but my headings are
down...
|
|
1 |
132 |
|
|
excel templates for gradebook by
Monica
When using the excel templates to do a gradebook, how would I adjust it so
that I can drop a student's lowest grade.
|
|
1 |
102 |
|
|
Naming a cell by
mike
Hi everyone
I was wondering how I can rename a cell reference. For example I would
like to rename cell A1 reference: "Mike".
So if I put 20 in cell A1 and I...
|
January 12th, 2005 11:31 PM
by CLR
|
2 |
123 |
|
|
Pivot table tutorial..helpppp! by
Debutante
I have to be an expert in pivot tables in 2 days from now..is there a crash
course for a dummy!
Thank you.
|
|
3 |
105 |
|
|
returns calculation using sumproduct by
Stan Altshuller
I have return streams going down colums B through I
Dates are down column A
I want colum J to give me the weighted return for the streams of returns.
But it...
|
|
6 |
130 |
|
|
|
|
1 |
196 |
|
|
hide/unhide cells by
garpavco
can a cell easily be made to hide &/or unhide the info typed in, without
actually adjusting the row width to perform the hide/unhide
for example:
a1 =...
|
|
3 |
98 |
|
|
|
|
1 |
94 |