Excel Worksheet Functions - Page 1014

Thread / Thread Starter	Last Post	Replies	Views
Pivot Tables Dave	by Basil	3	355
Filling excel entire row/column instead of single cell from an array shitij	by KL	3	893
Negative Working Hours Mohammed Zenuwah	by Mohammed Zenuwah	2	756
LOOKUP VALUES gordo	by Meldoy	5	336
Calculating a sum of various lenght ASA	by Krishnakumar	3	470
Pivot -- want to use Max and Sum in same table Dave	by Gary Rowe	1	2,100
transfering numbers into teams Claude Laframboise	by Max	2	557
Offsetting the Rows of a VLookup Result John	by Biff	4	424
Adding times Jim	by Fred Smith	2	451
Setting formula to give info from rows with certain criteria Phish	by Govind	1	480
Compare 2 columns to see differences Bugaglugs	by Ashish Mathur	4	696
I am trying to figure out how to add per 1000 DG	by Ashish Mathur	5	445
unrestricting drop down lists Robert	by RagDyer	2	1,099
DSUM with External Database Amin Joseph	by Amin Joseph	0	653
Can Vlookup check a cell to the left? koala	by Ashish Mathur	3	542
INDIRECT Function impact on Copy Worksheet BG	by Max	5	863
Perform the square root function in excel. Se7en	by Bernard Liengme	2	729
Pivot Table Field Settings Pivot Novice	by Debra Dalgleish	5	1,075
can't figure it gvm	by gvm	2	493
How can I add a percentage sign to a cell with data validation Glen	by Glen	4	924
Rounding currency. Jessi0198	by Sandy Mann	3	442
Excel Rounding Up to Nearest Multiple jshrader	by jshrader	2	739
To Biff: Using Match with multiple criteria Joe Gieder	by Biff	5	496
Trim cell contents Kim C via OfficeKB.com	by Kim C via OfficeKB.com	4	540
AUTOMATIC SORTING PROBLEMS SYBS	by bj	4	512
perform caculations on displayed value in Excel 2000 Amir	by Niek Otten	2	369
How do I show dates older than present date? Sissyfirst	by Matt Lunn	1	792
F4 key does not toggle relative/absolute cell references. java	by Niek Otten	2	1,604
Generating a table Comicfly	by JBoulton	3	399
Need Function for Double If Jones	by RagDyer	2	381
searching for a space " " wahamler	by RagDyer	2	299
EXCEL J.P. Smith	by Don Guillett	1	308
Forcing a sum formula... LBDuperon	by LBDuperon	5	280
SaveNClose Steved	by Steved	4	311
Help: I need a function for finding next cell vertically with value tobriant	by Dave Peterson	1	653
can I put a note in an excel formula danno1	by Dave Peterson	3	504
can it be copied instead of referenced D.R. - Help	by Duke Carey	2	292
finding data SheriTingle	by VoG via OfficeKB.com	2	447
label caption equal excel value Monique	by Ian	1	832
convert interval to various separate date , time, hr, minutes Todd F.	by Todd F.	4	1,942
Lookup or Match ? carl	by Max	4	488
toolbar for "standard tickmarks" mark kubicki	by mark kubicki	0	1,124
Using functions to paste from one worksheet into another Neon	by Neon	0	308
Substitute for Pivot tables? DerbyJim1978	by DerbyJim1978	0	451
average Renee - California	by Renee - California	12	701
Excel will not add cells automatically together when selected? Dom23	by Bob Phillips	2	2,888
Adding new numbers as I type without duplicates from Sheet1,ColumnA to Sheet2,ColumnA Master	by Master	2	761
Find the combination of numbers that when added equal a reqired total?? Handsy11	by Handsy11	5	2,432
Copy VLookup Values Karen	by KL	3	865
Sum product help needed with an extra variable please and thankyou Anthony	by Anthony	6	466
In excel the sum is not calculating Melody	by Anthony	3	841
can anyone help with repeating the same action on different ranges? Angol	by Angol	0	402
future dates kevrgallagher	by kevrgallagher	4	435
dynamic cell references excel novice	by excel novice	2	426
Count how many "name" in a column pigbelly	by Bob Phillips	4	480
Using Match with multiple criteria Joe Gieder	by Joe Gieder	3	766
Function for Rounding of Number aries0070	by Jerry W. Lewis	12	877
Import Format Using Vlookup SixString	by SixString	2	668
Function Bug ? ddelong	by Jerry W. Lewis	8	312
Leading Zeros and decimal points Sam	by Sam	3	861
countif function andrewm	by Krishnakumar	1	356
formula to populate while skipping blank fields Chris Hudd	by Bob Phillips	1	591
sort dates by day then month, not by year. Lisa Peterson	by Bob Phillips	5	1,407
Macro's JaneC	by Bob Phillips	1	436
In a protected worksheet allow users to delete rows Jason Trivett	by Ian	1	1,166
how to convert Lotus 123 to Excel directly and can running normal Ham3dy	by moi	1	497
How do i change the date 6302000 to 6/30/2000 ? George	by Aladin Akyurek	3	385
Same data box on two pages? mattflow	by Rowan	1	290
Function for more than 1 criteria rhani111	by Biff	2	299
how to get the number of days between two date formatted fields in vba for excel? Daniel	by Rowan	1	538
how do i make it so that when a sheat is selected either via link or tab, that xlLastCell is selected. the last on the sheet. Daniel	by Rowan	1	773
sumproduct bombs out JN	by Sandy Mann	15	759
Duplicate P/N and sums Steve ([email protected])	by Steve ([email protected])	4	371
is it possible to select and change the values of cells in a minimized excel spread sheet from vba? Daniel	by Daniel	6	1,111
countif Renee - California	by Renee - California	4	447