Excel Worksheet Functions - Page 520

Thread / Thread Starter	Last Post	Replies	Views
sumif() using range name Jeff Wimer	by Bob Phillips	1	755
index and match on 2 largest value Steve	by Steve	3	368
Lookup across columns MarkN	by MarkN	3	338
How do I return the curser home Uncertain Realtor	by Fred Smith	2	423
Adding "0" as leading digits into cells in Excel Tippetue	by Gord Dibben	2	1,558
how to get the doted printing area as default Sam Farid	by Gord Dibben	1	496
How to give access to certain cells in the protected worksheet ? fbagirov	by Gord Dibben	4	938
how can i apply labels (or category names) to columns? Justin H.	by Gord Dibben	2	504
Please put a remittance advice template online gistmei	by gistmei	0	3,109
attaching an image to Excel spreadsheet cell roadrunner	by Gord Dibben	2	1,199
lookup or countif Rose Davis	by Biff	1	368
Does EVALUATE( ) still exist in V. 2003? Epinn	by Epinn	17	799
Button to sort a range, and sorting 12 columns [email protected]	by [email protected]	2	443
How to get Solver to target array rather than cell? h.2	by Tushar Mehta	3	5,124
Please help with SumIf Ne0dammerung	by Arvi Laanemets	2	472
IF Statements (Mutliple Statements) Deezel	by Biff	3	1,030
Calculating age when person born before 1900 sits in the stands	by Nick Hodge	1	936
Separating invoices by invoice date then summing by quarter neroamdrid	by Roger Govier	2	795
insert data Smoop	by David Biddulph	1	381
Cell colors or text color changing when date in cell gets closer. Chase	by Stefi	5	2,322
Help with Vlookup flyguykorea	by Stefi	4	591
How to use SUMIF function with non-adjacent cells KLaw	by Bob Phillips	5	4,380
OR in a SUMPRODUCT formula Kierano	by Jon von der Heyden	9	585
Using SUMPRODUCT to count values in separate columns S Stunell	by S Stunell	4	731
SET A COLOUR [email protected]	by Carim	1	400
Create 52 sheets and carry all formulas and figures forward? pb	by JLatham	5	1,379
Entering date and time with a formula Lady Success	by Lady Success	1	436
XL2003: Count formatted cells (not coloured)... Birmangirl	by Birmangirl	0	773
Export Conditional Formatting Values dcohen	by dcohen	0	688
Recording Time & Date based on data input Lady Success	by Lady Success	2	1,216
Assign auto numbers based on a condition Lisa	by Lisa	8	725
Cell variable in formula Tim desision support	by vezerid	1	359
How do I get GETPIVOTDATA to work? Lindy1	by Debra Dalgleish	6	377
Check box formatting [email protected]	by [email protected]	2	300
Max conditional formats in a spreads... HCAJSU	by Barb Reinhardt	1	460
hide duplicate addresses in Excel DbaseGuy	by Barb Reinhardt	1	368
"Delete" greyed out Gina Hembree	by Paul B	6	534
Simple Formula Help Chris	by [email protected]	4	341
Macro question John	by Bob Phillips	7	334
How do I 'Add-In' Hex2Dec formula? Hex2Dec....Help!	by Bob Phillips	2	833
Macro for reformatting cells Gina_Louisville	by Gina_Louisville	4	566
Get final non-blank cell in range Eric	by RagDyeR	9	584
IF function which can find a blank cell owl37	by Edward	5	541
Removing Text Tubthumper	by Kevin Vaughn	3	376
Display a value between certain dates Peterp	by Roger Govier	7	365
INQUIRE FOR SOLVER CIRCULAR FORMULATION - money wizards romelsb	by romelsb	4	511
What graphing technique can you use to show correlation Six Sigma Blackbelt	by bj	1	1,528
All text disappears when wrap text in excel is used sstanfil	by sstanfil	2	973
Using the "IF" function (I think) Chris from Boston	by Chris from Boston	3	368
IF statement problem with IMAGINARY Russ	by Russ	4	322
Need additional help Pamela Jean	by Lindy1	6	526
Weird format to formula transition excel 2003 Macnutt	by Gord Dibben	2	721
ranking problem austuni	by Bernard Liengme	1	439
VLOOKUP Johnny	by Johnny	7	318
How to pick data from different sheets conditionally? TR	by TR	5	663
Hyperlinks in Excel Littlecleavesy	by Gary L Brown	1	467
how to keep the total colum EXCEL Girl	by Roger Govier	5	501
How do I get Excel filename using a single keystroke David	by Gord Dibben	5	450
Creating a List of Loan Periods Dynamically David Treptor	by Gary L Brown	2	453
I wish to group my worksheets under group tabs CSI	by Don Guillett	5	1,262
CELL ADDRESS Johnny	by Biff	1	343
how can I create repeating horizontal menus arash	by arash	0	447
excel 2000 - array formulas cdsta	by cdsta	14	869
Simple Calculation within pivot table toryc	by toryc	0	408
moving a row to a column Papa Jonah	by Biff	4	312
to reverse a column Rasoul Khoshravan	by Gord Dibben	4	497
finding earliest date within a range by employee Steve	by Biff	4	984
how do I turn off automatic spelling correction willie091028	by willie091028	2	837
Highlighting Cells perezianda	by Gord Dibben	3	582
how do i set up/use drop down list in excel Patricb	by Biff	4	410
Excel 2000 - Autofilter Limit NanoMark	by Max	6	528
Excel 2000 pivot HELP!!!! Matt	by Debra Dalgleish	1	322
Count within pivot table Sandy	by Debra Dalgleish	1	593
Conditional Formatting Rosemary	by Rosemary	4	360
Help with creating a search engine in excel vba Zigball	by Zigball	5	723