Excel Worksheet Functions - Page 170

Thread / Thread Starter	Last Post	Replies	Views
Sum product help needed with an extra variable please and thankyou Anthony	by Anthony	6	448
Copy VLookup Values Karen	by KL	3	843
Find the combination of numbers that when added equal a reqired total?? Handsy11	by Handsy11	5	2,406
Adding new numbers as I type without duplicates from Sheet1,ColumnA to Sheet2,ColumnA Master	by Master	2	727
Excel will not add cells automatically together when selected? Dom23	by Bob Phillips	2	2,833
average Renee - California	by Renee - California	12	681
Substitute for Pivot tables? DerbyJim1978	by DerbyJim1978	0	425
Using functions to paste from one worksheet into another Neon	by Neon	0	303
toolbar for "standard tickmarks" mark kubicki	by mark kubicki	0	1,110
Lookup or Match ? carl	by Max	4	479
convert interval to various separate date , time, hr, minutes Todd F.	by Todd F.	4	1,765
label caption equal excel value Monique	by Ian	1	711
finding data SheriTingle	by VoG via OfficeKB.com	2	422
can it be copied instead of referenced D.R. - Help	by Duke Carey	2	280
can I put a note in an excel formula danno1	by Dave Peterson	3	494
Help: I need a function for finding next cell vertically with value tobriant	by Dave Peterson	1	636
SaveNClose Steved	by Steved	4	300
Forcing a sum formula... LBDuperon	by LBDuperon	5	273
EXCEL J.P. Smith	by Don Guillett	1	295
searching for a space " " wahamler	by RagDyer	2	289
Need Function for Double If Jones	by RagDyer	2	368
Generating a table Comicfly	by JBoulton	3	385
F4 key does not toggle relative/absolute cell references. java	by Niek Otten	2	1,573
How do I show dates older than present date? Sissyfirst	by Matt Lunn	1	768
perform caculations on displayed value in Excel 2000 Amir	by Niek Otten	2	355
AUTOMATIC SORTING PROBLEMS SYBS	by bj	4	497
Trim cell contents Kim C via OfficeKB.com	by Kim C via OfficeKB.com	4	529
To Biff: Using Match with multiple criteria Joe Gieder	by Biff	5	476
Excel Rounding Up to Nearest Multiple jshrader	by jshrader	2	730
Rounding currency. Jessi0198	by Sandy Mann	3	434
How can I add a percentage sign to a cell with data validation Glen	by Glen	4	911
can't figure it gvm	by gvm	2	481
Pivot Table Field Settings Pivot Novice	by Debra Dalgleish	5	1,055
Perform the square root function in excel. Se7en	by Bernard Liengme	2	712
INDIRECT Function impact on Copy Worksheet BG	by Max	5	828
Can Vlookup check a cell to the left? koala	by Ashish Mathur	3	522
DSUM with External Database Amin Joseph	by Amin Joseph	0	644
unrestricting drop down lists Robert	by RagDyer	2	1,084
I am trying to figure out how to add per 1000 DG	by Ashish Mathur	5	430
Compare 2 columns to see differences Bugaglugs	by Ashish Mathur	4	675
Setting formula to give info from rows with certain criteria Phish	by Govind	1	467
Adding times Jim	by Fred Smith	2	429
Offsetting the Rows of a VLookup Result John	by Biff	4	409
transfering numbers into teams Claude Laframboise	by Max	2	549
Pivot -- want to use Max and Sum in same table Dave	by Gary Rowe	1	2,070
Calculating a sum of various lenght ASA	by Krishnakumar	3	442
LOOKUP VALUES gordo	by Meldoy	5	329
Negative Working Hours Mohammed Zenuwah	by Mohammed Zenuwah	2	731
Filling excel entire row/column instead of single cell from an array shitij	by KL	3	845
Pivot Tables Dave	by Basil	3	321
how do I test for Integer? Stephen P Thomas	by Shaz	4	1,613
Counting the number of rows blurboiboi	by Anne Troy	1	619
how do i convert from rands to zambian currency Moozie	by Mangesh Yadav	1	388
Start spreadsheet with WinXP start Gordon Gradwell	by dominicb	1	855
I have had difficulty in creating user defined functions in Excel MichaelG	by MichaelG	3	990
How do I make a calculation? Rob P	by Rob P	2	401
Help! Formula to find the address of particular value in sheet xcelion	by xcelion	2	1,978
referencing another worksheet chartasap	by chartasap	2	441
Time between two dates (Excluding Non-bus Hrs) lnapier	by lnapier	0	793
Modify a Formula to Display Blank carl	by Anne Troy	2	472
Using autofilter and excel form format Donna in Elkin, NC	by Donna in Elkin, NC	0	381
a cell reference in a 3d reference chartasap	by Tom Ogilvy	1	482
30 Arugments limit- SUM, AVERAGE, etc. Bryan - [email protected]	by Bryan - [email protected]	3	387
How do I remove all text in a cell after a specific character? Erik Millerd	by moi	1	695
How do I delete all named ranges in a sheet at one time? L.Wall	by Bob Phillips	2	865
Figure out the hours worked for the week Svetlana	by Bob Phillips	2	418
Date function Dee	by Bob Phillips	2	703
Multiple conditions cruzin	by bj	3	336
More Multiple conditions cruzin	by Bernard Liengme	1	295
Removing a page break from excel Na'an	by Bernard Liengme	2	855
Worksheet tabs viewing there of Anthony	by Anthony	2	519
How do I multiply a whole column by a number? cowboyeti	by DerbyJim1978	1	1,438
Reference tjh	by Duke Carey	1	371
Printout doesn't match screen view (columns wrap differently). SheriBee	by Duke Carey	1	943
cell validation even for values pasted into cells JR_06062005	by JR_06062005	2	768