Excel Worksheet Functions - Page 841

Thread / Thread Starter	Last Post	Replies	Views
how to use cell contents as references in a formula hussam81	by Alex	1	500
problem using Range Names in VLOOKUP Dee	by Bob Phillips	6	541
Problems with formulas and sorting KatrinaSCC	by KatrinaSCC	2	569
Rounding Error when adding or subtracting two cells mtheo	by Jerry W. Lewis	2	873
can you assign random numbers to many different lines of row? random number generator	by Jerry W. Lewis	3	754
creating macro working across multiple sheets Nicole Seibert	by Jim Thomlinson	8	1,050
Why sometimes excel returns error just because function parameters are linked? Paul134	by Paul134	2	763
Cannot hide columns in Excel John Johns	by CLR	1	972
Vlookup... NWO	by Kevin Vaughn	14	679
List Box with macro VETcalc	by VETcalc	2	966
Copy-Paste sheets - error in the dates Aninha	by Dave Peterson	1	822
Create Lookup Table Matt	by	3	514
AVERAGE DAYS OPEN IF BETWEEN DATES kathi	by kathi	4	748
Creating a formula by using data in another file Mindy	by Duke Carey	2	438
format a drop-down box from a range of cell from another work... Jay Trull	by Jay Trull	2	337
Remove all formatting ragtopcaddy	by SteveG	3	365
Formula for Excel GSO	by CLR	2	315
Copt data with specific criteria Decreenisi	by CLR	2	311
Excel 2002 formula displayed not value formula option not checked Dean	by Duke Carey	1	1,823
VLOOKUP to return first hit Max	by Max	2	507
Looking up a value based on date and time, what's wrong? Margo Guda	by Margo Guda	3	414
assign macro PH NEWS	by PH NEWS	2	536
SUMPRODUCT - Help ceemo	by SteveG	16	809
Vlookup show #N/A Tias	by Engineering Accountant	1	397
pls help again! shirley	by shirley	6	290
MACRO QUESTION Eddy Stan	by Eddy Stan	2	353
Can this be done with Domain Functions? Johnny Meredith	by Johnny Meredith	4	355
How to use if statement whiteswan	by Dav	5	313
Lookup Formula Help - PLEASE! VickyC	by Dav	4	393
Calculated Field in A Pivot Matt D Francis	by Matt D Francis	0	438
Close Dos from Vba? Jason	by Jason	0	471
Help again please Keith Crooks	by tony h	4	315
Function giving a result for number within a range [email protected]	by CLR	3	444
Accessing the sheetname in a cell Kanagabalan	by CLR	4	386
=AVERAGE(IF(INT(MONTH(C:C)+2/3)=4 kathi	by kathi	5	567
transferring data between 2 worksheets in same workbook bigdaddy3	by bigdaddy3	0	828
Incrementing numbers Floyd107	by MartinW	2	598
Linking formulas in new sheets based on a template? Olle Svensson	by Roger Govier	1	610
sorting with RANK/VLOOKUP (problem with equal ranks) hip	by Max	2	1,761
Variable criteria formula Brent	by Biff	4	502
Drop-Down List DolittleDustoff	by Max	1	358
dates into ages Caz	by Peo Sjoblom	1	359
Complex function....not sure how if the result I want is possible Besseme	by bpeltzer	1	272
Amending an existing function Paydog4	by Paydog4	2	394
SUMIF Ferg	by Debra Dalgleish	3	1,070
Is there a formula tutorial online ............................... Denny Crane	by Peo Sjoblom	2	389
Function similar to SHIFT+CTRL+DOWN KEY Dan	by Dan	8	367
How do I sum a range of data (column) that has #num! in some cells steve_sr2	by steve_sr2	2	349
How to prevent copied data from appearing until triggered by anoth Denny Crane	by Denny Crane	2	523
Dividing a time span into shifts - overlapping days Heidi	by Pete_UK	17	2,186
Offset Function Trouble, Please Help Rabbit	by Max	7	546
in excel worksheet, add numbers in column k2&k3 monroe	by Gary''s Student	1	582
I have lost the in cell drop down in validation Stan Lawson	by Bob Phillips	2	519
Excel references to other sheets kmhog	by kmhog	2	531
How do I get multiple matches when using the Vlookup function? Lisa F	by Biff	1	1,081
Subtototal display is in different order than 2002, why? Charles	by Charles	4	400
look up functions Misti	by Biff	2	333
How do I do a Reverse Find/Search in Excel? NumberDocc	by NumberDocc	2	6,782
List info if criteria is met? Lynn	by Biff	2	344
only printing certain rows StephB	by Elkar	2	438
converting julian day and year to a date? Chad Nordberg	by Roger Govier	1	860
Page Break Problem top.jimmy	by top.jimmy	6	921
range_lookup in lookup functions mkbatch	by Biff	2	531
Creating Array from Pivot Table WCoaster	by Ken Wright	3	898
information function - does cell contain reference R of Steinke	by JE McGimpsey	1	387
Macro Question sony654	by Ken Wright	3	653
Need Help With Formula/Function scchang	by scchang	2	407
How can I make an excel cell equal to the value of a frame object text box directionalman	by directionalman	1	1,851
Hide previously used items from multiple drop lists ron	by ron	0	1,308
how can i view the range of 75% of a column Suszn	by Ivo	1	347
Find Formula Problem thigley986	by Kevin Vaughn	4	425
Employees Rosco58	by Rosco58	0	430
Repeat Rows Susan	by Duke Carey	1	371
Database gordo	by gordo	2	298
How do I show True as a value in Excel B2 if Cell B1 is bold? Gary	by Jim Thomlinson	3	1,029