Excel Worksheet Functions - Page 24

Thread / Thread Starter	Last Post	Replies	Views
YTD SUMIF based on current date garygoodguy	by garygoodguy	1	1,203
COMPARING TWO COLUMNS AND DISPLAYING MSGBOX naga rajan	by naga rajan	6	868
List with Duplicates to uniques list garygoodguy	by MyVeryOwnSelf[_3_]	1	701
IF Statement for Selection garygoodguy	by GS[_2_]	3	815
Testing a cell value for a specific weekday. CellShocked	by Claus Busch	4	781
How to ignore a column of numbers in Grand Total for rows Michael Lester	by Michael Lester	1	766
Lookup in multiple & separate cells StaffHerb	by Ron Rosenfeld[_2_]	6	1,160
How to calculate time percentage of number of parts being pick in a timeframe Markous	by joeu2004[_2_]	2	716
Can I add a range and then divide that sum by a specific value? Gordon Shumway	by Gordon Shumway	2	674
Copy columns, but not hidden ones Duncs	by Claus Busch	3	704
VLOOKUP, a table with text and numerics [email protected]	by Claus Busch	7	973
Index Match Max? Zsoup	by Kevin@Radstock	3	785
If value between 2 numbers CMoHorn	by Ron Rosenfeld[_2_]	12	2,088
ranking data by a numeric value mitchosu	by Ron Rosenfeld[_2_]	2	714
Calendar Logic: Recurring Dates Talka	by Maurizio Borrelli	3	1,159
How to reset excel worksheet form lilstbox and combo box [email protected]	by [email protected]	2	729
excel pnk1971	by pnk1971	0	695
count not-overlapping days in a "Table" with Beginning and EndingsDates Specified jb	by jb	0	631
Excel 2003 "If" function Kalop	by Kalop	0	798
Learning arrays. David Farber	by David Farber	13	1,838
Active Calendar JonathanK1	by Spencer101	1	815
Match/Index/Sum function with date range JonathanK1	by JonathanK1	3	1,036
Antilog [email protected]	by plinius	1	674
Calculate total by row number [email protected]	by [email protected]	4	1,079
2 dimensional date sort Walter Briscoe	by Ron Rosenfeld[_2_]	2	826
excel formulas TAJASH	by Stan Brown	2	1,046
% of difference between two numbers exeldumb	by joeu2004[_2_]	6	2,000
Issue Concatenate dates in a large range of cells in a row. jspring0033	by jspring0033	6	924
Countifs with different restrictions [email protected]	by Claus Busch	1	667
Index and match if field contains specific text in it saintsman26	by Claus Busch	1	763
How do I assign "Apple" to a cell reference in this evaluate code? [email protected]	by [email protected]	2	740
NumberFormat for small non-zero numbers? [email protected]	by joeu2004[_2_]	2	690
NumberFormat instead of an IF [email protected]	by [email protected]	2	629
Replace data to right of string problem Jayjones	by Claus Busch	10	1,573
date & Time naresh vadlamudi	by Claus Busch	1	795
COUNTING THE SAME VALUES IN A SHEET naga rajan	by Claus Busch	3	746
IF statement not returning correct answer KerriL	by Ron Rosenfeld[_2_]	4	1,083
Protect and Edit Object [email protected]	by GS[_2_]	1	758
Multiple If statements, Calculating quarterly % holding costs mitchellqwerty	by mitchellqwerty	0	671
sorting noncontiguous data with exceptions al drah	by plinius	3	891
Finding most recent date for each customer - XL 2007 Geoff B	by Drea17	3	2,773
Matching two columns of data JFLaj	by [email protected]	2	673
Lookup Formula Assistance matgriffey	by matgriffey	0	666
Simplifying multiple IF statements? rgbiernat	by Living the Dream	1	716
return a value depending on two previous values petschek	by Claus Busch	1	579
IF/AND/OR Statements gmannix1000	by Spencer101	1	632
Calculating the change in lead times from a table. preto	by preto	0	582
Bitwise Functions? [email protected]	by [email protected]	0	619
Need help calculating probabilities Kiffar	by Kiffar	8	1,311
Identifying common data between 2 cells MRPRMR	by Claus Busch	1	990
Standar deviation across sheets help ibressler	by ibressler	0	676
Multiple VLOOKUP in an IF statement Richard Doyle	by Claus Busch	2	742
Evaluate Multiple Cells for any Value Billy Daniel	by GS[_2_]	1	750
Need help finding a substring in a array of strings. hvcrios	by Claus Busch	1	731
Validation of cell based on Drop down list murtaza7210	by Claus Busch	1	658
Return Column Header from an Index/array, finding Large with a userinput date alovell	by alovell	0	790
Scaling multiple columns Arto Vesterbacka	by Arto Vesterbacka	0	612
Display yesterday's date but only for weekdays? totalnatal	by Ron Rosenfeld[_2_]	8	1,314
Formula I can't figure out dpgreen	by dpgreen	2	708
Month Calculation Moideen	by Moideen	5	862
Using IF, AND and OR functions together ahs004	by Claus Busch	2	764
Search Text and Add a Blank Line kojack	by kojack	2	735
Pls Help - blank cell/formula issue Shokra	by Claus Busch	8	1,588
VLOOKUP or SUMIF for Multiple Criteria Rob Kein	by Kevin@Radstock	2	992
Setting a range in a named range Askjerry	by Ron Rosenfeld[_2_]	3	771
Help. Trying to do the opposite of VLOOKUP Randy Sauve	by plinius	3	1,079
Time Zone Conversion Table naven_sg	by Ron Rosenfeld[_2_]	2	758
Help on the Sumif Function matt_writer	by joeu2004[_2_]	1	697
Stumped on how to complete. Pinnum	by Pinnum	0	726
Count value in range, but exclude based on adjacent value. amacrab	by Spencer101	4	958
Sunday Dale[_4_]	by Michael (Micky) Avidan	8	1,743
Excel Template required for Daily managing daily income and expense at Mobile shop nevillmehta	by [email protected]	3	2,241
Remove punctuation mark, Split cells & average accross column Gautam Bhut	by Gautam Bhut	4	943
LOOKUP function?? [email protected]	by [email protected]	5	956
Summing up cells based on names in adjoining cells - I'm new to using functions Stupidparrpt	by Stupidparrpt	2	801