Excel Worksheet Functions - Page 802

Thread / Thread Starter	Last Post	Replies	Views
sumproduct question - kind of... Poody	by Poody	3	511
Macro help ChuckF	by ChuckF	1	347
Another time addition problem Martin B	by Bob Phillips	2	449
VLOOKUP - 2 Questions Kathy - Lovullo	by Peo Sjoblom	1	633
copy data from various sheets into one sheet vik	by Ron de Bruin	2	1,177
Formula w/negative no.s & Percentage Anshin	by Anshin	2	861
Insert Subtotal button Victor Delta	by Victor Delta	0	611
Sumproduct Date clarification Walter Mayes	by Dave Peterson	7	418
order formulas are updated.. [email protected]	by Niek Otten	3	328
Changing Text format in a function FirstWizardZedd	by Peo Sjoblom	1	370
Using Match & Offset longhorn14	by longhorn14	4	695
CountIF() in Worksheet B while referencing cells in Worksheet A jfj3rd	by Bob Phillips	3	656
Vlookup Q NWO	by NWO	4	381
increasing and decreasing a value in a cell cwal	by cwal	6	575
Excel Formula or tool to compare two columns of data RBS	by Elkar	3	1,263
Copying problem MartinW	by Biff	7	439
TRIMMEAN with different percentiles? [email protected]	by Jerry W. Lewis	4	1,336
How can I set up a milestone report with red/green/amber alerts JPG	by JPG	5	1,004
Data consolidation from Multiple Sheets wingale	by Ardus Petus	1	802
Can you print indicators when inserting a comment? Carmen	by Carmen	2	520
need to ONLY display worksheets that have had recently changed K	by K	0	497
Formula for cells that contain a specific letter carrielu	by carrielu	5	1,087
how can update the data in an excel workbook without opening it dk	by dk	0	1,116
Formula too long - Shorter version? Blade2304	by daddylonglegs	3	383
Vlook up and if statements (I think) clevejoe	by clevejoe via OfficeKB.com	4	387
Lookup and compare rows setsuna	by Ashish Mathur	3	553
seeking of array Tomek S	by Ashish Mathur	6	603
Little help with weibull function needed kayard	by Jerry W. Lewis	2	912
how do i use import to consolidate data from multiple sheets Naveen	by Otto Moehrbach	1	655
data entry in excel by linking to other word doc. or excel sheets wangxuqin	by Duke Carey	1	1,491
2 column lookup - match to date range abehart	by Bob Phillips	3	608
Comparing and counting occurences in 2 columns Brian Johnston	by Ardus Petus	2	506
VLOOKUP works in some cells but not others. amberlodge	by Infinity	9	2,327
Need help with multiple argument formula Bill_De	by Bill_De	2	449
Excel Programming [email protected]	by [email protected]	0	461
How to make excell ignore non-whole numbers John_Doe69	by John_Doe69	5	661
changing the year of a date zapszipszops	by zapszipszops	2	670
How do I make out an invoice using Excel that has two pages Bruce	by Fred Smith	1	715
Import data into my workbook [email protected]	by Fred Smith	1	498
formula link to a file Param	by Param	0	579
updating a spreadsheet in 1 field w/ out changing values in anoth rmbpjw	by Otto Moehrbach	1	516
Password Param	by Param	2	448
Formula for rounding a column of currency to a multiple GenoBambino	by CLR	1	391
Importing data into excel SGT Buckeye	by Pete_UK	3	382
Highliting Duplicate Cells across multiple rows equinekingdom	by John James	4	648
Convert text in cell to a range name for formula Sawhney	by Doug Glancy	1	1,412
Sum if 2 conditions are met kieffer	by Pete_UK	1	382
Chart from different worksheets Teacher	by Teacher	0	361
I NEED A FLEXIBLE FORMULA QC Coug	by Cutter	7	494
ADDRESS Function QC Coug	by Gary''s Student	1	337
Public Macro Help (CFColorindex) carl	by Bob Phillips	3	520
Questionnaire sheet: Select "yes" or "no," and only one can be selected bpatterson	by MyVeryOwnSelf	2	1,323
pivot table field list rm	by Debra Dalgleish	1	833
Is there a go to function in excell Copper6203	by Copper6203	4	874
look up formulas Jill_	by Jill_	2	349
Is there a way to post a file to show an example? QC Coug	by Peo Sjoblom	1	402
Can the "Date Picker" from Infopath be used in Excel? Hawi	by Gord Dibben	2	452
How do I make the true return a drop down list in the IF function? Brian	by Gord Dibben	5	787
Nest a referenced formula in excel [email protected]	by Miguel Zapico	1	481
combining two lists karmaisgreat	by QC Coug	3	398
lookup single value in entire worksheet [email protected]	by [email protected]	2	582
Nesting Networkdays function inside and If function Addison	by Bob Phillips	2	1,731
Is there a way for Excel to create a task in Novell Groupwise Janie	by Janie	0	534
Convert Total Hours and Minutes to Whole Number BobS9895	by BobS9895	3	3,428
My Datedif function only returns 0's in the cell what's wrong? Tom	by Peo Sjoblom	1	983
How do i find a correlation between 2 data point or sets? autologus	by autologus	0	1,068
How do i calculate the total revenue in Excel? wondering	by Niek Otten	1	6,389
Conditional Format - 3 conditions Mike Saffer	by Mike Saffer	3	908
How to evaluate a 'dotted' number using formulae (not UDF) Alan	by Biff	10	764
Count Names in One Col if 2nd Col Isn't Blank jeffc	by Bob Phillips	9	483
formula to sort size kylnn	by CLR	3	376
How do I condense 3 columns into 1 in Excel? Niki	by Ardus Petus	1	1,681
use the current row in a list to populate a report David Murto	by Ardus Petus	1	822
Merging data from Multiple Worksheets wingale	by wingale	0	600
functions rami	by Duke Carey	1	497