Excel Worksheet Functions - Page 539

Thread / Thread Starter	Last Post	Replies	Views
Averaging values from a list, based on user input MWS	by T. Valko	3	621
search and change without replacing-excel 2002 islander	by Gord Dibben	1	354
Color of @IF Results Cell dog25	by Gord Dibben	2	525
formula needed to bring values to another sheet veena	by Duke Carey	2	730
how do I change the colour of selected auto filter tabs stan zawadzki	by Roger Govier	2	512
Functions to ignore hidden rows hmm	by Peo Sjoblom	2	2,015
VIN Number sorting HRassist	by Gord Dibben	10	1,565
Text import/ Text to Column anto	by Roger Govier	7	559
Combo Box Donovan[_2_]	by [email protected]	1	346
TimeSheet calculatons Overnights DonElston	by DonElston	4	357
Pivot table calculated field Neil T	by Neil T	2	1,134
My formula is =IF(B5="B",TODAY(),"") Tredown	by Teethless mama	3	405
It's a filter but not a filter [email protected]	by bj	2	330
LOOKUP across Multiple Sheets LeeM	by LeeM	4	1,097
give text a dollar numeric value Gav	by Bob Phillips	6	1,115
Count Text within Multiple Worksheets Laffin	by Laffin	10	1,809
Looking up and reporting values across tabs [email protected]	by [email protected]	0	387
maybe by sumproduct or some other way with text. driller	by Roger Govier	4	467
Conditional Ranking [email protected]	by T. Valko	8	3,243
Lookup Claudio Funes	by T. Valko	11	781
Is there any way to delete a Digital Certificate Mac Lingo	by Mike Rogers[_2_]	2	3,198
Conditional Selection [email protected]	by [email protected]	1	575
Need to 'COUNT'... Wendy	by Ragdyer	5	380
Auto scroll down event andy62	by andy62	6	1,287
find expired dates =IF((E11-TODAY()<0), "EXPIRED", "OK") Jo	by Gary''s Student	1	942
Protected worksheet baseballmm	by Harlan Grove[_2_]	1	745
How do I change minutes (1.5) to 01:30? Sewall6606	by Peo Sjoblom	3	948
OFFSET: Returns error when used to a linked file Arturo	by Harlan Grove[_2_]	1	1,441
Can I have the TAB name be a calculated field...? Kelvin Beaton	by JE McGimpsey	14	951
Calculating earliest start and latest end dates by contract Data Analyst	by Ron Rosenfeld	4	1,975
Offset / Match / MAtch Michel Khennafi	by Peo Sjoblom	2	617
columns to rows based on record criteria AA81	by Tom Hutchins	1	421
Multiple Lookup Application JAD	by T. Valko	2	505
Having trouble nesting function. Bill R	by JustBreathe	2	388
Can you attach, hyperlink or embed Email Items in a SS? JustBreathe	by JustBreathe	0	1,046
Choosing last set of data in column Erik	by Toppers	11	905
Date Generation Amanda	by Ron Rosenfeld	4	634
Weekend Pass Codes	by Teethless mama	2	526
matching fields between two workbooks tukky142	by bj	1	597
How do I run a macro from inside an"=IF" formula in Excel 2003? Drawn83	by moon	1	540
adding time GrayC011182	by Peo Sjoblom	2	482
Array Formula Using LOOKUP function. luchshel	by Ron Coderre	9	513
Conditional Formatting singingsister	by bj	11	1,024
combining cells wayne	by David Biddulph[_2_]	3	470
Need to do an EXACT LOOKUP archsmooth	by Niek Otten	1	502
DCOUNT problem with numbers stored as text MJP[_2_]	by Peo Sjoblom	9	616
How to auto fill with fifth cell in a column? Asghar Gill	by Max	4	732
Average Cham	by Cham	0	365
VLOOKUP Jerry[_2_]	by Jerry[_2_]	2	357
Command Button to run a Macro Mark Allen	by Mark Allen	2	758
Time Formula Gav123	by Gav123	5	404
Auto Filter function only provide 2 criteria input Kent	by Kent	5	500
how to change coloum to row sangeet	by Max	5	667
problem updating links unless sources are open Sue	by bj	1	719
Ranking or sorting function craig	by Max	4	782
?? What Function Do I Need ?? Alan Foxmore	by Bernd	8	524
How to divide a number into various denominators maa	by Ron Rosenfeld	3	1,391
Fomulas with tex and numbers in same cell Sue F	by Ron Coderre	2	454
ecel:create a file name from data in worksheet carter30	by Susan	1	557
Excel VBA help tmobccr2	by Don Guillett	4	667
formula calculation barry28	by barry28	4	551
Basic formula - forgotton !! Mark Allen	by Mark Allen	5	418
Comparing two lists using Conditional Formatting [email protected]	by [email protected]	3	704
Concatenate format Tom	by Bob Phillips	5	648
Calculation of Area Under a Plotted Graph un1c0rn	by DazzaData	1	924
Linking Excel and Access to import a single record from DB S Willingham	by S Willingham	4	735
conversionof numeric data in word probir	by Harlan Grove[_2_]	3	473
Return an absolutely empty cell ... but not "" Billy Leung	by Billy Leung[_2_]	3	642
linking some templates automatically to the consolidated template? Ray	by Ray	0	548
Apply conditional formatting to individual cell Excel 2007 James D	by T. Valko	3	971
how do i create table of contents links/pg for multiple workbooks JRoss	by Gord Dibben	1	638
SUMPODUCT - Some one please help !!! Mark Allen	by Rick Rothstein \(MVP - VB\)	5	503
copy cells Pass Codes	by Gord Dibben	4	473
function for repeated cells Haz	by Rick Rothstein \(MVP - VB\)	7	836
Array formula on INDEX function not working vsoler	by Bob Phillips	8	1,577