Excel Worksheet Functions - Page 1118

Thread / Thread Starter	Last Post	Replies	Views
Conditional Formatting for a dashboard with a drop down menu Kathy	by Kathy	0	704
Count with two criteria LisaK	by Pete_UK	2	396
LookUP function with multiple variables and worksheets mjwk	by Pete_UK	1	774
Sumproduct but only first time corresponding value is seen e.g. un ker_01	by T. Valko	1	629
formula patterns with a gap of two Mr L Hibbert	by Mr L Hibbert	0	696
Average with Conditions Curtis[_2_]	by T. Valko	3	366
Average with Condition Curtis[_2_]	by Paul C	4	497
retrieving current data dave303159	by Otto Moehrbach[_2_]	1	418
Conditions Not Accurate when subtracting time sly411	by sly411	3	641
sumif concatenate formula Robb27	by Lars-Åke Aspelin[_4_]	4	1,173
Hlookup with Merged cell as look up value srs	by T. Valko	1	2,724
Conditional Format for Blank Cells LSG	by LSG	5	1,725
How to omit blank cells when calculating weighted averages Suzy	by T. Valko	20	2,236
Restrict data entry in a cell Ephraim	by T. Valko	3	714
Countif Function?? Kevan	by T. Valko	3	516
Odd Drop Down Box Behavior Squeaky	by Gord Dibben	4	658
loan amortization template jjbud44	by Dana DeLouis[_3_]	2	936
subtraction returning incorrect calue Ashish_Vaidya	by Fred Smith[_4_]	5	1,207
VLOOKUP with HLOOKUP XKruodo	by XKruodo	2	487
Conditional Formatting with 3 Criteria Options Nickle	by David Biddulph[_2_]	5	603
paste values Excel 2007 Diamond	by Matt Geare[_2_]	2	1,161
IF statement based on True/False that activates a certain list box rittzy	by Jacob Skaria	1	912
Electricity Bill Sheet XKruodo	by XKruodo	6	2,862
Workday function not working Cam	by Shaz[_2_]	6	1,666
Addition to a working formula Scoober	by Zoltan	1	432
What caused my paste function not to work? EXCEL USER	by PhilUK	2	975
Macros Debbie	by Debbie	2	346
How to check if the values in a range of cells are greater than 0 DP	by Teethless mama	3	1,162
Two digit number with one decimal, or three digit number Cass1930	by Brad E.	2	819
Extracting the last word from a string. Ciarán	by Teethless mama	2	489
Messy Formula needs clean up help! Danny Boy	by Gord Dibben	7	559
how do i create a formula to give a workday date? jjhacke	by Ron Rosenfeld	2	530
Auto Filter - It's broken! Help! (Office '03) Elgee	by Elgee	2	679
formula required Sohail khan	by Sohail khan	0	421
Lookup 2nd & last match with two conditions Billy Leung[_2_]	by T. Valko	6	488
a Counting question cinnie	by cinnie	4	347
combining dates and text in a cell Cecilia	by JLatham	1	462
Vlookup with If condition Biff	by Luke M[_4_]	1	1,207
Recurring header. Col Phil	by Luke M[_4_]	1	829
Monday closest to today's date? Ted[_6_]	by Ron Rosenfeld	6	1,718
what does the size 1/72 means Vin_microsoft	by macropod[_2_]	2	1,752
If then between two dates BBD	by T. Valko	1	2,896
Row Height or Column Width not Showing Brian	by Gord Dibben	1	1,210
IF INDEX and MATCH function together cadustin	by Gord Dibben	5	785
No Balance Owed Flag Help! Danny Boy	by Danny Boy	2	475
Multiple functions Debbie	by Debbie	2	459
Protect cell but allow copy command? Carole O	by Melissa	12	4,378
Vlookup with variable column reference jenVBA	by Paul C	1	1,570
Is there a function that counts distinct number od records in a ra Ayo	by Mike H	3	661
AVERAGE last 4 Mondays? Ted[_6_]	by Mike H	1	673
Excel 2007 Countifs macro with multiple criteria (OR) Tapani Mikkola	by Herbert Seidenberg	2	3,463
sumproduct with 4 conditions EXCELably Challenged[_2_]	by Fred Smith[_4_]	1	657
Making an excel sheet so formulas can not be deleted in the sum to Dan	by cadustin	2	1,299
Vlookup problem tpocccfo	by L. Howard Kittle	2	555
Moving Cell Formula iamjbunni	by Gord Dibben	1	444
multiple worksheets chieflx	by Pete_UK	3	413
Posting the workbook cadustin	by Herbert Seidenberg	3	580
Counting formula lawhawg	by T. Valko	1	471
Trying to collapse a table, what Function should I use? Brad E.	by excelent	3	1,040
vlookup function returning "na" even though the vlaues are present VKL Narayanan[_2_]	by Fred Smith[_4_]	2	1,158
Excel Logical IF function Stuck!	by Fred Smith[_4_]	2	687
Multiple sheet querries G Ray	by G Ray	4	521
wildacrds Dave	by G Ray	4	575
Variable Labor percentage based off of fixed sales +/- Herbert Seidenberg	by Herbert Seidenberg	0	1,251
Help to display chosen columns and rows Ephraim	by Don Guillett[_2_]	1	496
Validate data but then change the entry to upper case Ephraim	by Gord Dibben	4	1,961
comparing two colums ? countif manfred3	by T. Valko	1	502
calculate a date, 10 weeks after a set date & return a specific da Art3277	by T. Valko	2	1,158
Warning when in another cell after entering a formula. Ephraim	by Joe User[_2_]	2	636
Help with conditional formatting... Mr. Ruger	by Mr. Ruger	0	479
Data Validation, Identify Duplicates and Limit imput Lilyput	by Ashish Mathur[_2_]	9	725
How to return to the previous active sheet after hyperlink? Terry	by Ashish Mathur[_2_]	5	4,938
Moving cell formula iamjbunni	by Ashish Mathur[_2_]	3	689
salary defined by slab table XKruodo	by Ashish Mathur[_2_]	5	1,450
Use CountIf for a literal string chadkwelch	by Ashish Mathur[_2_]	3	2,516