Excel Worksheet Functions - Page 362

Thread / Thread Starter	Last Post	Replies	Views
Problem with sumproduct, countif functions.. Clay	by Clay	2	397
Help with countif and sumif functions Clay	by Clay	8	461
Double Match John[_21_]	by Max	6	736
Calculation Problem Jason Zischke	by sb1920alk	2	355
find duplicates and concatenate rpick60	by Teethless mama	1	629
Extracting data from a sku for shipping snd679	by snd679	2	439
Look up Compqueen	by Dave	2	320
Is there a way M-Pete	by Dave	1	331
protecting cells Tami	by Tami	2	337
Excel Won't Calculate davem97132	by Ron Rosenfeld	1	460
find duplicates and concatenate rpick60	by rpick60	0	368
Convert text to columns Krish	by Bob Bridges	1	432
Compare to two sheets in one excel file to evaluate and combine whereidentical. [email protected]	by Otto Moehrbach[_2_]	1	489
if then formula Ann	by Dave	3	582
Update DAte Automatically SilviaG	by Gary''s Student	2	589
ONE ROW WON'T SORT Kimmy T	by Gord Dibben	4	4,859
non-VBA Alternative to SUBTITUTE function Justin Larson	by Justin Larson[_2_]	6	505
how can you insert a version number in excel ? deejay	by Gord Dibben	2	875
How do I create a button on a spreadsheet ? Lynn	by Gord Dibben	2	460
Conditional Drop-down lists Arjay	by Arjay	2	499
If/Then Statement help [email protected]	by JE McGimpsey	3	291
formulas based on a date atmbonda	by Judy Rose	5	423
Time Format Donald B[_2_]	by Sandy Mann	1	347
COUNTIF Function PatJennings	by PatJennings	4	515
Array / Function HELP!!! chris[_2_]	by chris[_2_]	2	444
one qustion ri_mirko	by Sandy Mann	1	361
Not sure what function to use to return records that fit criteria Roy Bernal	by Roy Bernal	2	440
Looking up a value within a range of 3 letter or number codes... Jimmy	by Ron Coderre	6	410
Weekly Worksheets from others merged into one summary sheet Assistant who needs help!	by Ron de Bruin	1	365
COUNTIF for multiples of 3 mwam423	by mwam423	3	4,941
Column and cell identificatiion Budask	by Rick Rothstein \(MVP - VB\)[_612_]	3	304
Pushing my luck, Sumproduct based on current data [email protected]	by T. Valko	1	309
What would cause the comment box to resize and move on it's own? heyjude70	by heyjude70	0	782
Need help writing a formula phyllis	by phyllis	13	1,152
Conditional formatting dates in 2007 Lucy	by T. Valko	5	531
How do I use case sensitive VLOOKUP? markythesk8erboi	by T. Valko	8	786
Macro to re-protect sheet w/ original password after pasting valuesin new book [email protected]	by Per Jessen	1	688
Formula erros =#N/A Tia[_3_]	by Tia[_3_]	2	363
Change import cell reference AMaleThing	by Per Jessen	3	498
vlookup displaying value of 0 Hohner	by Dave	2	375
Linking certain cells from Multiple files in a folder onto a summa lee	by Ron de Bruin	1	361
converting numerical data in one cell to word data in another cell Vishnu	by ryguy7272	2	632
How can I make a vLookup dynamic? smonczka	by Teethless mama	1	577
check box, copy / paste or insert / delete row Carla	by Carla	2	2,406
Grouping Dates in a Pivot table for years that are not calendar ye Uno	by ryguy7272	1	366
Drop dwn menu. Formula to count selection frm menu in anoth cell? ggoldber	by ryguy7272	1	1,131
Dependent lists in other workbooks Julien	by Max	2	374
find a certain name ???????? Tia[_3_]	by Tia[_3_]	2	315
Cell recognition Euan Ritchie	by Max	3	779
Vlookup with a difference Leanne M (Aussie)	by Mike H	1	422
Data Validation - Tabs AMH	by Max	1	354
How do I insert the file name as my Worksheet name in the tab? Dennis	by Gary''s Student	1	427
Hiding zero values but being able to display 12am Michael	by Michael	0	399
How to establish a maximum and minimum value to a cell jvega	by David Biddulph[_2_]	3	578
Separating names & addresses in a spreadsheet Basil	by Stefi	1	402
Listox Linda30	by Linda30	2	280
Formula Help Darc	by Stefi	5	364
Data Validation Not Erroring with List OyBouTJ	by OyBouTJ	2	367
Sum and "N/A" pakmount	by Peo Sjoblom	3	492
How to separate names and addresses in a spreadsheet Basil	by T. Valko	1	881
grouping error in Excel 2003/2007 Pivot table connect to offline c KT[_2_]	by KT[_2_]	0	779
Vlookup not working consistently Julie B.	by Fred Smith[_4_]	3	676
need help summing text in column Laura Larson	by Dave	3	416
Indirect function in Excel 2007 brewdon	by brewdon	0	761
QUARTILE Function on Sorted Data Gerry Pat[_2_]	by Gerry Pat[_2_]	2	4,061
QUARTILE Function on Sorted Data Gerry Pat[_2_]	by Domenic[_2_]	1	401
Relative sheet referencing in excel formulas MichaelR	by Gary''s Student	1	367
Finding non zero value in a group of cells Eric H	by T. Valko	2	430
GetPivotData Steve Powell	by ryguy7272	1	494
Sum Items in Column B if Item In clumn A corresponds to Page 2. Gregory Day	by Rick Rothstein \(MVP - VB\)[_610_]	7	452
Formula to multiply only a portion of a cell number? zsboppie	by zsboppie	4	1,188
Count multiple cells against multiple criteria in an Excel spreads EricB	by Max	7	1,401
Nested If Using TODAY Function Robbie	by Max	3	1,046
If Function and the dreaded #VALUE Nick Wakeham	by Aladin Akyurek	4	382
Capitalizing Text Carin	by Gord Dibben	13	833