Excel Worksheet Functions - Page 1003

Thread / Thread Starter	Last Post	Replies	Views
Multiple Validations in for 1 cell dmcnutt_ghg	by Bob Phillips	1	637
Active cell counting in particular print page (one sheet having different print area) ananthmca2004	by antoka05	1	1,356
How to tackle Division by zero for DAVERAGE function Sharma	by Biff	1	924
Printing Certain Columns DonDon	by Dave Peterson	1	613
matching data from column b tbax6	by bpeltzer	1	612
PMT function joemoran7	by Louise	1	411
I would like the worksheet auto name itself with a formula SJA	by Barb Reinhardt	1	453
Can criteria in countif statement be a color? aosbor	by Bob Phillips	1	981
count and lookup eoht	by Bob Phillips	1	472
GETPIVOTDATA question regarding adding "rows" CamiK	by Debra Dalgleish	1	588
how to fetch a row and post the row into another sheelt ananthmca2004	by Roland	1	397
What excel function to use? Excel user	by Bob Phillips	1	419
Formula/Array question with dates Renee	by DOR	1	525
Have 2 items in dropdown, want warning if one selected movermike	by L. Howard Kittle	1	574
How to return the text data of the first col after getting the max value from the 2nd col Joyce	by David Billigmeier	1	430
Calculate Hours and overtime by week gregt812	by DOR	1	1,057
Can a conditional formatting result affect another cell or cells marseans	by Barb Reinhardt	1	641
Filter one column for all "Pending" CaptDunsull	by Dave Peterson	1	352
Can you make all sheets scroll when scrolling one sheet billy boy	by Bernie Deitrick	1	652
#DIV/0! in the array function Sergun	by Bob Phillips	1	524
Counting repeatation Sevi	by Biff	1	413
In one appl. I have lost the vert. scroll bar.Tools no help Robt.	by Dave Peterson	1	591
xml Kelly	by Gord Dibben	1	477
Help with Comparing values and retrieving values in Excel!!!!!! [email protected]	by Dave Peterson	1	660
Pulling information from one worksheet into another Monika	by Teethless mama	1	533
Parameters wthin Query of External Data Sean	by Dave F	1	511
#NAME error GerryK	by Dave F	1	464
How do you calculate logistic regression. timothy	by Mike Middleton	1	3,402
unprotect sheets BC@D	by Paul B	1	398
Time and Business Hours Brett	by Biff	1	607
Problems with setting up a billing budjet JoeStL	by Roger Govier	1	477
convert numercials into words Younus Khatri	by Paul B	1	672
How do I extract data from graph (i.e. interpolaton) TauBrewer	by Gary''s Student	1	578
Matrix Dimension Michelle	by Peo Sjoblom	1	553
complex amortization cfspahn24	by Fred Smith	1	845
Time code cell format pauls510	by Bob Phillips	1	555
Click button to automatically add row yirawan	by Ron de Bruin	1	5,148
Excel - need a function to compare lists JerryMatson	by Niek Otten	1	885
Searching for multiple results in one cell VLB	by Domenic	1	623
remove all "," gregory	by John Michl	1	499
Rolling 3 mth Average dallin	by Roger Govier	1	737
How do I compare the difference in two spreadsheets? Daysi	by Richard Buttrey	1	884
IF statement joemoran7	by MDBCT	1	418
Using hide in excel get "cannot shift objects off sheet" snowbounduk	by Gary L Brown	1	1,007
Lookup type formula Lee Harris	by Max	1	636
formula question	by Max	1	621
shift right 5 columns raymond chiu	by Gord Dibben	1	632
Calculating slope, intercept, LOGEST with empty cells in data Rich	by Jerry W. Lewis	1	1,801
Find a negative number in a range Scott at Culvers	by Roger Govier	1	1,761
can I reference a sheet name in a cell as text? Karl Barthel	by GerryK	1	851
is there a standard formula for this? keith	by Biff	1	545
accounting or numbeic numbers LindaLea	by Gary''s Student	1	361
Sumproduct formulas & slow response Darby	by Bernie Deitrick	1	1,027
Insert-Subtotals makes Column Outlines disappear gpie	by gpie	1	544
How to add a column of accumulated data in pivottable? Angus	by cs02000	1	1,080
Calculating percentages in pivot tables on subtotals David Ruderman - Chapman University	by cs02000	1	1,651
Using a Pivot Table Calculated Field to get a Unique Count Mike Struckman	by cs02000	1	4,007
Calculate duration in Excel 2000 Babette	by Sandy Mann	1	940
color fill cells based on IF function or formula Victor Jones	by Peo Sjoblom	1	1,627
vb code - Automatic transfer of data from one sheet to another herr_bench	by Gord Dibben	1	1,464
-ve no with -1; positive with sign+ and 0 no sign? Tks. shirley	by Rowan Drummond	1	851
How to create a menue bar of numbers in a cell? DORI	by Rowan Drummond	1	524
importing data Grant M	by Richard Buttrey	1	478
Tab Key WVBillingCSR Sarah	by Gord Dibben	1	412
Is it possable? michaelp	by paul	1	443
format cells Eric	by Lotus123	1	299
Calculated fields-Pivot tables Kim	by cs02000	1	801
Formula questions mstangel	by Roger Govier	1	460
deleting macros that are not really in my workbook? mydogpeanut	by Gord Dibben	1	527
Count on multiple values with duplicate rows Carla	by Barb Reinhardt	1	1,089
VB Protection problem Rmagic	by Dave Peterson	1	544
adding three consecutive columns Darin Gibson	by Gary''s Student	1	1,039
counting the number of times something is bought during a month ldd	by bpeltzer	1	700
getting the last cell value in a column amrezzat	by Ron Coderre	1	410
0 in linked cells when watched steve	by Roger Govier	1	564