Excel Worksheet Functions - Page 362

Thread / Thread Starter	Last Post	Replies	Views
Problem with sumproduct, countif functions.. Clay	by Clay	2	440
Help with countif and sumif functions Clay	by Clay	8	477
Double Match John[_21_]	by Max	6	745
Calculation Problem Jason Zischke	by sb1920alk	2	374
find duplicates and concatenate rpick60	by Teethless mama	1	645
Extracting data from a sku for shipping snd679	by snd679	2	444
Look up Compqueen	by Dave	2	321
Is there a way M-Pete	by Dave	1	334
protecting cells Tami	by Tami	2	342
Excel Won't Calculate davem97132	by Ron Rosenfeld	1	478
find duplicates and concatenate rpick60	by rpick60	0	372
Convert text to columns Krish	by Bob Bridges	1	466
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	597
ONE ROW WON'T SORT Kimmy T	by Gord Dibben	4	4,930
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	881
How do I create a button on a spreadsheet ? Lynn	by Gord Dibben	2	473
Conditional Drop-down lists Arjay	by Arjay	2	512
If/Then Statement help [email protected]	by JE McGimpsey	3	307
formulas based on a date atmbonda	by Judy Rose	5	433
Time Format Donald B[_2_]	by Sandy Mann	1	349
COUNTIF Function PatJennings	by PatJennings	4	533
Array / Function HELP!!! chris[_2_]	by chris[_2_]	2	465
one qustion ri_mirko	by Sandy Mann	1	374
Not sure what function to use to return records that fit criteria Roy Bernal	by Roy Bernal	2	461
Looking up a value within a range of 3 letter or number codes... Jimmy	by Ron Coderre	6	422
Weekly Worksheets from others merged into one summary sheet Assistant who needs help!	by Ron de Bruin	1	374
COUNTIF for multiples of 3 mwam423	by mwam423	3	4,974
Column and cell identificatiion Budask	by Rick Rothstein \(MVP - VB\)[_612_]	3	307
Pushing my luck, Sumproduct based on current data [email protected]	by T. Valko	1	317
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	541
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	501
vlookup displaying value of 0 Hohner	by Dave	2	379
Linking certain cells from Multiple files in a folder onto a summa lee	by Ron de Bruin	1	388
converting numerical data in one cell to word data in another cell Vishnu	by ryguy7272	2	657
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,422
Grouping Dates in a Pivot table for years that are not calendar ye Uno	by ryguy7272	1	379
Drop dwn menu. Formula to count selection frm menu in anoth cell? ggoldber	by ryguy7272	1	1,165
Dependent lists in other workbooks Julien	by Max	2	382
find a certain name ???????? Tia[_3_]	by Tia[_3_]	2	317
Cell recognition Euan Ritchie	by Max	3	788
Vlookup with a difference Leanne M (Aussie)	by Mike H	1	430
Data Validation - Tabs AMH	by Max	1	361
How do I insert the file name as my Worksheet name in the tab? Dennis	by Gary''s Student	1	442
Hiding zero values but being able to display 12am Michael	by Michael	0	400
How to establish a maximum and minimum value to a cell jvega	by David Biddulph[_2_]	3	590
Separating names & addresses in a spreadsheet Basil	by Stefi	1	410
Listox Linda30	by Linda30	2	284
Formula Help Darc	by Stefi	5	366
Data Validation Not Erroring with List OyBouTJ	by OyBouTJ	2	382
Sum and "N/A" pakmount	by Peo Sjoblom	3	493
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	693
need help summing text in column Laura Larson	by Dave	3	426
Indirect function in Excel 2007 brewdon	by brewdon	0	784
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	416
Relative sheet referencing in excel formulas MichaelR	by Gary''s Student	1	384
Finding non zero value in a group of cells Eric H	by T. Valko	2	450
GetPivotData Steve Powell	by ryguy7272	1	502
Sum Items in Column B if Item In clumn A corresponds to Page 2. Gregory Day	by Rick Rothstein \(MVP - VB\)[_610_]	7	459
Formula to multiply only a portion of a cell number? zsboppie	by zsboppie	4	1,200
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,066
If Function and the dreaded #VALUE Nick Wakeham	by Aladin Akyurek	4	393
Capitalizing Text Carin	by Gord Dibben	13	838