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	563
Problems with formulas and sorting KatrinaSCC	by KatrinaSCC	2	578
Rounding Error when adding or subtracting two cells mtheo	by Jerry W. Lewis	2	894
can you assign random numbers to many different lines of row? random number generator	by Jerry W. Lewis	3	787
creating macro working across multiple sheets Nicole Seibert	by Jim Thomlinson	8	1,075
Why sometimes excel returns error just because function parameters are linked? Paul134	by Paul134	2	810
Cannot hide columns in Excel John Johns	by CLR	1	983
Vlookup... NWO	by Kevin Vaughn	14	691
List Box with macro VETcalc	by VETcalc	2	983
Copy-Paste sheets - error in the dates Aninha	by Dave Peterson	1	843
Create Lookup Table Matt	by	3	525
AVERAGE DAYS OPEN IF BETWEEN DATES kathi	by kathi	4	757
Creating a formula by using data in another file Mindy	by Duke Carey	2	449
format a drop-down box from a range of cell from another work... Jay Trull	by Jay Trull	2	362
Remove all formatting ragtopcaddy	by SteveG	3	382
Formula for Excel GSO	by CLR	2	318
Copt data with specific criteria Decreenisi	by CLR	2	314
Excel 2002 formula displayed not value formula option not checked Dean	by Duke Carey	1	1,874
VLOOKUP to return first hit Max	by Max	2	518
Looking up a value based on date and time, what's wrong? Margo Guda	by Margo Guda	3	421
assign macro PH NEWS	by PH NEWS	2	567
SUMPRODUCT - Help ceemo	by SteveG	16	835
Vlookup show #N/A Tias	by Engineering Accountant	1	405
pls help again! shirley	by shirley	6	295
MACRO QUESTION Eddy Stan	by Eddy Stan	2	370
Can this be done with Domain Functions? Johnny Meredith	by Johnny Meredith	4	367
How to use if statement whiteswan	by Dav	5	321
Lookup Formula Help - PLEASE! VickyC	by Dav	4	402
Calculated Field in A Pivot Matt D Francis	by Matt D Francis	0	447
Close Dos from Vba? Jason	by Jason	0	480
Help again please Keith Crooks	by tony h	4	317
Function giving a result for number within a range [email protected]	by CLR	3	462
Accessing the sheetname in a cell Kanagabalan	by CLR	4	403
=AVERAGE(IF(INT(MONTH(C:C)+2/3)=4 kathi	by kathi	5	585
transferring data between 2 worksheets in same workbook bigdaddy3	by bigdaddy3	0	864
Incrementing numbers Floyd107	by MartinW	2	625
Linking formulas in new sheets based on a template? Olle Svensson	by Roger Govier	1	636
sorting with RANK/VLOOKUP (problem with equal ranks) hip	by Max	2	1,796
Variable criteria formula Brent	by Biff	4	514
Drop-Down List DolittleDustoff	by Max	1	360
dates into ages Caz	by Peo Sjoblom	1	376
Complex function....not sure how if the result I want is possible Besseme	by bpeltzer	1	278
Amending an existing function Paydog4	by Paydog4	2	407
SUMIF Ferg	by Debra Dalgleish	3	1,090
Is there a formula tutorial online ............................... Denny Crane	by Peo Sjoblom	2	397
Function similar to SHIFT+CTRL+DOWN KEY Dan	by Dan	8	375
How do I sum a range of data (column) that has #num! in some cells steve_sr2	by steve_sr2	2	362
How to prevent copied data from appearing until triggered by anoth Denny Crane	by Denny Crane	2	540
Dividing a time span into shifts - overlapping days Heidi	by Pete_UK	17	2,230
Offset Function Trouble, Please Help Rabbit	by Max	7	559
in excel worksheet, add numbers in column k2&k3 monroe	by Gary''s Student	1	598
I have lost the in cell drop down in validation Stan Lawson	by Bob Phillips	2	536
Excel references to other sheets kmhog	by kmhog	2	544
How do I get multiple matches when using the Vlookup function? Lisa F	by Biff	1	1,097
Subtototal display is in different order than 2002, why? Charles	by Charles	4	409
look up functions Misti	by Biff	2	344
How do I do a Reverse Find/Search in Excel? NumberDocc	by NumberDocc	2	6,799
List info if criteria is met? Lynn	by Biff	2	352
only printing certain rows StephB	by Elkar	2	454
converting julian day and year to a date? Chad Nordberg	by Roger Govier	1	894
Page Break Problem top.jimmy	by top.jimmy	6	945
range_lookup in lookup functions mkbatch	by Biff	2	547
Creating Array from Pivot Table WCoaster	by Ken Wright	3	926
information function - does cell contain reference R of Steinke	by JE McGimpsey	1	405
Macro Question sony654	by Ken Wright	3	683
Need Help With Formula/Function scchang	by scchang	2	421
How can I make an excel cell equal to the value of a frame object text box directionalman	by directionalman	1	1,977
Hide previously used items from multiple drop lists ron	by ron	0	1,323
how can i view the range of 75% of a column Suszn	by Ivo	1	356
Find Formula Problem thigley986	by Kevin Vaughn	4	444
Employees Rosco58	by Rosco58	0	445
Repeat Rows Susan	by Duke Carey	1	381
Database gordo	by gordo	2	300
How do I show True as a value in Excel B2 if Cell B1 is bold? Gary	by Jim Thomlinson	3	1,061