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	531
problem using Range Names in VLOOKUP Dee	by Bob Phillips	6	566
Problems with formulas and sorting KatrinaSCC	by KatrinaSCC	2	591
Rounding Error when adding or subtracting two cells mtheo	by Jerry W. Lewis	2	896
can you assign random numbers to many different lines of row? random number generator	by Jerry W. Lewis	3	792
creating macro working across multiple sheets Nicole Seibert	by Jim Thomlinson	8	1,078
Why sometimes excel returns error just because function parameters are linked? Paul134	by Paul134	2	813
Cannot hide columns in Excel John Johns	by CLR	1	996
Vlookup... NWO	by Kevin Vaughn	14	693
List Box with macro VETcalc	by VETcalc	2	987
Copy-Paste sheets - error in the dates Aninha	by Dave Peterson	1	849
Create Lookup Table Matt	by	3	535
AVERAGE DAYS OPEN IF BETWEEN DATES kathi	by kathi	4	758
Creating a formula by using data in another file Mindy	by Duke Carey	2	459
format a drop-down box from a range of cell from another work... Jay Trull	by Jay Trull	2	367
Remove all formatting ragtopcaddy	by SteveG	3	395
Formula for Excel GSO	by CLR	2	329
Copt data with specific criteria Decreenisi	by CLR	2	327
Excel 2002 formula displayed not value formula option not checked Dean	by Duke Carey	1	1,886
VLOOKUP to return first hit Max	by Max	2	527
Looking up a value based on date and time, what's wrong? Margo Guda	by Margo Guda	3	433
assign macro PH NEWS	by PH NEWS	2	569
SUMPRODUCT - Help ceemo	by SteveG	16	835
Vlookup show #N/A Tias	by Engineering Accountant	1	406
pls help again! shirley	by shirley	6	296
MACRO QUESTION Eddy Stan	by Eddy Stan	2	374
Can this be done with Domain Functions? Johnny Meredith	by Johnny Meredith	4	380
How to use if statement whiteswan	by Dav	5	333
Lookup Formula Help - PLEASE! VickyC	by Dav	4	402
Calculated Field in A Pivot Matt D Francis	by Matt D Francis	0	456
Close Dos from Vba? Jason	by Jason	0	490
Help again please Keith Crooks	by tony h	4	322
Function giving a result for number within a range [email protected]	by CLR	3	470
Accessing the sheetname in a cell Kanagabalan	by CLR	4	411
=AVERAGE(IF(INT(MONTH(C:C)+2/3)=4 kathi	by kathi	5	590
transferring data between 2 worksheets in same workbook bigdaddy3	by bigdaddy3	0	869
Incrementing numbers Floyd107	by MartinW	2	633
Linking formulas in new sheets based on a template? Olle Svensson	by Roger Govier	1	645
sorting with RANK/VLOOKUP (problem with equal ranks) hip	by Max	2	1,809
Variable criteria formula Brent	by Biff	4	520
Drop-Down List DolittleDustoff	by Max	1	372
dates into ages Caz	by Peo Sjoblom	1	378
Complex function....not sure how if the result I want is possible Besseme	by bpeltzer	1	288
Amending an existing function Paydog4	by Paydog4	2	417
SUMIF Ferg	by Debra Dalgleish	3	1,096
Is there a formula tutorial online ............................... Denny Crane	by Peo Sjoblom	2	400
Function similar to SHIFT+CTRL+DOWN KEY Dan	by Dan	8	382
How do I sum a range of data (column) that has #num! in some cells steve_sr2	by steve_sr2	2	374
How to prevent copied data from appearing until triggered by anoth Denny Crane	by Denny Crane	2	550
Dividing a time span into shifts - overlapping days Heidi	by Pete_UK	17	2,234
Offset Function Trouble, Please Help Rabbit	by Max	7	561
in excel worksheet, add numbers in column k2&k3 monroe	by Gary''s Student	1	601
I have lost the in cell drop down in validation Stan Lawson	by Bob Phillips	2	544
Excel references to other sheets kmhog	by kmhog	2	556
How do I get multiple matches when using the Vlookup function? Lisa F	by Biff	1	1,107
Subtototal display is in different order than 2002, why? Charles	by Charles	4	413
look up functions Misti	by Biff	2	357
How do I do a Reverse Find/Search in Excel? NumberDocc	by NumberDocc	2	6,811
List info if criteria is met? Lynn	by Biff	2	356
only printing certain rows StephB	by Elkar	2	464
converting julian day and year to a date? Chad Nordberg	by Roger Govier	1	894
Page Break Problem top.jimmy	by top.jimmy	6	956
range_lookup in lookup functions mkbatch	by Biff	2	551
Creating Array from Pivot Table WCoaster	by Ken Wright	3	933
information function - does cell contain reference R of Steinke	by JE McGimpsey	1	417
Macro Question sony654	by Ken Wright	3	687
Need Help With Formula/Function scchang	by scchang	2	427
How can I make an excel cell equal to the value of a frame object text box directionalman	by directionalman	1	1,982
Hide previously used items from multiple drop lists ron	by ron	0	1,335
how can i view the range of 75% of a column Suszn	by Ivo	1	361
Find Formula Problem thigley986	by Kevin Vaughn	4	444
Employees Rosco58	by Rosco58	0	446
Repeat Rows Susan	by Duke Carey	1	390
Database gordo	by gordo	2	311
How do I show True as a value in Excel B2 if Cell B1 is bold? Gary	by Jim Thomlinson	3	1,068