Excel Worksheet Functions - Page 66

Thread / Thread Starter	Last Post	Replies	Views
AVERAGE last 4 Mondays? Ted[_6_]	by Mike H	1	684
Is there a function that counts distinct number od records in a ra Ayo	by Mike H	3	675
Vlookup with variable column reference jenVBA	by Paul C	1	1,583
Protect cell but allow copy command? Carole O	by Melissa	12	4,392
Multiple functions Debbie	by Debbie	2	470
No Balance Owed Flag Help! Danny Boy	by Danny Boy	2	487
IF INDEX and MATCH function together cadustin	by Gord Dibben	5	801
Row Height or Column Width not Showing Brian	by Gord Dibben	1	1,221
If then between two dates BBD	by T. Valko	1	2,904
what does the size 1/72 means Vin_microsoft	by macropod[_2_]	2	1,809
Monday closest to today's date? Ted[_6_]	by Ron Rosenfeld	6	1,758
Recurring header. Col Phil	by Luke M[_4_]	1	841
Vlookup with If condition Biff	by Luke M[_4_]	1	1,226
combining dates and text in a cell Cecilia	by JLatham	1	472
a Counting question cinnie	by cinnie	4	363
Lookup 2nd & last match with two conditions Billy Leung[_2_]	by T. Valko	6	500
formula required Sohail khan	by Sohail khan	0	432
Auto Filter - It's broken! Help! (Office '03) Elgee	by Elgee	2	691
how do i create a formula to give a workday date? jjhacke	by Ron Rosenfeld	2	541
Messy Formula needs clean up help! Danny Boy	by Gord Dibben	7	577
Extracting the last word from a string. Ciarán	by Teethless mama	2	521
Two digit number with one decimal, or three digit number Cass1930	by Brad E.	2	830
How to check if the values in a range of cells are greater than 0 DP	by Teethless mama	3	1,183
Macros Debbie	by Debbie	2	367
What caused my paste function not to work? EXCEL USER	by PhilUK	2	985
Addition to a working formula Scoober	by Zoltan	1	442
Workday function not working Cam	by Shaz[_2_]	6	1,687
Electricity Bill Sheet XKruodo	by XKruodo	6	2,886
IF statement based on True/False that activates a certain list box rittzy	by Jacob Skaria	1	923
paste values Excel 2007 Diamond	by Matt Geare[_2_]	2	1,171
Conditional Formatting with 3 Criteria Options Nickle	by David Biddulph[_2_]	5	618
VLOOKUP with HLOOKUP XKruodo	by XKruodo	2	505
subtraction returning incorrect calue Ashish_Vaidya	by Fred Smith[_4_]	5	1,223
loan amortization template jjbud44	by Dana DeLouis[_3_]	2	948
Odd Drop Down Box Behavior Squeaky	by Gord Dibben	4	668
Countif Function?? Kevan	by T. Valko	3	531
Restrict data entry in a cell Ephraim	by T. Valko	3	727
How to omit blank cells when calculating weighted averages Suzy	by T. Valko	20	2,269
Conditional Format for Blank Cells LSG	by LSG	5	1,746
Hlookup with Merged cell as look up value srs	by T. Valko	1	2,733
sumif concatenate formula Robb27	by Lars-Åke Aspelin[_4_]	4	1,191
Conditions Not Accurate when subtracting time sly411	by sly411	3	662
retrieving current data dave303159	by Otto Moehrbach[_2_]	1	427
Average with Condition Curtis[_2_]	by Paul C	4	514
Average with Conditions Curtis[_2_]	by T. Valko	3	383
formula patterns with a gap of two Mr L Hibbert	by Mr L Hibbert	0	712
Sumproduct but only first time corresponding value is seen e.g. un ker_01	by T. Valko	1	666
LookUP function with multiple variables and worksheets mjwk	by Pete_UK	1	802
Count with two criteria LisaK	by Pete_UK	2	407
Conditional Formatting for a dashboard with a drop down menu Kathy	by Kathy	0	721
Links do not recognize .xlsm extension BadBoy	by Squeaky	1	1,245
=AND($B$12<"",$B$12<TODAY()+60) What does the < mean in this? Cbeckwith	by Bob Phillips[_4_]	3	2,077
Sharing Violation Carolan	by Squeaky	1	591
Microsoft 2007 christie	by Fred Smith[_4_]	4	502
Formula Result is different from the shown result DanWebster24	by Fred Smith[_4_]	2	706
How to enable auto height with merged cells? lgreggs	by lgreggs	0	682
Hide formula in list Errko	by Errko	1	443
Search Entire Sheet instead of 1? msnyc07	by Glenn	4	654
lookup second / last match with two conditions Billy Leung[_2_]	by Gary''s Student	1	721
I think I need a multiple IF statement, or is there another way? Carl Waring	by Jacob Skaria	5	546
Degrees Minutes Decimal Minutes to Decimal Degrees. Al[_5_]	by Ron Rosenfeld	3	1,883
Changing Defined Names Lelethu	by Jacob Skaria	2	501
countif with a condition and contains @ Pete_UK	by whyrajesh	1	438
SumProduct not Working in a Macro Booey	by Bob Phillips[_4_]	6	535
How do I find a value in a table without using the labels? BobbyR	by Dennis Tucker	1	519
Summing a crosstab dysolomon	by minyeh	7	3,318
column corresponding to row number climate	by climate	0	431
Formulas that recognise data from two worksheets Kimbeau	by Fred Smith[_4_]	1	458
combine vlookup and match help cadustin	by Jacob Skaria	6	909
Help with SumProduct Ayo	by T. Valko	7	470
Replace Cells with Column names in functions? msnyc07	by Ashish Mathur[_2_]	4	1,086
Microsoft Excel Total Values gp	by Ashish Mathur[_2_]	2	481
Print to file DavidA	by Billns	5	586
Excel merging and automatic edit of worksheets Moonie66	by Moonie66	0	421
Need transpose? help.... Jethro Bodeene	by Jethro Bodeene[_2_]	9	661