Excel Worksheet Functions - Page 863

Thread / Thread Starter	Last Post	Replies	Views
Combo Boxes for data entry moorefun	by Debra Dalgleish	1	468
My If+If+If etc.. is too long! Anyone know a better way?! Statler	by Bob Tarburton	7	450
Need to get rid of 0's and replace with Blanks Intuit	by Intuit	3	1,230
copy, insert and add digits Ronco Bill	by SVC	1	566
Countif or Vlookup praveen_khm	by praveen_khm	1	666
currency Problem irresistible007	by Bernard Liengme	3	407
How to place parenthesis around a negative percentage calculation. Kay	by Bernard Liengme	1	1,898
Vlookup problem with Date Time normajmarsh	by normajmarsh	0	1,624
Sumif Function ml0	by Dana DeLouis	8	434
Date Function Gos-C	by Kevin Vaughn	3	353
Vlookup - no match jenhow	by PCLIVE	2	459
Compare cells and Create a new File sp123	by sp123	0	427
Digits in ascending order ? toyota58	by toyota58	2	638
Office 2000 vs 2003 hshayh0rn	by Kevin Vaughn	1	337
Linking to a closed workbook Danedel	by Harlan Grove	2	746
Conditional Formatting Formula jgp_2	by Kevin Vaughn	1	542
Totals sheet - deal with employee names babs	by babs	0	545
Can I display comments in a validation list Stoke	by Dave Peterson	1	467
How do I allow multiple choices in a list-box? rmcgreg	by rmcgreg	0	722
Automate Spreadsheet Karen	by Ron de Bruin	3	1,021
Sum like items JCowell	by ExcelPower	6	970
Function that will copy sheet to sheet IF... underdog	by underdog	0	516
change cursor to highlight cell I'm in BMac	by Paul B	1	551
Difficult for me, probably basic to you onlyjohn	by Arvi Laanemets	1	1,142
#N/A conditional format ellebelle	by bpeltzer	1	542
Current cell position AJPendragon	by Ron Rosenfeld	1	772
summing previously ranked values ellebelle	by ellebelle	4	480
=DATEDIF Excel User001	by Excel User001	2	503
... round a time entry to the next "30 minute increment"... Dr. Darrell	by Roger Govier	12	1,726
NA() lucas	by lucas	3	407
count with filter lucas	by lucas	4	710
Using Logical Function in Pivot Calculation Mike G	by Mike G	0	442
Protection and Spell check ochoaex	by ochoaex	0	405
Enter 1 in a cell, excel change to 0.001, WHY? Jag	by Ron Coderre	1	1,130
Calculating Overtime sam13484 via OfficeKB.com	by	1	557
Week Number Decreenisi	by Decreenisi	3	662
joining worksheets Brion	by Bernie Deitrick	1	434
Text to Columns - Only want to split SPECIFIC NUMBER of times NewKid	by Guy Yeakley	9	826
In a linked calculation how do I lose the '0' in the linked file? Anita	by Max	2	792
I am trying to round a list of numbers (prices) to xx.95. Is the Comexe35	by Pete	3	477
Using '=MIN(DATE(YEAR(A1),MONTH(A1)+{7,6},DAY(A1)*{0,1}) )' JNW	by JNW	11	1,597
FOrmulas in MS Excel Gagan	by CLR	1	324
vlookup in several sheets kris	by Domenic	2	795
product from k= 0 to n sylphide	by Niek Otten	3	404
summing previously ranked values ellebelle	by ellebelle	0	386
Vlookup not working because of duplicate matches BBS	by Kevin Vaughn	8	900
COUNTIF using exclusions djDaemon	by JMB	1	512
Change Date without Opening the Workbook ad2maso	by ad2maso	0	539
How to show the defined name of another cell Bol	by Bol	3	424
Auto Insert/Auto Formula? Abacus	by Robert	1	717
vlookup BSantos	by JMB	2	305
unique order number according to criteria ellebelle	by ellebelle	1	572
Randomize rows Robb Quirk	by WSI	4	479
Average every 20 rows JMB	by JMB	0	329
HELP!!!!!!!!!!!!please!!!!!!!! Rosie	by Rosie	2	421
summing values appearing in col B when col A has been filtered choc_penguin	by Kevin Vaughn	3	652
Difficult for me, probably basic to you justjohn	by justjohn	7	563
if equation Robert	by kjs	3	537
Copy data into/from textbox nubee	by nubee	0	410
Returning Multiple Text or Address Locations jdurrmsu	by Max	3	491
Adding a constant to a formula. Problems w/filling in zuri125	by Biff	4	509
populating spreedsheet with data from access kuansheng	by kuansheng	0	380
time elapsed formula sue	by Fred Smith	3	1,132
calculated field - Pivot Table Matt M HMS	by Debra Dalgleish	1	647
cell address ellebelle	by Bob Phillips	5	689
Groups of numbers evanr	by Elkar	1	336
Sorting by number of ocurrences! tbalza	by tbalza	4	570
comission split based on 365 days haidith	by haidith	2	382
user defined function help Floyd Steele	by Gord Dibben	1	681
Concatenation question ~C	by bpeltzer	1	496
Resorting full names Jim Sigurdson	by Jim Sigurdson	2	724
invoice toolbar spartan76_98	by spartan76_98	0	359
Limit drop down list and linking to other info Intuit	by Biff	13	2,289
vlookup BSantos	by Kou Vang	1	324
Macro for Subtotals lips	by lips	0	425