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,256
AutoPopulate DATE in Excel JordanMc	by zvkmpw	1	1,072
Using formula to convert date result to text hbcobra	by zvkmpw	6	1,127
Hyperlink function in an If function GoBow777	by Rebelfish	4	5,626
vertical and horizontal lookup? tealy	by [email protected]	1	1,496
How do I sort data shrek	by zvkmpw	2	683
Row reference for consecutive series calculation Santu	by Santu	0	917
Vlookup not locating file TMao	by Spencer101	1	714
SUMIF returning incorrect answer Dreganomics	by Ron Rosenfeld[_2_]	2	755
Need to extract text between numbers in a string dsimanton	by dsimanton	8	840
Formula to choose from the last column of a given row David Tannenbaum	by David Tannenbaum	2	772
edate 1 March!! Yangas	by Ron Rosenfeld[_2_]	5	796
IF ARRAY with multiple conditions. Jay07	by Stunn	2	667
Needing help with a Function on Excel. Ezoriel	by Claus Busch	2	674
Calculating an average of data between two dates lukestkd	by Stunn	1	1,013
Excel formula not able to work this out barry duncan	by Spencer101	4	790
Need urgent help with Excel formula zeeshanbutt	by plinius	1	761
Date Range and Time Range IF Statment Spencer Gershenson	by James Ravenswood	1	719
Getting text or numerical data from the formula Bootface	by zvkmpw	2	728
Keeping cells blank even though formula is input Bootface	by Bootface	5	1,294
Separating data in a row into new rows MortenPetterson	by MortenPetterson	3	869
Fill cell with a worksheet name? Adri S.	by [email protected]	5	1,002
Lookup and Vlookup ahs004	by zvkmpw	4	857
Secondary axis alignment [email protected]	by [email protected]	0	673
Lottery Check with Winnings sldfghtrike	by Jackson[_3_]	5	944
dragging formula is giving me undesired result in cell calls. timmerchline	by timmerchline	0	685
Help? I need help in making formulas work to accomplish... Excel-SNAFU	by Excel-SNAFU	0	719
What's wrong with this IF? Jay07	by Vacuum Sealed	5	817
Help? I've been thrown under a BUS and can't get up Excel-SNAFU	by Excel-SNAFU	0	498
complicated lookups? mrb13676	by Don Guillett[_2_]	1	651
Return text if column and row match values inneed	by inneed	0	613
lookup needed to give value where the lookup value is a string within a cell. Christopher Flack	by Spencer101	1	1,129
Change Color of Cell based on Date and today's date. SammiJojo412	by zvkmpw	1	1,734
Excel Logical function Rajesh Bhapkar	by Rajesh Bhapkar	12	1,697
Conditional formatting a big size sldfghtrike	by Spencer101	5	970
Probability of Time Loss, Non-time Loss and Fatality Oscar Leon	by Oscar Leon	0	645
Auto Sum not working correctly swalzy	by Vacuum Sealed	2	1,950
Saving as UTF-8 Colin Hayes	by Colin Hayes	0	925
Too few arguments plore	by Edd1986	5	5,139
Conditional Formatting - Cannot get it to work, please help LittlePhoenix	by Spencer101	1	872
Zero Occurance OtisAir	by OtisAir	5	1,222
Date Range Formular Diverslife	by Ron Rosenfeld[_2_]	5	904
Counting # of entries for each month, in a specific status Tee51	by Claus Busch	4	927
Group & Sort with formulas (HTML) Bruno Campanini[_2_]	by Bruno Campanini[_2_]	2	646
How do you make a summary sheet? Missinglink47	by Missinglink47	0	640
Formula help needed Lee Andley	by Claus Busch	2	729
How to get a formula result to return either "+", "- ", or "=" Scrubber	by Claus Busch	6	919
averageif cell doesn't contain "text" dkte737	by Claus Busch	3	1,644
Using 'indirect' function with full network path [email protected]	by [email protected]	0	1,145
Formating a row based on one cell's date Tee51	by Spencer101	12	1,608
Chronological Formula kawaikini	by Spencer101	1	892
Function to return the highest combined value of ANY two values in a list? H3dgehog	by H3dgehog	2	843
Multiple formats in one cell MikeTi	by Ron Rosenfeld[_2_]	1	964
Pivot Table Mapping TesterEd	by Spencer101	1	845
Return a Header Value with 2 vlookup criteria BDAvs	by isabelle	1	741
Need conditional formatting help!!! NancyX	by Claus Busch	1	749
How can I automatically update column index number in VLookup whe. Gene	by [email protected]	2	4,972
VLOOKUP text vs number issues returning value puck1263	by joeu2004[_2_]	20	4,023
What does this formulea mean? Waa	by Bruno Campanini[_2_]	15	2,053
Linking data from one worksheet to another using ookup functions Sher10	by Vacuum Sealed	2	956
Regression Analysis on Excel Andrew Arce	by joeu2004[_2_]	2	1,024
Count Dates in a range based on Column Header Id without using sum-product sam999	by zvkmpw	1	956
Aggregate multiple unique values and return top 5 dkinz	by Bruno Campanini[_2_]	3	1,136
Function to pull a single cell from a column into another cell LukeShep	by zvkmpw	6	971
How to Time time Diff for Completion of Activity (Exc Holiday List & Non Bus Hours) steven_me	by Spencer101	2	854
SUMIF over multiple spreadsheets Mark234	by Vacuum Sealed	8	1,761
Select a range not equal to: Pete[_25_]	by Pete[_25_]	4	895
HELP!!!!!!!!! PKS	by Vacuum Sealed	2	698
blank cell return vs. a 0 [email protected]	by GS[_2_]	8	1,469
Date/Time Difference Excluding Weekends & Holidays Paula D	by steven_me	3	6,033
Converting Text Ty	by Ty	9	848
Sliding Commission Formula Space Jace	by Vacuum Sealed	2	807
Automatic Number Increase G_off	by Gord Dibben[_2_]	5	1,145
Pulling "Title" Attribute from Active Directory itsmevic	by itsmevic	0	637
Date Functions Robert G	by Ron Rosenfeld[_2_]	5	872