Excel Worksheet Functions - Page 371

Thread / Thread Starter	Last Post	Replies	Views
Use cell references in external queries johnb49	by Pete_UK	1	447
Auto "convert" a number to a different number Rick	by Rick	4	451
Conditional Formatting with Dates BillXMachina	by David Biddulph[_2_]	3	564
vlookup Dale G[_2_]	by Max	1	298
Using VLOOKUP and "AND" together chocoman	by Pete_UK	5	337
vlookup/match to find column name sailingHLA	by Jim Cone[_2_]	2	659
NOW AND TODAY THill	by T. Valko	8	489
Totaling DATEDIF SUMS kathi	by daddylonglegs	4	554
date computing and sum issues lampatmyfeet	by Pete_UK	6	518
Excel 2003 Multi Worksheet Sumproduct? wild turkey no9	by T. Valko	4	623
Advanced Apology Wilson	by Bernd P	14	789
AutoFill with sheet reference help TimeCloud	by T. Valko	3	945
change a Figures into text in my excel exp. 200-two hundred Kems	by Pete_UK	2	1,046
How can I add "monthly" tabs that summarize a yearly report? eg2008	by Fred Smith[_4_]	3	1,232
Editing Text and file location for Hyperlinks forest8	by Gary''s Student	1	468
Format a blank cell based on the value of another cell tracktor	by tracktor	2	577
emptying the contets of a cell base on the value of another cell tracktor	by tracktor	3	458
excel formulas Lbruce	by Max	1	407
non match result Belinda7237	by Max	3	417
Conditional formula(s) & labelling MNF	by T. Valko	4	456
#VALUE! nso	by Max	4	480
Match formula question Belinda7237	by Max	6	449
VLOOKUP or MATCH or ? FJ	by T. Valko	1	364
Vlookup or match function? Belinda7237	by Belinda7237	6	588
VLOOKUP Connie Martin	by Pete_UK	5	370
Returning a value in one cell based on the criteria of another cel Kirstin	by Dave	2	503
I have a problem using excel sunny	by Gord Dibben	7	478
Copy and paste absolute reference lea	by Gord Dibben	3	1,457
AutoFill with sheet reference help TimeCloud	by TimeCloud	0	532
Formatting a row to insert current date and time on demand MorseCode	by JE McGimpsey	1	439
need to move data to certain column if they meet criteria klafert	by klafert	0	407
I want quarters not months LiveUser	by Fred Smith[_4_]	5	466
If then copy to maggiesteele	by Dave	1	387
linking worksheets to a closed workbook LLK	by Pete_UK	2	371
how to ungroup work sheets sreenivasan k.r.	by Pete_UK	1	604
help with IF formula nso	by Dave	2	424
Unique Records Count with AutoFilter Danni2004	by Danni2004	1	464
Help with Countif Adam	by Adam	2	521
result of formula posted in different cell Pete_UK	by Pete_UK	1	620
Can I turn the #N/A result from a lookup function to a zero? Chase	by Gaurav[_3_]	4	2,993
SumIF Flanno	by Mike H	3	373
Losing Cell Format In Lookup Function Jay	by [email protected]	1	570
Remove trailing spaces from multiple columns in Excel dcaissie	by Reitanos	8	6,017
How do I display character count on the status bar? user061803	by Billy Liddel	2	4,197
help with sum if Trixie	by Trixie	5	399
index & match krrish_a	by ryguy7272	1	1,418
Conditional Formatting with Dates (Revised) BillXMachina	by BillXMachina	5	412
Set up many cells within a cell jrps	by David Biddulph[_2_]	7	438
Need to reorganize data on a separate sheet possibly using vlookup Asa_johannesen	by Asa_johannesen	2	601
Averaging only visible cells Bear Black	by Bear Black	4	473
Date Question GMc[_2_]	by T. Valko	3	312
Here's a doozy Wilson	by Roger Govier[_3_]	1	336
Looks like a comment, but isn't.... what is the yellow box called? Retail Services[_2_]	by Gary''s Student	2	7,136
"nesting"? nso	by nso	2	300
Find values on another sheet Joe Gieder	by Peo Sjoblom	5	445
Two columns of data - How to get the unmatching cell data to colum Cpviv	by Gaurav[_3_]	1	401
Formula not working Carolina Girl	by PCLIVE	4	314
PIVOT HELP CHARI	by Roger Govier[_3_]	3	348
How do I enter data on one worksheet and have it appear on another Walker28	by Gaurav[_3_]	1	382
Date-Mid Function [email protected]	by Dana DeLouis	12	788
How can i make a cell compulsory to complete? mrh1973	by Bernie Deitrick	1	1,456
fill autoshape color with ref cell conditional formatting Julie	by Debra Dalgleish	1	2,363
please help, need to copy row to separate spreadsheet in workbook nso	by nso	1	683
excell scott haupt	by Spiky	1	336
Is merging rows possible? Mr BT[_2_]	by Mr BT[_2_]	1	553
count unique in non-continuous list Hans	by Hans	3	924
Unwanted Jump to Linked Workbook slreilly	by slreilly	0	409
make VLINKUP like vlookup; smart hyperlink by data value wizard61	by Pete_UK	3	547
create a spreadsheet that would insert a current date() when opene Testudo	by Testudo	2	432
Formatting imported data [email protected]	by [email protected]	0	361
Color doesn't display -all black & white Sally in Cleveland	by Sally in Cleveland	0	468
Validation with if Spade	by Sandy	1	372
IRR on conditional subset of cashflows Schwartz	by Schwartz	0	1,456
Multiple If Statements Tigerwould	by Bernard Liengme	6	699
VLOOKUP Question Susan	by Susan	4	451