Excel Worksheet Functions - Page 66

Thread / Thread Starter	Last Post	Replies	Views
AVERAGE last 4 Mondays? Ted[_6_]	by Mike H	1	672
Is there a function that counts distinct number od records in a ra Ayo	by Mike H	3	660
Vlookup with variable column reference jenVBA	by Paul C	1	1,568
Protect cell but allow copy command? Carole O	by Melissa	12	4,378
Multiple functions Debbie	by Debbie	2	458
No Balance Owed Flag Help! Danny Boy	by Danny Boy	2	474
IF INDEX and MATCH function together cadustin	by Gord Dibben	5	784
Row Height or Column Width not Showing Brian	by Gord Dibben	1	1,209
If then between two dates BBD	by T. Valko	1	2,895
what does the size 1/72 means Vin_microsoft	by macropod[_2_]	2	1,751
Monday closest to today's date? Ted[_6_]	by Ron Rosenfeld	6	1,717
Recurring header. Col Phil	by Luke M[_4_]	1	827
Vlookup with If condition Biff	by Luke M[_4_]	1	1,206
combining dates and text in a cell Cecilia	by JLatham	1	461
a Counting question cinnie	by cinnie	4	347
Lookup 2nd & last match with two conditions Billy Leung[_2_]	by T. Valko	6	487
formula required Sohail khan	by Sohail khan	0	420
Auto Filter - It's broken! Help! (Office '03) Elgee	by Elgee	2	678
how do i create a formula to give a workday date? jjhacke	by Ron Rosenfeld	2	529
Messy Formula needs clean up help! Danny Boy	by Gord Dibben	7	559
Extracting the last word from a string. Ciarán	by Teethless mama	2	488
Two digit number with one decimal, or three digit number Cass1930	by Brad E.	2	818
How to check if the values in a range of cells are greater than 0 DP	by Teethless mama	3	1,161
Macros Debbie	by Debbie	2	345
What caused my paste function not to work? EXCEL USER	by PhilUK	2	974
Addition to a working formula Scoober	by Zoltan	1	428
Workday function not working Cam	by Shaz[_2_]	6	1,664
Electricity Bill Sheet XKruodo	by XKruodo	6	2,861
IF statement based on True/False that activates a certain list box rittzy	by Jacob Skaria	1	911
paste values Excel 2007 Diamond	by Matt Geare[_2_]	2	1,157
Conditional Formatting with 3 Criteria Options Nickle	by David Biddulph[_2_]	5	602
VLOOKUP with HLOOKUP XKruodo	by XKruodo	2	486
subtraction returning incorrect calue Ashish_Vaidya	by Fred Smith[_4_]	5	1,206
loan amortization template jjbud44	by Dana DeLouis[_3_]	2	935
Odd Drop Down Box Behavior Squeaky	by Gord Dibben	4	657
Countif Function?? Kevan	by T. Valko	3	515
Restrict data entry in a cell Ephraim	by T. Valko	3	710
How to omit blank cells when calculating weighted averages Suzy	by T. Valko	20	2,234
Conditional Format for Blank Cells LSG	by LSG	5	1,724
Hlookup with Merged cell as look up value srs	by T. Valko	1	2,723
sumif concatenate formula Robb27	by Lars-Åke Aspelin[_4_]	4	1,172
Conditions Not Accurate when subtracting time sly411	by sly411	3	637
retrieving current data dave303159	by Otto Moehrbach[_2_]	1	414
Average with Condition Curtis[_2_]	by Paul C	4	496
Average with Conditions Curtis[_2_]	by T. Valko	3	365
formula patterns with a gap of two Mr L Hibbert	by Mr L Hibbert	0	693
Sumproduct but only first time corresponding value is seen e.g. un ker_01	by T. Valko	1	625
LookUP function with multiple variables and worksheets mjwk	by Pete_UK	1	770
Count with two criteria LisaK	by Pete_UK	2	394
Conditional Formatting for a dashboard with a drop down menu Kathy	by Kathy	0	703
Links do not recognize .xlsm extension BadBoy	by Squeaky	1	1,234
=AND($B$12<"",$B$12<TODAY()+60) What does the < mean in this? Cbeckwith	by Bob Phillips[_4_]	3	2,023
Sharing Violation Carolan	by Squeaky	1	574
Microsoft 2007 christie	by Fred Smith[_4_]	4	487
Formula Result is different from the shown result DanWebster24	by Fred Smith[_4_]	2	685
How to enable auto height with merged cells? lgreggs	by lgreggs	0	670
Hide formula in list Errko	by Errko	1	434
Search Entire Sheet instead of 1? msnyc07	by Glenn	4	643
lookup second / last match with two conditions Billy Leung[_2_]	by Gary''s Student	1	704
I think I need a multiple IF statement, or is there another way? Carl Waring	by Jacob Skaria	5	533
Degrees Minutes Decimal Minutes to Decimal Degrees. Al[_5_]	by Ron Rosenfeld	3	1,861
Changing Defined Names Lelethu	by Jacob Skaria	2	486
countif with a condition and contains @ Pete_UK	by whyrajesh	1	422
SumProduct not Working in a Macro Booey	by Bob Phillips[_4_]	6	523
How do I find a value in a table without using the labels? BobbyR	by Dennis Tucker	1	500
Summing a crosstab dysolomon	by minyeh	7	3,280
column corresponding to row number climate	by climate	0	423
Formulas that recognise data from two worksheets Kimbeau	by Fred Smith[_4_]	1	443
combine vlookup and match help cadustin	by Jacob Skaria	6	899
Help with SumProduct Ayo	by T. Valko	7	459
Replace Cells with Column names in functions? msnyc07	by Ashish Mathur[_2_]	4	1,076
Microsoft Excel Total Values gp	by Ashish Mathur[_2_]	2	471
Print to file DavidA	by Billns	5	576
Excel merging and automatic edit of worksheets Moonie66	by Moonie66	0	411
Need transpose? help.... Jethro Bodeene	by Jethro Bodeene[_2_]	9	628