Excel Worksheet Functions - Page 362

Thread / Thread Starter	Last Post	Replies	Views
Problem with sumproduct, countif functions.. Clay	by Clay	2	446
Help with countif and sumif functions Clay	by Clay	8	489
Double Match John[_21_]	by Max	6	748
Calculation Problem Jason Zischke	by sb1920alk	2	379
find duplicates and concatenate rpick60	by Teethless mama	1	652
Extracting data from a sku for shipping snd679	by snd679	2	451
Look up Compqueen	by Dave	2	330
Is there a way M-Pete	by Dave	1	344
protecting cells Tami	by Tami	2	342
Excel Won't Calculate davem97132	by Ron Rosenfeld	1	485
find duplicates and concatenate rpick60	by rpick60	0	378
Convert text to columns Krish	by Bob Bridges	1	473
Compare to two sheets in one excel file to evaluate and combine whereidentical. [email protected]	by Otto Moehrbach[_2_]	1	498
if then formula Ann	by Dave	3	587
Update DAte Automatically SilviaG	by Gary''s Student	2	607
ONE ROW WON'T SORT Kimmy T	by Gord Dibben	4	4,937
non-VBA Alternative to SUBTITUTE function Justin Larson	by Justin Larson[_2_]	6	523
how can you insert a version number in excel ? deejay	by Gord Dibben	2	885
How do I create a button on a spreadsheet ? Lynn	by Gord Dibben	2	478
Conditional Drop-down lists Arjay	by Arjay	2	522
If/Then Statement help [email protected]	by JE McGimpsey	3	317
formulas based on a date atmbonda	by Judy Rose	5	442
Time Format Donald B[_2_]	by Sandy Mann	1	354
COUNTIF Function PatJennings	by PatJennings	4	543
Array / Function HELP!!! chris[_2_]	by chris[_2_]	2	465
one qustion ri_mirko	by Sandy Mann	1	375
Not sure what function to use to return records that fit criteria Roy Bernal	by Roy Bernal	2	472
Looking up a value within a range of 3 letter or number codes... Jimmy	by Ron Coderre	6	431
Weekly Worksheets from others merged into one summary sheet Assistant who needs help!	by Ron de Bruin	1	375
COUNTIF for multiples of 3 mwam423	by mwam423	3	4,978
Column and cell identificatiion Budask	by Rick Rothstein \(MVP - VB\)[_612_]	3	308
Pushing my luck, Sumproduct based on current data [email protected]	by T. Valko	1	320
What would cause the comment box to resize and move on it's own? heyjude70	by heyjude70	0	796
Need help writing a formula phyllis	by phyllis	13	1,168
Conditional formatting dates in 2007 Lucy	by T. Valko	5	546
How do I use case sensitive VLOOKUP? markythesk8erboi	by T. Valko	8	802
Macro to re-protect sheet w/ original password after pasting valuesin new book [email protected]	by Per Jessen	1	706
Formula erros =#N/A Tia[_3_]	by Tia[_3_]	2	377
Change import cell reference AMaleThing	by Per Jessen	3	510
vlookup displaying value of 0 Hohner	by Dave	2	389
Linking certain cells from Multiple files in a folder onto a summa lee	by Ron de Bruin	1	398
converting numerical data in one cell to word data in another cell Vishnu	by ryguy7272	2	665
How can I make a vLookup dynamic? smonczka	by Teethless mama	1	584
check box, copy / paste or insert / delete row Carla	by Carla	2	2,428
Grouping Dates in a Pivot table for years that are not calendar ye Uno	by ryguy7272	1	387
Drop dwn menu. Formula to count selection frm menu in anoth cell? ggoldber	by ryguy7272	1	1,174
Dependent lists in other workbooks Julien	by Max	2	384
find a certain name ???????? Tia[_3_]	by Tia[_3_]	2	327
Cell recognition Euan Ritchie	by Max	3	797
Vlookup with a difference Leanne M (Aussie)	by Mike H	1	435
Data Validation - Tabs AMH	by Max	1	371
How do I insert the file name as my Worksheet name in the tab? Dennis	by Gary''s Student	1	446
Hiding zero values but being able to display 12am Michael	by Michael	0	410
How to establish a maximum and minimum value to a cell jvega	by David Biddulph[_2_]	3	599
Separating names & addresses in a spreadsheet Basil	by Stefi	1	410
Listox Linda30	by Linda30	2	284
Formula Help Darc	by Stefi	5	371
Data Validation Not Erroring with List OyBouTJ	by OyBouTJ	2	386
Sum and "N/A" pakmount	by Peo Sjoblom	3	503
How to separate names and addresses in a spreadsheet Basil	by T. Valko	1	903
grouping error in Excel 2003/2007 Pivot table connect to offline c KT[_2_]	by KT[_2_]	0	803
Vlookup not working consistently Julie B.	by Fred Smith[_4_]	3	697
need help summing text in column Laura Larson	by Dave	3	435
Indirect function in Excel 2007 brewdon	by brewdon	0	795
QUARTILE Function on Sorted Data Gerry Pat[_2_]	by Gerry Pat[_2_]	2	4,160
QUARTILE Function on Sorted Data Gerry Pat[_2_]	by Domenic[_2_]	1	422
Relative sheet referencing in excel formulas MichaelR	by Gary''s Student	1	393
Finding non zero value in a group of cells Eric H	by T. Valko	2	461
GetPivotData Steve Powell	by ryguy7272	1	511
Sum Items in Column B if Item In clumn A corresponds to Page 2. Gregory Day	by Rick Rothstein \(MVP - VB\)[_610_]	7	469
Formula to multiply only a portion of a cell number? zsboppie	by zsboppie	4	1,210
Count multiple cells against multiple criteria in an Excel spreads EricB	by Max	7	1,422
Nested If Using TODAY Function Robbie	by Max	3	1,067
If Function and the dreaded #VALUE Nick Wakeham	by Aladin Akyurek	4	402
Capitalizing Text Carin	by Gord Dibben	13	846