Excel Worksheet Functions - Page 321

Thread / Thread Starter	Last Post	Replies	Views
Auto Insert/Auto Formula? Abacus	by Robert	1	717
How to show the defined name of another cell Bol	by Bol	3	424
Change Date without Opening the Workbook ad2maso	by ad2maso	0	540
COUNTIF using exclusions djDaemon	by JMB	1	512
Vlookup not working because of duplicate matches BBS	by Kevin Vaughn	8	902
summing previously ranked values ellebelle	by ellebelle	0	386
product from k= 0 to n sylphide	by Niek Otten	3	404
vlookup in several sheets kris	by Domenic	2	795
FOrmulas in MS Excel Gagan	by CLR	1	324
Using '=MIN(DATE(YEAR(A1),MONTH(A1)+{7,6},DAY(A1)*{0,1}) )' JNW	by JNW	11	1,611
I am trying to round a list of numbers (prices) to xx.95. Is the Comexe35	by Pete	3	478
In a linked calculation how do I lose the '0' in the linked file? Anita	by Max	2	794
Text to Columns - Only want to split SPECIFIC NUMBER of times NewKid	by Guy Yeakley	9	827
joining worksheets Brion	by Bernie Deitrick	1	434
Week Number Decreenisi	by Decreenisi	3	662
Calculating Overtime sam13484 via OfficeKB.com	by	1	558
Enter 1 in a cell, excel change to 0.001, WHY? Jag	by Ron Coderre	1	1,130
Protection and Spell check ochoaex	by ochoaex	0	407
Using Logical Function in Pivot Calculation Mike G	by Mike G	0	447
count with filter lucas	by lucas	4	713
NA() lucas	by lucas	3	415
... round a time entry to the next "30 minute increment"... Dr. Darrell	by Roger Govier	12	1,726
=DATEDIF Excel User001	by Excel User001	2	503
summing previously ranked values ellebelle	by ellebelle	4	480
Current cell position AJPendragon	by Ron Rosenfeld	1	774
#N/A conditional format ellebelle	by bpeltzer	1	544
Difficult for me, probably basic to you onlyjohn	by Arvi Laanemets	1	1,143
change cursor to highlight cell I'm in BMac	by Paul B	1	552
Function that will copy sheet to sheet IF... underdog	by underdog	0	516
Sum like items JCowell	by ExcelPower	6	972
Automate Spreadsheet Karen	by Ron de Bruin	3	1,021
How do I allow multiple choices in a list-box? rmcgreg	by rmcgreg	0	722
Can I display comments in a validation list Stoke	by Dave Peterson	1	467
Totals sheet - deal with employee names babs	by babs	0	545
Conditional Formatting Formula jgp_2	by Kevin Vaughn	1	542
Linking to a closed workbook Danedel	by Harlan Grove	2	746
Office 2000 vs 2003 hshayh0rn	by Kevin Vaughn	1	339
Digits in ascending order ? toyota58	by toyota58	2	638
Compare cells and Create a new File sp123	by sp123	0	429
Vlookup - no match jenhow	by PCLIVE	2	461
Date Function Gos-C	by Kevin Vaughn	3	356
Sumif Function ml0	by Dana DeLouis	8	434
Vlookup problem with Date Time normajmarsh	by normajmarsh	0	1,625
How to place parenthesis around a negative percentage calculation. Kay	by Bernard Liengme	1	1,899
currency Problem irresistible007	by Bernard Liengme	3	416
Countif or Vlookup praveen_khm	by praveen_khm	1	666
copy, insert and add digits Ronco Bill	by SVC	1	569
Need to get rid of 0's and replace with Blanks Intuit	by Intuit	3	1,230
My If+If+If etc.. is too long! Anyone know a better way?! Statler	by Bob Tarburton	7	450
Combo Boxes for data entry moorefun	by Debra Dalgleish	1	468
Counting and Summarizing Data Phillycheese5	by Domenic	1	376
complex count FSmitty	by Biff	7	425
Edit Query [email protected]	by [email protected]	0	411
How can you use multiple ranges in a function? solinar	by solinar	7	821
Average every 20 rows Karen K	by daddylonglegs	4	6,171
INDIRECT EXTERNAL DATA saveas getting rid of formulas	by Ron Rosenfeld	7	1,172
SUMPRODUCT? robo	by Don Guillett	5	422
vlookup into 2 shhets Brian Thompson via OfficeKB.com	by Pete	5	324
Look up/math text JN	by Aladin Akyurek	11	1,216
sumproduct? JR	by Aladin Akyurek	1	364
Rank & Match Problem Nuno D	by Aladin Akyurek	3	428
New user with a question earljoe	by [email protected]	2	385
Text to Number Value. mseifert_99	by [email protected]	2	413
'if' and 'and' Lynneth	by Max	2	370
Run macros on protected worksheet paul	by paul	0	531
Is there a macro for Canadian compounding [email protected]	by [email protected]	0	518
Data compiling formula FangYR	by Max	3	833
options custom list davemorrison	by Max	1	340
Excel subtotals should subtotal "blanks" separately. id4post20061	by id4post20061	0	592
Auto update to "tab" in a reference link Missy	by paul	1	501
Column Labels (A, B) are showing us as numbers (1,2). Please Help Diane	by Ron Coderre	2	637
Check Boxes paul	by paul	0	525
Hyperlink from one cell to another Lexus	by Don Guillett	2	422
Converting to Decimal degree's Gary''s Student	by Gary''s Student	0	487
MIN to get three lowest DKY	by Domenic	2	374