Excel Worksheet Functions - Page 24

Thread / Thread Starter	Last Post	Replies	Views
YTD SUMIF based on current date garygoodguy	by garygoodguy	1	1,191
COMPARING TWO COLUMNS AND DISPLAYING MSGBOX naga rajan	by naga rajan	6	850
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	766
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,158
How to calculate time percentage of number of parts being pick in a timeframe Markous	by joeu2004[_2_]	2	710
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	695
VLOOKUP, a table with text and numerics [email protected]	by Claus Busch	7	962
Index Match Max? Zsoup	by Kevin@Radstock	3	771
If value between 2 numbers CMoHorn	by Ron Rosenfeld[_2_]	12	2,055
ranking data by a numeric value mitchosu	by Ron Rosenfeld[_2_]	2	699
Calendar Logic: Recurring Dates Talka	by Maurizio Borrelli	3	1,146
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	796
Learning arrays. David Farber	by David Farber	13	1,823
Active Calendar JonathanK1	by Spencer101	1	811
Match/Index/Sum function with date range JonathanK1	by JonathanK1	3	1,018
Antilog [email protected]	by plinius	1	668
Calculate total by row number [email protected]	by [email protected]	4	1,065
2 dimensional date sort Walter Briscoe	by Ron Rosenfeld[_2_]	2	824
excel formulas TAJASH	by Stan Brown	2	1,043
% of difference between two numbers exeldumb	by joeu2004[_2_]	6	1,995
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	654
Index and match if field contains specific text in it saintsman26	by Claus Busch	1	746
How do I assign "Apple" to a cell reference in this evaluate code? [email protected]	by [email protected]	2	730
NumberFormat for small non-zero numbers? [email protected]	by joeu2004[_2_]	2	678
NumberFormat instead of an IF [email protected]	by [email protected]	2	613
Replace data to right of string problem Jayjones	by Claus Busch	10	1,540
date & Time naresh vadlamudi	by Claus Busch	1	788
COUNTING THE SAME VALUES IN A SHEET naga rajan	by Claus Busch	3	735
IF statement not returning correct answer KerriL	by Ron Rosenfeld[_2_]	4	1,077
Protect and Edit Object [email protected]	by GS[_2_]	1	757
Multiple If statements, Calculating quarterly % holding costs mitchellqwerty	by mitchellqwerty	0	664
sorting noncontiguous data with exceptions al drah	by plinius	3	878
Finding most recent date for each customer - XL 2007 Geoff B	by Drea17	3	2,761
Matching two columns of data JFLaj	by [email protected]	2	658
Lookup Formula Assistance matgriffey	by matgriffey	0	665
Simplifying multiple IF statements? rgbiernat	by Living the Dream	1	707
return a value depending on two previous values petschek	by Claus Busch	1	577
IF/AND/OR Statements gmannix1000	by Spencer101	1	616
Calculating the change in lead times from a table. preto	by preto	0	573
Bitwise Functions? [email protected]	by [email protected]	0	608
Need help calculating probabilities Kiffar	by Kiffar	8	1,293
Identifying common data between 2 cells MRPRMR	by Claus Busch	1	976
Standar deviation across sheets help ibressler	by ibressler	0	674
Multiple VLOOKUP in an IF statement Richard Doyle	by Claus Busch	2	730
Evaluate Multiple Cells for any Value Billy Daniel	by GS[_2_]	1	738
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	777
Scaling multiple columns Arto Vesterbacka	by Arto Vesterbacka	0	602
Display yesterday's date but only for weekdays? totalnatal	by Ron Rosenfeld[_2_]	8	1,296
Formula I can't figure out dpgreen	by dpgreen	2	702
Month Calculation Moideen	by Moideen	5	859
Using IF, AND and OR functions together ahs004	by Claus Busch	2	749
Search Text and Add a Blank Line kojack	by kojack	2	721
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	983
Setting a range in a named range Askjerry	by Ron Rosenfeld[_2_]	3	755
Help. Trying to do the opposite of VLOOKUP Randy Sauve	by plinius	3	1,078
Time Zone Conversion Table naven_sg	by Ron Rosenfeld[_2_]	2	745
Help on the Sumif Function matt_writer	by joeu2004[_2_]	1	686
Stumped on how to complete. Pinnum	by Pinnum	0	722
Count value in range, but exclude based on adjacent value. amacrab	by Spencer101	4	948
Sunday Dale[_4_]	by Michael (Micky) Avidan	8	1,732
Excel Template required for Daily managing daily income and expense at Mobile shop nevillmehta	by [email protected]	3	2,235
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	791