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,240
AutoPopulate DATE in Excel JordanMc	by zvkmpw	1	1,060
Using formula to convert date result to text hbcobra	by zvkmpw	6	1,097
Hyperlink function in an If function GoBow777	by Rebelfish	4	5,592
vertical and horizontal lookup? tealy	by [email protected]	1	1,476
How do I sort data shrek	by zvkmpw	2	666
Row reference for consecutive series calculation Santu	by Santu	0	899
Vlookup not locating file TMao	by Spencer101	1	697
SUMIF returning incorrect answer Dreganomics	by Ron Rosenfeld[_2_]	2	742
Need to extract text between numbers in a string dsimanton	by dsimanton	8	820
Formula to choose from the last column of a given row David Tannenbaum	by David Tannenbaum	2	748
edate 1 March!! Yangas	by Ron Rosenfeld[_2_]	5	780
IF ARRAY with multiple conditions. Jay07	by Stunn	2	654
Needing help with a Function on Excel. Ezoriel	by Claus Busch	2	660
Calculating an average of data between two dates lukestkd	by Stunn	1	989
Excel formula not able to work this out barry duncan	by Spencer101	4	767
Need urgent help with Excel formula zeeshanbutt	by plinius	1	743
Date Range and Time Range IF Statment Spencer Gershenson	by James Ravenswood	1	699
Getting text or numerical data from the formula Bootface	by zvkmpw	2	711
Keeping cells blank even though formula is input Bootface	by Bootface	5	1,278
Separating data in a row into new rows MortenPetterson	by MortenPetterson	3	849
Fill cell with a worksheet name? Adri S.	by [email protected]	5	984
Lookup and Vlookup ahs004	by zvkmpw	4	838
Secondary axis alignment [email protected]	by [email protected]	0	647
Lottery Check with Winnings sldfghtrike	by Jackson[_3_]	5	921
dragging formula is giving me undesired result in cell calls. timmerchline	by timmerchline	0	660
Help? I need help in making formulas work to accomplish... Excel-SNAFU	by Excel-SNAFU	0	703
What's wrong with this IF? Jay07	by Vacuum Sealed	5	795
Help? I've been thrown under a BUS and can't get up Excel-SNAFU	by Excel-SNAFU	0	484
complicated lookups? mrb13676	by Don Guillett[_2_]	1	635
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,076
Change Color of Cell based on Date and today's date. SammiJojo412	by zvkmpw	1	1,712
Excel Logical function Rajesh Bhapkar	by Rajesh Bhapkar	12	1,682
Conditional formatting a big size sldfghtrike	by Spencer101	5	940
Probability of Time Loss, Non-time Loss and Fatality Oscar Leon	by Oscar Leon	0	631
Auto Sum not working correctly swalzy	by Vacuum Sealed	2	1,930
Saving as UTF-8 Colin Hayes	by Colin Hayes	0	907
Too few arguments plore	by Edd1986	5	5,088
Conditional Formatting - Cannot get it to work, please help LittlePhoenix	by Spencer101	1	844
Zero Occurance OtisAir	by OtisAir	5	1,193
Date Range Formular Diverslife	by Ron Rosenfeld[_2_]	5	886
Counting # of entries for each month, in a specific status Tee51	by Claus Busch	4	902
Group & Sort with formulas (HTML) Bruno Campanini[_2_]	by Bruno Campanini[_2_]	2	629
How do you make a summary sheet? Missinglink47	by Missinglink47	0	623
Formula help needed Lee Andley	by Claus Busch	2	707
How to get a formula result to return either "+", "- ", or "=" Scrubber	by Claus Busch	6	896
averageif cell doesn't contain "text" dkte737	by Claus Busch	3	1,632
Using 'indirect' function with full network path [email protected]	by [email protected]	0	1,111
Formating a row based on one cell's date Tee51	by Spencer101	12	1,593
Chronological Formula kawaikini	by Spencer101	1	869
Function to return the highest combined value of ANY two values in a list? H3dgehog	by H3dgehog	2	820
Multiple formats in one cell MikeTi	by Ron Rosenfeld[_2_]	1	953
Pivot Table Mapping TesterEd	by Spencer101	1	823
Return a Header Value with 2 vlookup criteria BDAvs	by isabelle	1	725
Need conditional formatting help!!! NancyX	by Claus Busch	1	726
How can I automatically update column index number in VLookup whe. Gene	by [email protected]	2	4,930
VLOOKUP text vs number issues returning value puck1263	by joeu2004[_2_]	20	4,004
What does this formulea mean? Waa	by Bruno Campanini[_2_]	15	2,041
Linking data from one worksheet to another using ookup functions Sher10	by Vacuum Sealed	2	932
Regression Analysis on Excel Andrew Arce	by joeu2004[_2_]	2	1,005
Count Dates in a range based on Column Header Id without using sum-product sam999	by zvkmpw	1	937
Aggregate multiple unique values and return top 5 dkinz	by Bruno Campanini[_2_]	3	1,111
Function to pull a single cell from a column into another cell LukeShep	by zvkmpw	6	956
How to Time time Diff for Completion of Activity (Exc Holiday List & Non Bus Hours) steven_me	by Spencer101	2	834
SUMIF over multiple spreadsheets Mark234	by Vacuum Sealed	8	1,746
Select a range not equal to: Pete[_25_]	by Pete[_25_]	4	857
HELP!!!!!!!!! PKS	by Vacuum Sealed	2	682
blank cell return vs. a 0 [email protected]	by GS[_2_]	8	1,435
Date/Time Difference Excluding Weekends & Holidays Paula D	by steven_me	3	5,999
Converting Text Ty	by Ty	9	822
Sliding Commission Formula Space Jace	by Vacuum Sealed	2	795
Automatic Number Increase G_off	by Gord Dibben[_2_]	5	1,126
Pulling "Title" Attribute from Active Directory itsmevic	by itsmevic	0	620
Date Functions Robert G	by Ron Rosenfeld[_2_]	5	855