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	623
search and change without replacing-excel 2002 islander	by Gord Dibben	1	365
Color of @IF Results Cell dog25	by Gord Dibben	2	532
formula needed to bring values to another sheet veena	by Duke Carey	2	733
how do I change the colour of selected auto filter tabs stan zawadzki	by Roger Govier	2	513
Functions to ignore hidden rows hmm	by Peo Sjoblom	2	2,025
VIN Number sorting HRassist	by Gord Dibben	10	1,572
Text import/ Text to Column anto	by Roger Govier	7	571
Combo Box Donovan[_2_]	by [email protected]	1	347
TimeSheet calculatons Overnights DonElston	by DonElston	4	358
Pivot table calculated field Neil T	by Neil T	2	1,144
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	342
LOOKUP across Multiple Sheets LeeM	by LeeM	4	1,103
give text a dollar numeric value Gav	by Bob Phillips	6	1,131
Count Text within Multiple Worksheets Laffin	by Laffin	10	1,818
Looking up and reporting values across tabs [email protected]	by [email protected]	0	394
maybe by sumproduct or some other way with text. driller	by Roger Govier	4	467
Conditional Ranking [email protected]	by T. Valko	8	3,247
Lookup Claudio Funes	by T. Valko	11	784
Is there any way to delete a Digital Certificate Mac Lingo	by Mike Rogers[_2_]	2	3,214
Conditional Selection [email protected]	by [email protected]	1	587
Need to 'COUNT'... Wendy	by Ragdyer	5	392
Auto scroll down event andy62	by andy62	6	1,301
find expired dates =IF((E11-TODAY()<0), "EXPIRED", "OK") Jo	by Gary''s Student	1	943
Protected worksheet baseballmm	by Harlan Grove[_2_]	1	745
How do I change minutes (1.5) to 01:30? Sewall6606	by Peo Sjoblom	3	951
OFFSET: Returns error when used to a linked file Arturo	by Harlan Grove[_2_]	1	1,448
Can I have the TAB name be a calculated field...? Kelvin Beaton	by JE McGimpsey	14	959
Calculating earliest start and latest end dates by contract Data Analyst	by Ron Rosenfeld	4	1,976
Offset / Match / MAtch Michel Khennafi	by Peo Sjoblom	2	619
columns to rows based on record criteria AA81	by Tom Hutchins	1	434
Multiple Lookup Application JAD	by T. Valko	2	517
Having trouble nesting function. Bill R	by JustBreathe	2	396
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	920
Date Generation Amanda	by Ron Rosenfeld	4	641
Weekend Pass Codes	by Teethless mama	2	526
matching fields between two workbooks tukky142	by bj	1	600
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	484
Array Formula Using LOOKUP function. luchshel	by Ron Coderre	9	527
Conditional Formatting singingsister	by bj	11	1,038
combining cells wayne	by David Biddulph[_2_]	3	470
Need to do an EXACT LOOKUP archsmooth	by Niek Otten	1	503
DCOUNT problem with numbers stored as text MJP[_2_]	by Peo Sjoblom	9	626
How to auto fill with fifth cell in a column? Asghar Gill	by Max	4	735
Average Cham	by Cham	0	371
VLOOKUP Jerry[_2_]	by Jerry[_2_]	2	361
Command Button to run a Macro Mark Allen	by Mark Allen	2	768
Time Formula Gav123	by Gav123	5	405
Auto Filter function only provide 2 criteria input Kent	by Kent	5	514
how to change coloum to row sangeet	by Max	5	667
problem updating links unless sources are open Sue	by bj	1	732
Ranking or sorting function craig	by Max	4	795
?? What Function Do I Need ?? Alan Foxmore	by Bernd	8	532
How to divide a number into various denominators maa	by Ron Rosenfeld	3	1,396
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	570
Excel VBA help tmobccr2	by Don Guillett	4	679
formula calculation barry28	by barry28	4	557
Basic formula - forgotton !! Mark Allen	by Mark Allen	5	418
Comparing two lists using Conditional Formatting [email protected]	by [email protected]	3	716
Concatenate format Tom	by Bob Phillips	5	654
Calculation of Area Under a Plotted Graph un1c0rn	by DazzaData	1	927
Linking Excel and Access to import a single record from DB S Willingham	by S Willingham	4	750
conversionof numeric data in word probir	by Harlan Grove[_2_]	3	481
Return an absolutely empty cell ... but not "" Billy Leung	by Billy Leung[_2_]	3	644
linking some templates automatically to the consolidated template? Ray	by Ray	0	557
Apply conditional formatting to individual cell Excel 2007 James D	by T. Valko	3	983
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	508
copy cells Pass Codes	by Gord Dibben	4	474
function for repeated cells Haz	by Rick Rothstein \(MVP - VB\)	7	846
Array formula on INDEX function not working vsoler	by Bob Phillips	8	1,589