Excel Worksheet Functions - Page 24

Thread / Thread Starter	Last Post	Replies	Views
YTD SUMIF based on current date garygoodguy	by garygoodguy	1	1,192
COMPARING TWO COLUMNS AND DISPLAYING MSGBOX naga rajan	by naga rajan	6	854
List with Duplicates to uniques list garygoodguy	by MyVeryOwnSelf[_3_]	1	686
IF Statement for Selection garygoodguy	by GS[_2_]	3	805
Testing a cell value for a specific weekday. CellShocked	by Claus Busch	4	769
How to ignore a column of numbers in Grand Total for rows Michael Lester	by Michael Lester	1	760
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	713
Can I add a range and then divide that sum by a specific value? Gordon Shumway	by Gordon Shumway	2	664
Copy columns, but not hidden ones Duncs	by Claus Busch	3	696
VLOOKUP, a table with text and numerics [email protected]	by Claus Busch	7	964
Index Match Max? Zsoup	by Kevin@Radstock	3	771
If value between 2 numbers CMoHorn	by Ron Rosenfeld[_2_]	12	2,057
ranking data by a numeric value mitchosu	by Ron Rosenfeld[_2_]	2	702
Calendar Logic: Recurring Dates Talka	by Maurizio Borrelli	3	1,147
How to reset excel worksheet form lilstbox and combo box [email protected]	by [email protected]	2	718
excel pnk1971	by pnk1971	0	689
count not-overlapping days in a "Table" with Beginning and EndingsDates Specified jb	by jb	0	621
Excel 2003 "If" function Kalop	by Kalop	0	797
Learning arrays. David Farber	by David Farber	13	1,825
Active Calendar JonathanK1	by Spencer101	1	815
Match/Index/Sum function with date range JonathanK1	by JonathanK1	3	1,021
Antilog [email protected]	by plinius	1	668
Calculate total by row number [email protected]	by [email protected]	4	1,067
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	1,997
Issue Concatenate dates in a large range of cells in a row. jspring0033	by jspring0033	6	915
Countifs with different restrictions [email protected]	by Claus Busch	1	656
Index and match if field contains specific text in it saintsman26	by Claus Busch	1	748
How do I assign "Apple" to a cell reference in this evaluate code? [email protected]	by [email protected]	2	731
NumberFormat for small non-zero numbers? [email protected]	by joeu2004[_2_]	2	678
NumberFormat instead of an IF [email protected]	by [email protected]	2	616
Replace data to right of string problem Jayjones	by Claus Busch	10	1,545
date & Time naresh vadlamudi	by Claus Busch	1	789
COUNTING THE SAME VALUES IN A SHEET naga rajan	by Claus Busch	3	738
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	665
sorting noncontiguous data with exceptions al drah	by plinius	3	879
Finding most recent date for each customer - XL 2007 Geoff B	by Drea17	3	2,765
Matching two columns of data JFLaj	by [email protected]	2	658
Lookup Formula Assistance matgriffey	by matgriffey	0	666
Simplifying multiple IF statements? rgbiernat	by Living the Dream	1	708
return a value depending on two previous values petschek	by Claus Busch	1	579
IF/AND/OR Statements gmannix1000	by Spencer101	1	618
Calculating the change in lead times from a table. preto	by preto	0	574
Bitwise Functions? [email protected]	by [email protected]	0	617
Need help calculating probabilities Kiffar	by Kiffar	8	1,293
Identifying common data between 2 cells MRPRMR	by Claus Busch	1	977
Standar deviation across sheets help ibressler	by ibressler	0	676
Multiple VLOOKUP in an IF statement Richard Doyle	by Claus Busch	2	731
Evaluate Multiple Cells for any Value Billy Daniel	by GS[_2_]	1	740
Need help finding a substring in a array of strings. hvcrios	by Claus Busch	1	718
Validation of cell based on Drop down list murtaza7210	by Claus Busch	1	651
Return Column Header from an Index/array, finding Large with a userinput date alovell	by alovell	0	778
Scaling multiple columns Arto Vesterbacka	by Arto Vesterbacka	0	604
Display yesterday's date but only for weekdays? totalnatal	by Ron Rosenfeld[_2_]	8	1,298
Formula I can't figure out dpgreen	by dpgreen	2	708
Month Calculation Moideen	by Moideen	5	860
Using IF, AND and OR functions together ahs004	by Claus Busch	2	751
Search Text and Add a Blank Line kojack	by kojack	2	722
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	985
Setting a range in a named range Askjerry	by Ron Rosenfeld[_2_]	3	756
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	746
Help on the Sumif Function matt_writer	by joeu2004[_2_]	1	687
Stumped on how to complete. Pinnum	by Pinnum	0	725
Count value in range, but exclude based on adjacent value. amacrab	by Spencer101	4	954
Sunday Dale[_4_]	by Michael (Micky) Avidan	8	1,738
Excel Template required for Daily managing daily income and expense at Mobile shop nevillmehta	by [email protected]	3	2,240
Remove punctuation mark, Split cells & average accross column Gautam Bhut	by Gautam Bhut	4	934
LOOKUP function?? [email protected]	by [email protected]	5	947
Summing up cells based on names in adjoining cells - I'm new to using functions Stupidparrpt	by Stupidparrpt	2	793