Excel Worksheet Functions - Page 890

Thread / Thread Starter	Last Post	Replies	Views
reverse vlookup John	by John	0	576
Matrix to single column RD Wirr	by RD Wirr	13	1,418
A function to make date red if it is over 30 days old Financial Admin	by Financial Admin	2	1,138
Rounding Up Decimals Lilbit	by Lilbit	8	535
Sorting Data Automatically Sabunabu	by Martin P	2	400
Lookup based on fractional value Ted Metro	by Ted Metro	2	365
"Can I create a subtab in a tab in Excel worksheet?" Number 9	by Number 9	0	1,187
moving a macro to a new workbook KARomain	by Gary L Brown	1	421
How to replicate 1 range to muptiple ranges at once? Ann	by Gary L Brown	1	350
Microsoft Map Object cwinters	by Gary L Brown	1	391
Lookup Two Columns macshimi	by macshimi	5	719
Hidden Values Loonball81	by Niek Otten	1	366
TRUE/FALSE Krish	by Per Erik Midtrød	5	307
Compare Sheet Cell to Sheet Column Brenda	by Brenda	2	653
Pivot Tables Sum of Unique Text Entries Jen	by Jen	0	540
Output in Column A based on Input in Column B SteveC	by SteveC	10	1,179
find sum in list of of numbers Jim Thomlinson	by Jim Thomlinson	5	954
Why would a formula stop working in an Excell spreadsheet? Number one Giraffe	by Daryl	4	998
Total TIme worked jlogan21	by jlogan21	2	595
sum up the ROW values with ref to COLUMN values! via135	by via135	6	325
Hide cell value conditional on its value pstar	by intruder9	2	499
drop-down list changing according to choice made choc_penguin	by Ron Coderre	1	766
how to change a date format lcardwell	by lcardwell	5	342
Adding relevant sheets Gavin Ling	by Gavin Ling	0	450
Convert Gig to Meg John Schneider	by John Schneider	6	812
Excel 2003 - SUM Formula - exclude cell Peppermint	by Bob Phillips	2	1,165
Convert $ amount from excel to access? No decimals but 00 at end Nicole	by William Horton	1	749
want to ask salutation on a mailing list. lupetunes	by lupetunes	0	379
=SUMPRODUCT formula help Anthony	by Anthony	5	522
How do I add using several worksheets Lee R. Crawford	by intruder9	2	288
Sheet Protection Status Andy Williams	by William Horton	1	420
custom worksheet functon is changed to lowercase Richard	by Richard	0	313
help please Stuart Arnold	by intruder9	1	307
conditioned functions John	by SteveG	1	382
How do I get Exel to return # of hrs. worked, start time is enter joyce007	by Vito	1	552
how to get left or right cell info after getting the result for ma Arumugam Ramachandra	by Roger H.	1	351
DIFFERENT NAMED CELLS IN COLUMN,HOW DO I GET LAST ONE ON BOTTOM? Confused at Work	by Confused at Work	0	382
conditioned functions John	by Bob Phillips	1	383
Defining Cell namse after they are used in a function Mariano	by Mariano	3	367
Lookup array? HBj	by HBj	2	476
How do I get rid of the Page # on screen darthjure	by John Michl	1	484
Find Macro across workbook [email protected]	by John Michl	3	487
IS THERE ANY PIVOT TABLE DROP LIST FUNCTION? william	by Debra Dalgleish	1	497
piviot table hshayh0rn	by hshayh0rn	1	529
I get error with "ROWS" in the formula - nested formula question Marie J-son	by Marie J-son	0	729
countif, sumif, sumproduct - I dont know which to use Jim	by Duke Carey	3	519
help zomex	by Ron Coderre	1	441
help needed zomex	by Ron Rosenfeld	5	500
Can I delete multiple blank rows collectively? bursar	by Bob Phillips	1	577
Ms Excel coursework aisha	by Bob Phillips	1	442
Matching Values from an Array Mal	by Mal	2	833
how do write the amount of a number in text? Alejandro-Venezuela	by Boris Merryweather	1	481
Comparing scenarios/forecasts in Excel Nemo Dat	by Nemo Dat	0	379
Adding to a column of numbers Colleen	by JulieD	1	724
help zomex	by JulieD	1	420
how do i copy only the coloured filled rows in excel to new sheet Kate at work	by Kate at work	2	833
Summary of multiple spreadsheets: Peter	by Peter	2	706
Maintain Relative Reference After Inserting a Column Mark T.	by Mark T.	3	886
Help with a combination of formula's Smiles	by Peo Sjoblom	1	372
Is it possible to make a cell flash between 2 colours? barry24uk	by barry24uk	6	524
Update Chart Source (w/macro?) tx12345	by tx12345	0	622
Repairing link roots when moving worksheets mrbarnard	by paul	1	462
Countif - Buying Frequency JEFF	by JEFF	2	620
Summing part of a string excluding cells soph	by soph	2	470
enumerate sheet Philippe L. Balmanno	by Max	4	512
How do I create a commission chart based on dates worked? Orange Pegs in Cerritos	by Orange Pegs in Cerritos	0	581
summing part of a string, excluding cells soph	by soph	1	350
If it's not a space, return the cell contents. Gee...	by Gee...	3	890
Counting Using Multiple Criteria mhall5	by mhall5	4	815
How do I compare two lists and choose the items that are in both? laurabailey8	by laurabailey8	0	572
Countif formulas change after doing a sort Bob Smith	by RagDyer	3	1,213
Using Excel for a Mail Merge Dayna	by Dayna	0	800
subtotal question? wonderdogs828	by Bob Phillips	2	441
How do I assign a value to check box in excel [email protected]	by Biff	2	1,034
Will a Nested IF/SUMIF function instead of VBA? Ronny Hamida	by Ronny Hamida	5	960