Excel Worksheet Functions - Page 890

Thread / Thread Starter	Last Post	Replies	Views
reverse vlookup John	by John	0	579
Matrix to single column RD Wirr	by RD Wirr	13	1,428
A function to make date red if it is over 30 days old Financial Admin	by Financial Admin	2	1,148
Rounding Up Decimals Lilbit	by Lilbit	8	535
Sorting Data Automatically Sabunabu	by Martin P	2	408
Lookup based on fractional value Ted Metro	by Ted Metro	2	366
"Can I create a subtab in a tab in Excel worksheet?" Number 9	by Number 9	0	1,195
moving a macro to a new workbook KARomain	by Gary L Brown	1	426
How to replicate 1 range to muptiple ranges at once? Ann	by Gary L Brown	1	355
Microsoft Map Object cwinters	by Gary L Brown	1	398
Lookup Two Columns macshimi	by macshimi	5	724
Hidden Values Loonball81	by Niek Otten	1	370
TRUE/FALSE Krish	by Per Erik Midtrød	5	307
Compare Sheet Cell to Sheet Column Brenda	by Brenda	2	655
Pivot Tables Sum of Unique Text Entries Jen	by Jen	0	549
Output in Column A based on Input in Column B SteveC	by SteveC	10	1,194
find sum in list of of numbers Jim Thomlinson	by Jim Thomlinson	5	964
Why would a formula stop working in an Excell spreadsheet? Number one Giraffe	by Daryl	4	1,000
Total TIme worked jlogan21	by jlogan21	2	598
sum up the ROW values with ref to COLUMN values! via135	by via135	6	332
Hide cell value conditional on its value pstar	by intruder9	2	511
drop-down list changing according to choice made choc_penguin	by Ron Coderre	1	771
how to change a date format lcardwell	by lcardwell	5	354
Adding relevant sheets Gavin Ling	by Gavin Ling	0	461
Convert Gig to Meg John Schneider	by John Schneider	6	813
Excel 2003 - SUM Formula - exclude cell Peppermint	by Bob Phillips	2	1,177
Convert $ amount from excel to access? No decimals but 00 at end Nicole	by William Horton	1	761
want to ask salutation on a mailing list. lupetunes	by lupetunes	0	384
=SUMPRODUCT formula help Anthony	by Anthony	5	522
How do I add using several worksheets Lee R. Crawford	by intruder9	2	289
Sheet Protection Status Andy Williams	by William Horton	1	421
custom worksheet functon is changed to lowercase Richard	by Richard	0	313
help please Stuart Arnold	by intruder9	1	308
conditioned functions John	by SteveG	1	384
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	352
DIFFERENT NAMED CELLS IN COLUMN,HOW DO I GET LAST ONE ON BOTTOM? Confused at Work	by Confused at Work	0	392
conditioned functions John	by Bob Phillips	1	388
Defining Cell namse after they are used in a function Mariano	by Mariano	3	370
Lookup array? HBj	by HBj	2	485
How do I get rid of the Page # on screen darthjure	by John Michl	1	485
Find Macro across workbook [email protected]	by John Michl	3	494
IS THERE ANY PIVOT TABLE DROP LIST FUNCTION? william	by Debra Dalgleish	1	505
piviot table hshayh0rn	by hshayh0rn	1	530
I get error with "ROWS" in the formula - nested formula question Marie J-son	by Marie J-son	0	741
countif, sumif, sumproduct - I dont know which to use Jim	by Duke Carey	3	523
help zomex	by Ron Coderre	1	442
help needed zomex	by Ron Rosenfeld	5	503
Can I delete multiple blank rows collectively? bursar	by Bob Phillips	1	584
Ms Excel coursework aisha	by Bob Phillips	1	452
Matching Values from an Array Mal	by Mal	2	841
how do write the amount of a number in text? Alejandro-Venezuela	by Boris Merryweather	1	490
Comparing scenarios/forecasts in Excel Nemo Dat	by Nemo Dat	0	383
Adding to a column of numbers Colleen	by JulieD	1	734
help zomex	by JulieD	1	425
how do i copy only the coloured filled rows in excel to new sheet Kate at work	by Kate at work	2	839
Summary of multiple spreadsheets: Peter	by Peter	2	714
Maintain Relative Reference After Inserting a Column Mark T.	by Mark T.	3	889
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	530
Update Chart Source (w/macro?) tx12345	by tx12345	0	628
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	477
enumerate sheet Philippe L. Balmanno	by Max	4	521
How do I create a commission chart based on dates worked? Orange Pegs in Cerritos	by Orange Pegs in Cerritos	0	591
summing part of a string, excluding cells soph	by soph	1	360
If it's not a space, return the cell contents. Gee...	by Gee...	3	892
Counting Using Multiple Criteria mhall5	by mhall5	4	830
How do I compare two lists and choose the items that are in both? laurabailey8	by laurabailey8	0	576
Countif formulas change after doing a sort Bob Smith	by RagDyer	3	1,224
Using Excel for a Mail Merge Dayna	by Dayna	0	808
subtotal question? wonderdogs828	by Bob Phillips	2	444
How do I assign a value to check box in excel [email protected]	by Biff	2	1,049
Will a Nested IF/SUMIF function instead of VBA? Ronny Hamida	by Ronny Hamida	5	961