Excel Worksheet Functions - Page 781

Thread / Thread Starter	Last Post	Replies	Views
Match and merge on new worksheet Traci	by David D	1	398
Trnasferring/ Copying Data Between Sheets Neil M	by David D	1	1,194
How to incorporate cell data in a worksheet header John Bennett	by David D	1	375
How to auto hide and unhide columns using 1 and 2 icons R. Rebello	by David D	1	687
Seperate cell string into individual cells ERudy	by Biff	2	1,212
V-LookUp help Asma Shah	by JMB	3	341
Summing every third cell bthieson	by Biff	6	414
Reference to Worksheet name SKY	by Biff	3	464
Time calculations joe z	by Biff	1	443
IRR formula for monthly cash flows MB Burgis	by Fred Smith	3	2,133
Calculate Elapsed Date and Time Gary F Shelton	by Fred Smith	3	2,027
If Match Part of Text Within Cell, Then Blank SteveC	by Biff	3	3,396
Excel, how do I count cell with data within a range? BRKirk	by Chip Pearson	2	517
Unlocking "check box" control function aliceinphx	by davesexcel	1	376
Simple Circular Reference Problem Gary	by JLatham	2	411
in data/filter/auto filter sp8	by Debra Dalgleish	2	905
Modified /advance "Max function "may help!! PA	by PA	3	520
Sort Problem - Please Hurry!! walleys25	by davesexcel	1	503
Copy a Workbook Automatically Len	by David Biddulph	1	397
Returning a Value if 3 Conditions are True brownie224	by David Biddulph	5	2,007
Create my own formula? james	by JLatham	2	379
How do I input a minus time in an excel spreadsheet Nadine NZ	by Lost for time	1	1,062
sum only visible cells hommer	by JLatham	5	808
How do I make hyperlinks? johnnstacy	by Peo Sjoblom	4	287
linking to a cell within a text cell or comment BlueJ2005	by BlueJ2005	0	453
I need to know how to 'Colour Tabs' in Excel 2000 Fed Up	by Don Guillett	6	488
Converting to Absolute Cell References - en bloc Basher Bates	by Peo Sjoblom	7	453
Date Population achapman	by achapman	5	594
2nd to MAX Danny	by Danny	2	403
Copying Sum Formulas Justin Hoffmann	by Peo Sjoblom	3	423
vlookup formula Ash	by Ash	2	504
Index function using multiple values in one cell [email protected]	by Biff	2	942
How can I sum data on a row from certain named columns? Liliana	by Biff	1	446
Is this formula going to work? yrose70	by Peo Sjoblom	1	398
Excel Fed Up	by Chip Pearson	1	356
IF Statement help please Alan Davies	by Bob Phillips	1	373
Find a value and return a corresponding number Irene	by Gary''s Student	3	1,045
count number of letters in a string Wiley	by Ron Coderre	3	828
How can I count the number of times a letter repeats in a string? Wiley	by Bob Phillips	3	1,124
Saving worksheets within workbooks as individual files Colin Hayes	by Ron de Bruin	4	686
How can I use an IF statement to find out if the cell is shaded? Pascual	by JethroUK©	1	373
Gas Mileage Patsy	by Patsy	4	561
Multiple sheet acherony	by acherony	0	295
UserForm Save Issue DarnTootn	by DarnTootn	0	523
IF Statements-call private sub CrimsonPlague29	by CrimsonPlague29	0	429
How do I show numbers in Excel as 48K instead of 48000? Scotty	by Peo Sjoblom	2	492
SUM of INDEX lookups Liz Steffen	by Peo Sjoblom	3	1,237
Using sum(1/countif....) not returning expected result Kent (thanks)	by Kent (thanks)	10	1,096
sumif function DAB	by DAB	2	352
array formulas disabled? erikheath	by erikheath	1	437
fill in data range knowing start and end values Julie	by Duke Carey	1	554
vlookup vs if, help required CraigSA	by CraigSA	0	418
Forms controls Catalin	by Catalin	2	435
combine 111 in one column & .jpg in another thru out entire works Ms.Faye.	by Ron Coderre	1	387
Time between days RamOst	by Ardus Petus	7	583
Make a formula to calculate the avarage of baseball stats Confused at Work	by SteveG	2	805
pls help with IF formula Raj Shah	by Raj Shah	2	272
Autofilter and Subtotals Sandy	by Miguel Zapico	1	414
REPOST: Which Function to Use Nick	by Nick	3	486
how can I highlight a cell if it meets year and month criteria Clyde	by Barb Reinhardt	2	965
Double and Multiple Lookup Using the MATCH Function Charles793	by Charles793	0	1,067
How do you create your own auto format for a pivot table Marlyn	by Marlyn	6	955
1 cell average across multiple worksheets curtll	by Domenic	8	1,653
Pivot table drill down formatting matelot	by Marlyn	1	1,159
How do you get the function of a pivot column to not appear Marlyn	by Marlyn	0	343
Sum product of many pairs of columns KeenKiwi	by Bob Phillips	3	844
COUNT IF < "" Bruce	by Arvi Laanemets	3	312
How to be noticed/to avoid equal values in a colum Irene	by Irene	7	515
Automated summaries/conversion SpencerMC	by Ardus Petus	1	337
Cell protection & Auto Filter fastballfreddy	by Paul B	1	1,008
price higher than... Thad	by myra_deV	2	297
external data function error Ken W	by Ken W	0	477
sum the results of a group of formulas astjels	by Bob Phillips	3	1,126
Query to find last saved date/Time Dean	by Bob Phillips	2	650
Index,Match table array in separate workbook Ben	by Ardus Petus	6	1,390