Excel Worksheet Functions - Page 24

Thread / Thread Starter	Last Post	Replies	Views
YTD SUMIF based on current date garygoodguy	by garygoodguy	1	1,181
COMPARING TWO COLUMNS AND DISPLAYING MSGBOX naga rajan	by naga rajan	6	835
List with Duplicates to uniques list garygoodguy	by MyVeryOwnSelf[_3_]	1	674
IF Statement for Selection garygoodguy	by GS[_2_]	3	792
Testing a cell value for a specific weekday. CellShocked	by Claus Busch	4	743
How to ignore a column of numbers in Grand Total for rows Michael Lester	by Michael Lester	1	748
Lookup in multiple & separate cells StaffHerb	by Ron Rosenfeld[_2_]	6	1,135
How to calculate time percentage of number of parts being pick in a timeframe Markous	by joeu2004[_2_]	2	697
Can I add a range and then divide that sum by a specific value? Gordon Shumway	by Gordon Shumway	2	647
Copy columns, but not hidden ones Duncs	by Claus Busch	3	678
VLOOKUP, a table with text and numerics [email protected]	by Claus Busch	7	950
Index Match Max? Zsoup	by Kevin@Radstock	3	764
If value between 2 numbers CMoHorn	by Ron Rosenfeld[_2_]	12	2,021
ranking data by a numeric value mitchosu	by Ron Rosenfeld[_2_]	2	684
Calendar Logic: Recurring Dates Talka	by Maurizio Borrelli	3	1,129
How to reset excel worksheet form lilstbox and combo box [email protected]	by [email protected]	2	704
excel pnk1971	by pnk1971	0	685
count not-overlapping days in a "Table" with Beginning and EndingsDates Specified jb	by jb	0	610
Excel 2003 "If" function Kalop	by Kalop	0	779
Learning arrays. David Farber	by David Farber	13	1,805
Active Calendar JonathanK1	by Spencer101	1	806
Match/Index/Sum function with date range JonathanK1	by JonathanK1	3	1,008
Antilog [email protected]	by plinius	1	657
Calculate total by row number [email protected]	by [email protected]	4	1,054
2 dimensional date sort Walter Briscoe	by Ron Rosenfeld[_2_]	2	812
excel formulas TAJASH	by Stan Brown	2	1,039
% of difference between two numbers exeldumb	by joeu2004[_2_]	6	1,981
Issue Concatenate dates in a large range of cells in a row. jspring0033	by jspring0033	6	902
Countifs with different restrictions [email protected]	by Claus Busch	1	639
Index and match if field contains specific text in it saintsman26	by Claus Busch	1	725
How do I assign "Apple" to a cell reference in this evaluate code? [email protected]	by [email protected]	2	711
NumberFormat for small non-zero numbers? [email protected]	by joeu2004[_2_]	2	664
NumberFormat instead of an IF [email protected]	by [email protected]	2	597
Replace data to right of string problem Jayjones	by Claus Busch	10	1,504
date & Time naresh vadlamudi	by Claus Busch	1	769
COUNTING THE SAME VALUES IN A SHEET naga rajan	by Claus Busch	3	708
IF statement not returning correct answer KerriL	by Ron Rosenfeld[_2_]	4	1,039
Protect and Edit Object [email protected]	by GS[_2_]	1	739
Multiple If statements, Calculating quarterly % holding costs mitchellqwerty	by mitchellqwerty	0	647
sorting noncontiguous data with exceptions al drah	by plinius	3	859
Finding most recent date for each customer - XL 2007 Geoff B	by Drea17	3	2,738
Matching two columns of data JFLaj	by [email protected]	2	641
Lookup Formula Assistance matgriffey	by matgriffey	0	649
Simplifying multiple IF statements? rgbiernat	by Living the Dream	1	692
return a value depending on two previous values petschek	by Claus Busch	1	556
IF/AND/OR Statements gmannix1000	by Spencer101	1	601
Calculating the change in lead times from a table. preto	by preto	0	561
Bitwise Functions? [email protected]	by [email protected]	0	581
Need help calculating probabilities Kiffar	by Kiffar	8	1,270
Identifying common data between 2 cells MRPRMR	by Claus Busch	1	961
Standar deviation across sheets help ibressler	by ibressler	0	652
Multiple VLOOKUP in an IF statement Richard Doyle	by Claus Busch	2	707
Evaluate Multiple Cells for any Value Billy Daniel	by GS[_2_]	1	726
Need help finding a substring in a array of strings. hvcrios	by Claus Busch	1	698
Validation of cell based on Drop down list murtaza7210	by Claus Busch	1	638
Return Column Header from an Index/array, finding Large with a userinput date alovell	by alovell	0	762
Scaling multiple columns Arto Vesterbacka	by Arto Vesterbacka	0	588
Display yesterday's date but only for weekdays? totalnatal	by Ron Rosenfeld[_2_]	8	1,258
Formula I can't figure out dpgreen	by dpgreen	2	690
Month Calculation Moideen	by Moideen	5	839
Using IF, AND and OR functions together ahs004	by Claus Busch	2	740
Search Text and Add a Blank Line kojack	by kojack	2	704
Pls Help - blank cell/formula issue Shokra	by Claus Busch	8	1,564
VLOOKUP or SUMIF for Multiple Criteria Rob Kein	by Kevin@Radstock	2	968
Setting a range in a named range Askjerry	by Ron Rosenfeld[_2_]	3	727
Help. Trying to do the opposite of VLOOKUP Randy Sauve	by plinius	3	1,059
Time Zone Conversion Table naven_sg	by Ron Rosenfeld[_2_]	2	732
Help on the Sumif Function matt_writer	by joeu2004[_2_]	1	676
Stumped on how to complete. Pinnum	by Pinnum	0	705
Count value in range, but exclude based on adjacent value. amacrab	by Spencer101	4	932
Sunday Dale[_4_]	by Michael (Micky) Avidan	8	1,716
Excel Template required for Daily managing daily income and expense at Mobile shop nevillmehta	by [email protected]	3	2,214
Remove punctuation mark, Split cells & average accross column Gautam Bhut	by Gautam Bhut	4	930
LOOKUP function?? [email protected]	by [email protected]	5	935
Summing up cells based on names in adjoining cells - I'm new to using functions Stupidparrpt	by Stupidparrpt	2	780