Excel Worksheet Functions - Page 101

Thread / Thread Starter	Last Post	Replies	Views
"table of contents" senario RGlade	by Max	7	414
Anniversary of a date is due - conditional formatting Carl Mountney	by Bernie Deitrick	7	1,580
Can users perform a reverse lookup Blue Max	by bcw_now[_2_]	7	709
Auto enter current date in cell when another changed Andy Smith[_3_]	by Gord Dibben	7	1,732
Goal-Seek Question Smita	by Dana DeLouis	7	475
Time for IFERROR? PAL	by Bob Phillips	7	836
Time series calculation RD Wirr	by Ron Rosenfeld	7	926
searching for just the month [email protected]	by Max	7	422
Combo Box Morfeo	by Dave Peterson	7	376
is blank AND is error jane	by Dave Peterson	7	487
Help with SUMPRODUCT Alex Mackenzie	by Dave Peterson	7	368
calculating working hours between 2 dates Jani Ruohomaa	by Mike H	7	656
remove leading spaces harwookf	by Pete_UK	7	783
counting numbers?? bouncebackability	by T. Valko	7	426
SUMIF? Question aeddave	by aeddave	7	513
millisecond Dan	by David Biddulph[_2_]	7	402
Validation - e-mail Theo	by Theo	7	438
Extract part of a text string Martin B	by Martin B	7	753
custom add formula Kelly********	by T. Valko	7	459
Using Macros To Perform Multiple Averages d__o__a	by d__o__a[_2_]	7	528
Function returning unexpected value Paul	by JoeU2004	7	489
VLOOKUP or MATCH and/or INDEX to extract value on a given date Don Kline[_2_]	by Max	7	1,014
Help with formula Josh W	by JoeU2004	7	508
Sumproduct formula not working Vince	by Don Guillett	7	499
If, VLookup, Index, or a combination of all of them? LisaM	by T. Valko	7	641
Average with specific criteria Clari	by Teethless mama	7	650
Need Help to repeat a symbol in each cell in a column MicrosoftUserDarren	by Max	7	1,387
SUM of areas Natalie	by Max	7	616
Max date only against met criteria Nelson	by T. Valko	7	808
IF HELP MIKE F	by Sandy Mann	7	494
Function to add 3 column (of YES) to give a total % complete preyesone	by Ken	7	520
How to not get '0' or '#DIV/0!' in a cell with a percentage formul Rum	by Jacob Skaria	7	627
Make them work on the Each cell Value Steved	by T. Valko	7	460
Can I use an "If, then" function here... jkramos2005	by smartin	7	452
Excel Macro Val H	by TheQuickBrownFox	7	369
How to average the last 10 numbers in a row? John P[_2_]	by John P[_2_]	7	1,078
Formulas refuse to update spartina_patens	by Luke M	7	659
variable consolidation ending tab name Seaq	by Seaq	7	406
Can I find and replace "white space" in a cell in Excel? biggyb75	by JE McGimpsey	7	2,650
Difficult formula SUMPRODUCT,MATCH,WEEKDAY edwardpestian	by daddylonglegs	7	418
Deleting and shifting cells and columns Curt1521	by Kevin Vaughn	7	772
More elegant way to do IF () Barb Reinhardt	by Aladin Akyurek	7	489
Advanced formula - Return result & Show Cell Reference of result Irv	by Irv	7	2,000
entering date functions Gail	by Roger Govier	7	480
SUMIF with two conditions? Lee Harris	by Ken Wright	7	555
MAX function for a given Position Title Rich	by Rich	7	363
SUMIF Returns a #VALUE error when external source is closed ghynes	by Domenic	7	1,281
Change row selection Farrel	by Aladin Akyurek	7	367
How to be noticed/to avoid equal values in a colum Irene	by Irene	7	515
date/time stamp Jan	by DKY	7	1,375
using formula to compare two text lists that are not alike and ma. Maggie	by JulieD	7	571
fixed decimals GreenThumb	by Gord Dibben	7	712
Formula Trouble JS	by JulieD	7	633
ACCRINT formula yields incorrect result Onurali_k	by Onurali_k	7	970
Wildcards with SumProduct pomalley	by pomalley	7	1,030
Conditional Formating - not in table GregR	by GregR	7	545
Function to Return another Worksheets Name Dawg House Inc	by Arvi Laanemets	7	1,020
Count working days by week inta251	by inta251 via OfficeKB.com	7	973
If Date Null Show Nothing Ardy	by Ardy	7	2,077
How to determine if a cell has a value, then copy it to a new loca Shelly	by Dave Peterson	7	1,787
Running total question Mike Hyndman	by Mike Hyndman	7	643
Return Unique Duplicate Numeric Values across Single Row Sam via OfficeKB.com	by T. Valko	7	891
Formula problems Lago2004	by Gord Dibben	7	868
excell windows 03 cond format help John	by Bernard Liengme	7	561
value expression RayB	by driller	7	702
Workday Date Calculation kdlilly	by Paul B	7	563
Better autonumbering formula? Dan in NY	by Fredrik Wahlgren	7	574
Formula to stop adding at a positive number nkhelp	by driller	7	522
formula susan8541	by susan8541	7	492
Question [email protected]	by Gord Dibben	7	544
I want brackets around my math equation answer? Ms Serene	by Captain	7	437
Lookup using more than one criteria Beccy	by Pete_UK	7	502
Merging 2 cells together and prefixing fuzzyjon	by fuzzyjon	7	447
Time between days RamOst	by Ardus Petus	7	583
How do I add parenthesis to my phone number list -the area code? Alan	by Harlan Grove	7	3,664