Excel Worksheet Functions - Page 504

Thread / Thread Starter	Last Post	Replies	Views
Conditional Formatting Peco Worker	by David Billigmeier	1	324
skip errors in an average tamiluchi	by David Billigmeier	8	1,378
Need big help with look up....is this possible Dan B	by Dan B	5	342
How do I use more than one value in Conditional Formatting? Gerard	by Narnimar	4	712
Lookup a row and column and return value Carim	by Steve Crombie	2	950
Adapting MAX function nir020	by David Billigmeier	4	338
display the cell value in the next 33rd cell bmnjna2019	by bmnjna2019	4	391
Naming Cell on differnt worksheet Yan	by Yan	0	395
Helpful New Functions: ALL and ANY Atreides	by Stephen Bye	6	441
Need ability to get cell address of max value in range Michael Turnbeaugh	by Michael Turnbeaugh	11	1,576
Can I protect a document and still open / close groups Paul	by Dave Peterson	1	446
Nested IF functions beyond eight items? Bob Phillips	by vezerid	3	334
Counting if between date range Marc Shaw	by CLR	7	690
Conditional Scenario of Text value Rudy	by Ron Coderre	14	1,510
sumproduct with one variable criteria? Cif	by Epinn	11	1,404
Text Restrictions LPS	by LPS	3	500
Concatenate & Date General Specific	by Dave F	2	467
How to calculate time after converting 12.22 to 12:22 Bob Phillips	by Mouimet	1	370
calculate the sum of characters in a cell Nat	by David Billigmeier	8	2,191
Removing 1-2 caharacters Bob Phillips	by Blueboy	1	289
ranking based on criteria Bob Phillips	by Trelaina	1	655
Need big help with look up....is this possible Dan B	by Dan B	15	856
top ten customers by transaction count by product Carl	by Carl	2	555
Formula not copying down LizM	by LizM	6	2,473
How to have information auto input if cell = yes Pamela2216	by Pamela2216	0	397
if function and ifblank() function Bob Phillips	by bj	3	632
ADDING A PRINT CONTROL BUTTON Tonya	by Otto Moehrbach	1	444
Excel 2007 (Beta) Auto Filter Basketball 1	by Ron de Bruin	1	558
Pull last word from a text string in Excel nmp	by Biff	8	2,950
How do I insert a drop down list button from an excel worksheet? Visiting Angel	by Gord Dibben	2	995
Last column entry lookup. Bg	by Roger Govier	1	379
mutiply by either REG or OT hours, and SUM! Raza	by Raza	6	448
copying date from one sheet to another work sheet Jay	by Jay	13	1,211
formulas using if parameters Dana	by Sandy Mann	3	435
I need a specific formula in excel ASmith	by Roger Govier	1	383
how do i set up a 'rolling shift pattern' worksheet? rednip	by rednip	0	1,106
can i convert a worksheet with data into a calander rajdiamond	by rajdiamond	0	416
an if( statement looking for a specific phrase anywhere in a cell Bob Phillips	by Bob Phillips	3	1,385
Rows and columns in 2007 1,048,576 rows by 16,384 columns Gene at Stonybrook	by	1	811
How do I copy a group of worksheets with named ranges in Excel 200 sc	by	2	1,090
Run time error tires85	by	2	382
look up with multiple criteria and within a range kjguillermo	by Anthony D	3	562
How do I use the IF formula to flag me 21 days after the date? Wanderer	by pdberger	1	447
Can I position a PAGE NUMBER side of a sheet? Christina Bachman	by MyVeryOwnSelf	1	1,170
Match with tilda characater IanW	by Biff	6	2,217
Limit on array formula LizM	by Biff	3	1,145
Changing cell colors to correspond to different dates emtp6738	by Max	2	685
After sorting the formula has the incorrect cell tiq	by Herbert Seidenberg	1	591
Add a line in different places? umuckatie	by umuckatie	0	422
Complicated SUMPRODUCT Barb Reinhardt	by Epinn	8	510
Unlocking protected cells Vanilla Skies	by Vanilla Skies	0	545
Pivot Tables steven	by Debra Dalgleish	1	454
Dependant Data Validation not sorted Sara Hopkins	by Roger Govier	3	630
If a Row is blank jac007	by Leo Heuser	13	922
Query Problem Freshman	by Freshman	0	368
Creating Dialogue Box MeriHeart	by curlydave	1	408
why doesn't this formula work? Lisa	by len	4	440
How to code it in excel? Eric	by Eric	0	405
LOOKUP two data sets for match - return 1 or 0 - Please help! Jay	by Stefi	1	950
CHANGE SHEET MAXRAF80	by Marcelo	2	333
SumIf two axes oscar	by Bob Phillips	3	3,500
How do I use the IF formula to flag dates 21 days prior to deadlin Wanderer	by Barb Reinhardt	1	706
Counting data over multiple worksheets xlsuser42	by Lori	1	986
How to open a workbook on a specific worksheet. kevincanuk	by kevincanuk	2	903
IF VLOOKUP Nested function Paul LeBlanc	by Paul LeBlanc	5	1,805
HOW TO CHANGE BETWEEN THE SHEETS AND ONE MENU MAXRAF80	by Marcelo	1	335
present value formula SUMIF	by [email protected]	2	417
vLookup with multiple lookup value in table array [email protected]	by [email protected]	2	2,165
Consolidate data from multiple sheets Bdavis	by Bdavis	0	675
user cannot access his share workbook on network drive. Phil	by Phil	0	814
Pasting Excel data into Word doc. mjdntn	by mjdntn	0	567
Lookup text then copy over to new cell Jaco Jacobs	by Kevin Vaughn	3	980
Whatsthe formula which retrieves a # from a multiplication table DS	by Anthony D	4	554
lookup data Jaci	by Marcelo	1	352
How to save my VBA-code Heine	by Gord Dibben	4	968