Excel Worksheet Functions - Page 781

Thread / Thread Starter	Last Post	Replies	Views
Match and merge on new worksheet Traci	by David D	1	408
Trnasferring/ Copying Data Between Sheets Neil M	by David D	1	1,216
How to incorporate cell data in a worksheet header John Bennett	by David D	1	384
How to auto hide and unhide columns using 1 and 2 icons R. Rebello	by David D	1	710
Seperate cell string into individual cells ERudy	by Biff	2	1,228
V-LookUp help Asma Shah	by JMB	3	360
Summing every third cell bthieson	by Biff	6	435
Reference to Worksheet name SKY	by Biff	3	484
Time calculations joe z	by Biff	1	465
IRR formula for monthly cash flows MB Burgis	by Fred Smith	3	2,168
Calculate Elapsed Date and Time Gary F Shelton	by Fred Smith	3	2,056
If Match Part of Text Within Cell, Then Blank SteveC	by Biff	3	3,427
Excel, how do I count cell with data within a range? BRKirk	by Chip Pearson	2	530
Unlocking "check box" control function aliceinphx	by davesexcel	1	400
Simple Circular Reference Problem Gary	by JLatham	2	433
in data/filter/auto filter sp8	by Debra Dalgleish	2	1,014
Modified /advance "Max function "may help!! PA	by PA	3	541
Sort Problem - Please Hurry!! walleys25	by davesexcel	1	515
Copy a Workbook Automatically Len	by David Biddulph	1	426
Returning a Value if 3 Conditions are True brownie224	by David Biddulph	5	2,032
Create my own formula? james	by JLatham	2	384
How do I input a minus time in an excel spreadsheet Nadine NZ	by Lost for time	1	1,177
sum only visible cells hommer	by JLatham	5	848
How do I make hyperlinks? johnnstacy	by Peo Sjoblom	4	295
linking to a cell within a text cell or comment BlueJ2005	by BlueJ2005	0	471
I need to know how to 'Colour Tabs' in Excel 2000 Fed Up	by Don Guillett	6	511
Converting to Absolute Cell References - en bloc Basher Bates	by Peo Sjoblom	7	462
Date Population achapman	by achapman	5	608
2nd to MAX Danny	by Danny	2	412
Copying Sum Formulas Justin Hoffmann	by Peo Sjoblom	3	447
vlookup formula Ash	by Ash	2	514
Index function using multiple values in one cell [email protected]	by Biff	2	981
How can I sum data on a row from certain named columns? Liliana	by Biff	1	472
Is this formula going to work? yrose70	by Peo Sjoblom	1	404
Excel Fed Up	by Chip Pearson	1	370
IF Statement help please Alan Davies	by Bob Phillips	1	390
Find a value and return a corresponding number Irene	by Gary''s Student	3	1,068
count number of letters in a string Wiley	by Ron Coderre	3	848
How can I count the number of times a letter repeats in a string? Wiley	by Bob Phillips	3	1,161
Saving worksheets within workbooks as individual files Colin Hayes	by Ron de Bruin	4	695
How can I use an IF statement to find out if the cell is shaded? Pascual	by JethroUK©	1	395
Gas Mileage Patsy	by Patsy	4	581
Multiple sheet acherony	by acherony	0	307
UserForm Save Issue DarnTootn	by DarnTootn	0	552
IF Statements-call private sub CrimsonPlague29	by CrimsonPlague29	0	445
How do I show numbers in Excel as 48K instead of 48000? Scotty	by Peo Sjoblom	2	512
SUM of INDEX lookups Liz Steffen	by Peo Sjoblom	3	1,259
Using sum(1/countif....) not returning expected result Kent (thanks)	by Kent (thanks)	10	1,142
sumif function DAB	by DAB	2	374
array formulas disabled? erikheath	by erikheath	1	471
fill in data range knowing start and end values Julie	by Duke Carey	1	567
vlookup vs if, help required CraigSA	by CraigSA	0	437
Forms controls Catalin	by Catalin	2	459
combine 111 in one column & .jpg in another thru out entire works Ms.Faye.	by Ron Coderre	1	399
Time between days RamOst	by Ardus Petus	7	604
Make a formula to calculate the avarage of baseball stats Confused at Work	by SteveG	2	825
pls help with IF formula Raj Shah	by Raj Shah	2	285
Autofilter and Subtotals Sandy	by Miguel Zapico	1	424
REPOST: Which Function to Use Nick	by Nick	3	506
how can I highlight a cell if it meets year and month criteria Clyde	by Barb Reinhardt	2	978
Double and Multiple Lookup Using the MATCH Function Charles793	by Charles793	0	1,114
How do you create your own auto format for a pivot table Marlyn	by Marlyn	6	989
1 cell average across multiple worksheets curtll	by Domenic	8	1,668
Pivot table drill down formatting matelot	by Marlyn	1	1,187
How do you get the function of a pivot column to not appear Marlyn	by Marlyn	0	358
Sum product of many pairs of columns KeenKiwi	by Bob Phillips	3	869
COUNT IF < "" Bruce	by Arvi Laanemets	3	327
How to be noticed/to avoid equal values in a colum Irene	by Irene	7	534
Automated summaries/conversion SpencerMC	by Ardus Petus	1	364
Cell protection & Auto Filter fastballfreddy	by Paul B	1	1,018
price higher than... Thad	by myra_deV	2	309
external data function error Ken W	by Ken W	0	498
sum the results of a group of formulas astjels	by Bob Phillips	3	1,152
Query to find last saved date/Time Dean	by Bob Phillips	2	670
Index,Match table array in separate workbook Ben	by Ardus Petus	6	1,408