Excel Worksheet Functions - Page 28

Thread / Thread Starter	Last Post	Replies	Views
Variable to rename a tab in a worksheet via VBA Colin Hayes	by Colin Hayes	5	1,244
AutoPopulate DATE in Excel JordanMc	by zvkmpw	1	1,062
Using formula to convert date result to text hbcobra	by zvkmpw	6	1,104
Hyperlink function in an If function GoBow777	by Rebelfish	4	5,599
vertical and horizontal lookup? tealy	by [email protected]	1	1,481
How do I sort data shrek	by zvkmpw	2	671
Row reference for consecutive series calculation Santu	by Santu	0	903
Vlookup not locating file TMao	by Spencer101	1	698
SUMIF returning incorrect answer Dreganomics	by Ron Rosenfeld[_2_]	2	743
Need to extract text between numbers in a string dsimanton	by dsimanton	8	824
Formula to choose from the last column of a given row David Tannenbaum	by David Tannenbaum	2	752
edate 1 March!! Yangas	by Ron Rosenfeld[_2_]	5	784
IF ARRAY with multiple conditions. Jay07	by Stunn	2	655
Needing help with a Function on Excel. Ezoriel	by Claus Busch	2	661
Calculating an average of data between two dates lukestkd	by Stunn	1	994
Excel formula not able to work this out barry duncan	by Spencer101	4	771
Need urgent help with Excel formula zeeshanbutt	by plinius	1	747
Date Range and Time Range IF Statment Spencer Gershenson	by James Ravenswood	1	703
Getting text or numerical data from the formula Bootface	by zvkmpw	2	715
Keeping cells blank even though formula is input Bootface	by Bootface	5	1,282
Separating data in a row into new rows MortenPetterson	by MortenPetterson	3	853
Fill cell with a worksheet name? Adri S.	by [email protected]	5	988
Lookup and Vlookup ahs004	by zvkmpw	4	842
Secondary axis alignment [email protected]	by [email protected]	0	651
Lottery Check with Winnings sldfghtrike	by Jackson[_3_]	5	926
dragging formula is giving me undesired result in cell calls. timmerchline	by timmerchline	0	664
Help? I need help in making formulas work to accomplish... Excel-SNAFU	by Excel-SNAFU	0	707
What's wrong with this IF? Jay07	by Vacuum Sealed	5	800
Help? I've been thrown under a BUS and can't get up Excel-SNAFU	by Excel-SNAFU	0	488
complicated lookups? mrb13676	by Don Guillett[_2_]	1	639
Return text if column and row match values inneed	by inneed	0	600
lookup needed to give value where the lookup value is a string within a cell. Christopher Flack	by Spencer101	1	1,080
Change Color of Cell based on Date and today's date. SammiJojo412	by zvkmpw	1	1,716
Excel Logical function Rajesh Bhapkar	by Rajesh Bhapkar	12	1,686
Conditional formatting a big size sldfghtrike	by Spencer101	5	951
Probability of Time Loss, Non-time Loss and Fatality Oscar Leon	by Oscar Leon	0	635
Auto Sum not working correctly swalzy	by Vacuum Sealed	2	1,930
Saving as UTF-8 Colin Hayes	by Colin Hayes	0	911
Too few arguments plore	by Edd1986	5	5,093
Conditional Formatting - Cannot get it to work, please help LittlePhoenix	by Spencer101	1	848
Zero Occurance OtisAir	by OtisAir	5	1,197
Date Range Formular Diverslife	by Ron Rosenfeld[_2_]	5	890
Counting # of entries for each month, in a specific status Tee51	by Claus Busch	4	905
Group & Sort with formulas (HTML) Bruno Campanini[_2_]	by Bruno Campanini[_2_]	2	633
How do you make a summary sheet? Missinglink47	by Missinglink47	0	627
Formula help needed Lee Andley	by Claus Busch	2	711
How to get a formula result to return either "+", "- ", or "=" Scrubber	by Claus Busch	6	900
averageif cell doesn't contain "text" dkte737	by Claus Busch	3	1,633
Using 'indirect' function with full network path [email protected]	by [email protected]	0	1,122
Formating a row based on one cell's date Tee51	by Spencer101	12	1,594
Chronological Formula kawaikini	by Spencer101	1	874
Function to return the highest combined value of ANY two values in a list? H3dgehog	by H3dgehog	2	824
Multiple formats in one cell MikeTi	by Ron Rosenfeld[_2_]	1	954
Pivot Table Mapping TesterEd	by Spencer101	1	827
Return a Header Value with 2 vlookup criteria BDAvs	by isabelle	1	729
Need conditional formatting help!!! NancyX	by Claus Busch	1	727
How can I automatically update column index number in VLookup whe. Gene	by [email protected]	2	4,938
VLOOKUP text vs number issues returning value puck1263	by joeu2004[_2_]	20	4,008
What does this formulea mean? Waa	by Bruno Campanini[_2_]	15	2,045
Linking data from one worksheet to another using ookup functions Sher10	by Vacuum Sealed	2	936
Regression Analysis on Excel Andrew Arce	by joeu2004[_2_]	2	1,006
Count Dates in a range based on Column Header Id without using sum-product sam999	by zvkmpw	1	938
Aggregate multiple unique values and return top 5 dkinz	by Bruno Campanini[_2_]	3	1,115
Function to pull a single cell from a column into another cell LukeShep	by zvkmpw	6	961
How to Time time Diff for Completion of Activity (Exc Holiday List & Non Bus Hours) steven_me	by Spencer101	2	838
SUMIF over multiple spreadsheets Mark234	by Vacuum Sealed	8	1,747
Select a range not equal to: Pete[_25_]	by Pete[_25_]	4	861
HELP!!!!!!!!! PKS	by Vacuum Sealed	2	686
blank cell return vs. a 0 [email protected]	by GS[_2_]	8	1,439
Date/Time Difference Excluding Weekends & Holidays Paula D	by steven_me	3	6,004
Converting Text Ty	by Ty	9	826
Sliding Commission Formula Space Jace	by Vacuum Sealed	2	799
Automatic Number Increase G_off	by Gord Dibben[_2_]	5	1,128
Pulling "Title" Attribute from Active Directory itsmevic	by itsmevic	0	624
Date Functions Robert G	by Ron Rosenfeld[_2_]	5	859