Excel Worksheet Functions - Page 1177

Thread / Thread Starter	Last Post	Replies	Views
search multiple worksheets for an item and return the Wsheets name Chris	by Chris	16	2,589
Is there a way to prevent pasting data into an Excel worksheet? Rod from Corrections	by [email protected]	16	1,518
What function? Dipwind	by Franz Verga	16	821
Round Len Function Help [email protected]	by Slashman	16	994
Searching for a value in an Array Farah	by Jaybisco	16	1,024
Combining VLOOKUP functions Jay	by Pete_UK	16	1,614
Apply green to current date, red to 2 days overdue and none if pai vpschas	by vpschas	16	1,666
IF then statements-Tiered PRicing Jackiec21	by Epinn	16	2,077
array formulas Nader	by Bob Phillips	16	1,202
help to build a list of holidays for 6 years dribler2	by dribler2	16	1,177
Finding the average across multiple sheets quailhunter	by Fin Fang Foom	16	2,621
Getting around 'IF" Dr Traffic	by Don Guillett	16	847
how do I write a formula that will figure weekly overtime? jasperPcuccumber	by CLR	16	1,685
counting occurrences in another sheet based on several criteria WiFiMike2006	by T. Valko	16	1,531
How do I sum numbers from cells that contain text nicklissa	by Harlan Grove	16	1,635
Count unique if text Mike Fogleman	by Epinn	16	1,199
23:00 <> 23:00 Biff	by Ron Rosenfeld	16	840
Extracting data from multiple worksheets into a list mnirula	by Peo Sjoblom	16	4,494
Sum delimited values in cell Andy Brown	by Max	16	1,209
formula too long, not sure how to shorten Jane	by Jane	16	1,581
macro help [email protected]	by [email protected]	17	820
Special count.,, Flemming[_2_]	by Flemming[_2_]	17	1,043
Informational Search zoomzoom632	by T. Valko	17	835
Dates smooney	by Harlan Grove[_2_]	17	1,017
Counting unique entries across two or three columns [email protected]	by Harlan Grove[_2_]	17	1,381
Sumif with multiple columns in sum_range dza7	by Ron Coderre	17	1,220
Highest 3 in 10 Consecutive Numbers Dan	by Harlan Grove[_2_]	17	2,433
Calculate how much time falls between set start and stop times Polly	by Robin	17	1,962
Concatencation and formatting Bengt[_3_]	by Ron Rosenfeld	17	964
Building Dynamic SUMIF statement Nancy Taylor	by Nancy Taylor[_2_]	17	1,043
? IF & GOTO ? Karen D	by Gord Dibben	17	1,799
How do I create multiple workbooks within one workbook Ken C[_2_]	by Gord Dibben	17	1,532
Sum of a column from nth row to end itsAchint	by T. Valko	17	1,894
How to record time in Excel in military (0730) format? fontana	by David Biddulph[_2_]	17	2,251
Crazy Hard Function Chris	by Chris	17	954
I need a february 29th row, but only if the day of year actually exists FatBytestard	by Rich/rerat	17	1,247
VLOOKUP not returning data in some (but not all) records Pete	by Dave Peterson	17	1,779
Is there a formula for.... gueyo	by gueyo	17	759
Sumproduct with If Angie	by Marcelo	17	839
find a value in a table based on 2 different criteria Picman	by ~L	17	1,041
retrieve data from two columns and sort Joe	by Joe	17	1,456
Converting time to decimal format dwhapp	by dwhapp	17	1,026
How to set the formula - part 2? Eric	by Rick Rothstein	17	1,431
vLookup with dates Jodi Macy	by T. Valko	17	926
MATCH() Function and Blanks Gary''s Student	by Gary''s Student	17	1,151
Sum Indirect Using R1C1 Style Bam	by Harlan Grove[_2_]	17	4,831
Determining the text mode from a variety of data types matt3542	by RagDyer	17	1,067
Converting Dates to 8 digits jermsalerms	by Pete	17	1,293
listing data without blank rows Shooter	by Dannycol	17	1,885
Sumif Rainfall Kay	by Kay	17	1,381
Geo average Stephen	by Harlan Grove	17	1,163
How can I enter 8 digits in excel (eg 19710625) and get it to dis. Moira	by Ron Rosenfeld	17	1,407
how do i get a list of different formulas CHICOALLEN	by Bob Phillips	17	1,139
How to insert a value in one cell into many cells Thomas	by Max	17	2,117
Return Numerical Label for LAST value Subtracted to reach Sum Target Value Sam via OfficeKB.com	by Ron Rosenfeld	17	2,316
Formula Problem - interrupted by #VALUE! in other cells!? Ted	by Roger Govier	17	4,126
nested if function Louise	by Niek Otten	17	928
Interest Functions dwe	by Bruno Campanini	17	1,966
Complicated If Then / V Lookup / Match Statement... ryesworld	by Ron Coderre	17	2,055
My Formula Changes on it's own? EARL	by Max	17	1,119
How do I calculate a difference in work days? Work Days	by Gord Dibben	17	1,403
how to put quotation mark in each cell of the column crazyfisher	by Led_A_Muck[_2_]	17	2,523
Need help with this formula... Dan B	by Bob Phillips	17	977
Match formula bob	by Max	17	883
Reference milkman	by Max	17	748
SumProduct with criteria list Sige	by Sige	17	1,748
Selecting Last Sheet Bonbon	by Bonbon	17	2,207
Dividing a time span into shifts - overlapping days Heidi	by Pete_UK	17	2,186
returning header row as a result... mj	by mj	17	1,215
IF statement including BETWEEN simmerdown	by Pete_UK	17	1,471
Excel Vlookup Problems Help! Hero_honda	by Hero_honda	17	954
Create multiple sheet tabs from multiple cells. Robert Maddox	by Gord Dibben	17	1,742
sumif to return an intersection? EllenG	by Franz Verga	17	1,280
replace all function - excel 2003 Rob	by diaare	17	1,677
U.S. Holidays that the date moves top.jimmy	by T. Valko	17	1,234