Excel Worksheet Functions - Page 863

Thread / Thread Starter	Last Post	Replies	Views
Combo Boxes for data entry moorefun	by Debra Dalgleish	1	490
My If+If+If etc.. is too long! Anyone know a better way?! Statler	by Bob Tarburton	7	475
Need to get rid of 0's and replace with Blanks Intuit	by Intuit	3	1,273
copy, insert and add digits Ronco Bill	by SVC	1	593
Countif or Vlookup praveen_khm	by praveen_khm	1	677
currency Problem irresistible007	by Bernard Liengme	3	449
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,660
Sumif Function ml0	by Dana DeLouis	8	451
Date Function Gos-C	by Kevin Vaughn	3	372
Vlookup - no match jenhow	by PCLIVE	2	485
Compare cells and Create a new File sp123	by sp123	0	460
Digits in ascending order ? toyota58	by toyota58	2	663
Office 2000 vs 2003 hshayh0rn	by Kevin Vaughn	1	345
Linking to a closed workbook Danedel	by Harlan Grove	2	763
Conditional Formatting Formula jgp_2	by Kevin Vaughn	1	577
Totals sheet - deal with employee names babs	by babs	0	555
Can I display comments in a validation list Stoke	by Dave Peterson	1	499
How do I allow multiple choices in a list-box? rmcgreg	by rmcgreg	0	747
Automate Spreadsheet Karen	by Ron de Bruin	3	1,067
Sum like items JCowell	by ExcelPower	6	983
Function that will copy sheet to sheet IF... underdog	by underdog	0	537
change cursor to highlight cell I'm in BMac	by Paul B	1	572
Difficult for me, probably basic to you onlyjohn	by Arvi Laanemets	1	1,182
#N/A conditional format ellebelle	by bpeltzer	1	565
Current cell position AJPendragon	by Ron Rosenfeld	1	787
summing previously ranked values ellebelle	by ellebelle	4	499
=DATEDIF Excel User001	by Excel User001	2	525
... round a time entry to the next "30 minute increment"... Dr. Darrell	by Roger Govier	12	1,757
NA() lucas	by lucas	3	424
count with filter lucas	by lucas	4	732
Using Logical Function in Pivot Calculation Mike G	by Mike G	0	468
Protection and Spell check ochoaex	by ochoaex	0	419
Enter 1 in a cell, excel change to 0.001, WHY? Jag	by Ron Coderre	1	1,170
Calculating Overtime sam13484 via OfficeKB.com	by	1	575
Week Number Decreenisi	by Decreenisi	3	677
joining worksheets Brion	by Bernie Deitrick	1	442
Text to Columns - Only want to split SPECIFIC NUMBER of times NewKid	by Guy Yeakley	9	864
In a linked calculation how do I lose the '0' in the linked file? Anita	by Max	2	863
I am trying to round a list of numbers (prices) to xx.95. Is the Comexe35	by Pete	3	491
Using '=MIN(DATE(YEAR(A1),MONTH(A1)+{7,6},DAY(A1)*{0,1}) )' JNW	by JNW	11	1,641
FOrmulas in MS Excel Gagan	by CLR	1	335
vlookup in several sheets kris	by Domenic	2	820
product from k= 0 to n sylphide	by Niek Otten	3	420
summing previously ranked values ellebelle	by ellebelle	0	400
Vlookup not working because of duplicate matches BBS	by Kevin Vaughn	8	925
COUNTIF using exclusions djDaemon	by JMB	1	534
Change Date without Opening the Workbook ad2maso	by ad2maso	0	563
How to show the defined name of another cell Bol	by Bol	3	444
Auto Insert/Auto Formula? Abacus	by Robert	1	736
vlookup BSantos	by JMB	2	319
unique order number according to criteria ellebelle	by ellebelle	1	598
Randomize rows Robb Quirk	by WSI	4	507
Average every 20 rows JMB	by JMB	0	357
HELP!!!!!!!!!!!!please!!!!!!!! Rosie	by Rosie	2	450
summing values appearing in col B when col A has been filtered choc_penguin	by Kevin Vaughn	3	681
Difficult for me, probably basic to you justjohn	by justjohn	7	595
if equation Robert	by kjs	3	554
Copy data into/from textbox nubee	by nubee	0	435
Returning Multiple Text or Address Locations jdurrmsu	by Max	3	518
Adding a constant to a formula. Problems w/filling in zuri125	by Biff	4	536
populating spreedsheet with data from access kuansheng	by kuansheng	0	411
time elapsed formula sue	by Fred Smith	3	1,161
calculated field - Pivot Table Matt M HMS	by Debra Dalgleish	1	678
cell address ellebelle	by Bob Phillips	5	702
Groups of numbers evanr	by Elkar	1	349
Sorting by number of ocurrences! tbalza	by tbalza	4	608
comission split based on 365 days haidith	by haidith	2	396
user defined function help Floyd Steele	by Gord Dibben	1	713
Concatenation question ~C	by bpeltzer	1	526
Resorting full names Jim Sigurdson	by Jim Sigurdson	2	779
invoice toolbar spartan76_98	by spartan76_98	0	370
Limit drop down list and linking to other info Intuit	by Biff	13	2,391
vlookup BSantos	by Kou Vang	1	327
Macro for Subtotals lips	by lips	0	437