Excel Worksheet Functions - Page 863

Thread / Thread Starter	Last Post	Replies	Views
Combo Boxes for data entry moorefun	by Debra Dalgleish	1	486
My If+If+If etc.. is too long! Anyone know a better way?! Statler	by Bob Tarburton	7	470
Need to get rid of 0's and replace with Blanks Intuit	by Intuit	3	1,262
copy, insert and add digits Ronco Bill	by SVC	1	582
Countif or Vlookup praveen_khm	by praveen_khm	1	677
currency Problem irresistible007	by Bernard Liengme	3	438
How to place parenthesis around a negative percentage calculation. Kay	by Bernard Liengme	1	1,926
Vlookup problem with Date Time normajmarsh	by normajmarsh	0	1,650
Sumif Function ml0	by Dana DeLouis	8	436
Date Function Gos-C	by Kevin Vaughn	3	359
Vlookup - no match jenhow	by PCLIVE	2	484
Compare cells and Create a new File sp123	by sp123	0	460
Digits in ascending order ? toyota58	by toyota58	2	658
Office 2000 vs 2003 hshayh0rn	by Kevin Vaughn	1	345
Linking to a closed workbook Danedel	by Harlan Grove	2	758
Conditional Formatting Formula jgp_2	by Kevin Vaughn	1	569
Totals sheet - deal with employee names babs	by babs	0	555
Can I display comments in a validation list Stoke	by Dave Peterson	1	495
How do I allow multiple choices in a list-box? rmcgreg	by rmcgreg	0	738
Automate Spreadsheet Karen	by Ron de Bruin	3	1,054
Sum like items JCowell	by ExcelPower	6	974
Function that will copy sheet to sheet IF... underdog	by underdog	0	535
change cursor to highlight cell I'm in BMac	by Paul B	1	560
Difficult for me, probably basic to you onlyjohn	by Arvi Laanemets	1	1,182
#N/A conditional format ellebelle	by bpeltzer	1	554
Current cell position AJPendragon	by Ron Rosenfeld	1	782
summing previously ranked values ellebelle	by ellebelle	4	489
=DATEDIF Excel User001	by Excel User001	2	514
... round a time entry to the next "30 minute increment"... Dr. Darrell	by Roger Govier	12	1,757
NA() lucas	by lucas	3	423
count with filter lucas	by lucas	4	721
Using Logical Function in Pivot Calculation Mike G	by Mike G	0	468
Protection and Spell check ochoaex	by ochoaex	0	418
Enter 1 in a cell, excel change to 0.001, WHY? Jag	by Ron Coderre	1	1,163
Calculating Overtime sam13484 via OfficeKB.com	by	1	566
Week Number Decreenisi	by Decreenisi	3	673
joining worksheets Brion	by Bernie Deitrick	1	442
Text to Columns - Only want to split SPECIFIC NUMBER of times NewKid	by Guy Yeakley	9	858
In a linked calculation how do I lose the '0' in the linked file? Anita	by Max	2	855
I am trying to round a list of numbers (prices) to xx.95. Is the Comexe35	by Pete	3	490
Using '=MIN(DATE(YEAR(A1),MONTH(A1)+{7,6},DAY(A1)*{0,1}) )' JNW	by JNW	11	1,634
FOrmulas in MS Excel Gagan	by CLR	1	327
vlookup in several sheets kris	by Domenic	2	814
product from k= 0 to n sylphide	by Niek Otten	3	420
summing previously ranked values ellebelle	by ellebelle	0	390
Vlookup not working because of duplicate matches BBS	by Kevin Vaughn	8	919
COUNTIF using exclusions djDaemon	by JMB	1	529
Change Date without Opening the Workbook ad2maso	by ad2maso	0	561
How to show the defined name of another cell Bol	by Bol	3	440
Auto Insert/Auto Formula? Abacus	by Robert	1	734
vlookup BSantos	by JMB	2	316
unique order number according to criteria ellebelle	by ellebelle	1	590
Randomize rows Robb Quirk	by WSI	4	497
Average every 20 rows JMB	by JMB	0	346
HELP!!!!!!!!!!!!please!!!!!!!! Rosie	by Rosie	2	442
summing values appearing in col B when col A has been filtered choc_penguin	by Kevin Vaughn	3	672
Difficult for me, probably basic to you justjohn	by justjohn	7	591
if equation Robert	by kjs	3	546
Copy data into/from textbox nubee	by nubee	0	425
Returning Multiple Text or Address Locations jdurrmsu	by Max	3	508
Adding a constant to a formula. Problems w/filling in zuri125	by Biff	4	525
populating spreedsheet with data from access kuansheng	by kuansheng	0	403
time elapsed formula sue	by Fred Smith	3	1,160
calculated field - Pivot Table Matt M HMS	by Debra Dalgleish	1	670
cell address ellebelle	by Bob Phillips	5	702
Groups of numbers evanr	by Elkar	1	343
Sorting by number of ocurrences! tbalza	by tbalza	4	596
comission split based on 365 days haidith	by haidith	2	389
user defined function help Floyd Steele	by Gord Dibben	1	711
Concatenation question ~C	by bpeltzer	1	517
Resorting full names Jim Sigurdson	by Jim Sigurdson	2	771
invoice toolbar spartan76_98	by spartan76_98	0	367
Limit drop down list and linking to other info Intuit	by Biff	13	2,383
vlookup BSantos	by Kou Vang	1	327
Macro for Subtotals lips	by lips	0	430