Excel Worksheet Functions - Page 7

Thread / Thread Starter	Last Post	Replies	Views
Converting time to decimal format dwhapp	by dwhapp	17	1,026
Referencing last cell Jean	by Alan	17	1,361
Count Unique Values Averitt Engineer[_2_]	by Bernd	17	1,567
Strange calculation in PivotTable Angus	by Roger Govier	17	904
Data validation with a fixed amount of decimal places [email protected]	by [email protected]	17	2,441
U.S. Holidays that the date moves top.jimmy	by T. Valko	17	1,234
RANDOM # around a MEAN with STANDARD DEVIATION Tanim	by ExcelBanter AI	17	7,984
Calculate how much time falls between set start and stop times Polly	by Robin	17	1,962
Sum Indirect Using R1C1 Style Bam	by Harlan Grove[_2_]	17	4,826
MATCH() Function and Blanks Gary''s Student	by Gary''s Student	17	1,150
How to set the formula - part 2? Eric	by Rick Rothstein	17	1,431
Need to fix macro to list data underneath each other jeannie v	by jeannie v	17	955
Concatencation and formatting Bengt[_3_]	by Ron Rosenfeld	17	964
Is there a formula for.... gueyo	by gueyo	17	759
I need a february 29th row, but only if the day of year actually exists FatBytestard	by Rich/rerat	17	1,247
How to record time in Excel in military (0730) format? fontana	by David Biddulph[_2_]	17	2,251
How do I create multiple workbooks within one workbook Ken C[_2_]	by Gord Dibben	17	1,532
? IF & GOTO ? Karen D	by Gord Dibben	17	1,799
Special count.,, Flemming[_2_]	by Flemming[_2_]	17	1,043
Convert text to rows Radrays	by Glenn	17	3,137
Formula to get number of days excluding Fridays in a given period Abdul[_2_]	by Bernd P	17	1,740
My Formula Changes on it's own? EARL	by Max	17	1,119
Complicated If Then / V Lookup / Match Statement... ryesworld	by Ron Coderre	17	2,055
Interest Functions dwe	by Bruno Campanini	17	1,966
3rd friday in month [email protected]	by [email protected]	17	1,700
Locate and retrivie data in table/matrix stefan7219	by Dave Peterson	17	982
IF statement including BETWEEN simmerdown	by Pete_UK	17	1,471
Need help with this formula... Dan B	by Bob Phillips	17	977
Dividing a time span into shifts - overlapping days Heidi	by Pete_UK	17	2,186
Formula Problem - interrupted by #VALUE! in other cells!? Ted	by Roger Govier	17	4,126
Macro start and finish date from rows Marylou	by David Biddulph	16	1,199
Mix/Max/Avg Help based on dynamic ranges Hile	by T. Valko	16	1,055
cannot convert text string into value Andy	by Andy	16	1,190
calculate difference between 2 dates nikko	by Bob Phillips[_3_]	16	878
Function help please! R.P.McMurphy	by R.P.McMurphy	16	879
how do I find prime factors of a number Jeff	by Ron Rosenfeld	16	3,208
Pulling a Letter from a cell and filling another cell with info nick s	by nick s	16	1,540
Is there a formula to calculate the least common denominator? Gizmo	by Greg Lovern	16	4,650
Finding the average across multiple sheets quailhunter	by Fin Fang Foom	16	2,621
Count items in range Steven	by Stefi	16	1,082
date to time formula Brownie_D75	by Rick Rothstein	16	949
One part number with several substitute numbers Sergio	by T. Valko	16	1,203
SumIf function nc	by Domenic	16	1,056
Adding multiple numbers in one cell pandd15	by Glenn	16	1,726
how do I write a formula that will figure weekly overtime? jasperPcuccumber	by CLR	16	1,685
to link information between two lists Bklynhyc	by Ashish Mathur[_2_]	16	1,082
text and numbers JBoulton	by Glenn	16	838
2 cells on multiple pages onto 1 page Kelly	by Sean Timmons	16	989
Extracting data from multiple worksheets into a list mnirula	by Peo Sjoblom	16	4,494
formula too long, not sure how to shorten Jane	by Jane	16	1,581
Multiple If's and OR's Shelly	by Shelly	16	1,243
Answers needed for challenging formula Sum Limit and marking	by Ron Rosenfeld	16	1,374
If A3=alpha numeric,"X", if A3=text,"Y", Blank Gary	by Ron Rosenfeld	16	2,145
Round Len Function Help [email protected]	by Slashman	16	989
Searching for a value in an Array Farah	by Jaybisco	16	1,024
Combining VLOOKUP functions Jay	by Pete_UK	16	1,613
Apply green to current date, red to 2 days overdue and none if pai vpschas	by vpschas	16	1,666
help to build a list of holidays for 6 years dribler2	by dribler2	16	1,177
Getting around 'IF" Dr Traffic	by Don Guillett	16	847
counting occurrences in another sheet based on several criteria WiFiMike2006	by T. Valko	16	1,531
Count unique if text Mike Fogleman	by Epinn	16	1,199
Average of Last 10 GaryC	by Ron Coderre	16	734
Can excel find a sequence of numbers from a known total? efandango	by efandango	16	1,526
How do I Lookup next values in Excel? mwl	by mwl	16	1,146
Array constant issue Sige	by Sige	16	1,374
Adding hours and minutes Patrick	by David Biddulph[_2_]	16	2,515
dos from excel vba? Jason	by Jason	16	1,946
Find Numeric data RobWN	by Harlan Grove[_2_]	16	846
Countif cell contians a specific number (within a list) porter444	by Ron Coderre	16	1,005
Convert Multiple Text entries... Mark	by Alan Beban[_2_]	16	1,065
Link transposed data from one sheet to another for DB purposes Tina	by YMTEO	16	973
how can I calculate cells containing words yes or no Brian N	by Roger Govier[_3_]	16	1,074
What formula to use? hollies	by hollies	16	939
Match 3 Criteria and Return Lowest Numeric Value Sam via OfficeKB.com	by Sam via OfficeKB.com	16	1,813
Averages Paige06	by Paige06	16	791