Excel Worksheet Functions - Page 464

Thread / Thread Starter	Last Post	Replies	Views
Is there a way to create a list in excel with smilies instead of . CFE	by MartinW	4	356
Conditional formatting and IF Saintsman	by Bob Phillips	2	384
Degrees Minutes Seconds Greg de Bruin	by Greg de Bruin	3	495
locate data from a chart by inserting data into a cell Aaron Hodson \(Coversure\)	by Gav123	3	473
conditional format if cell value 0 pattern red value blank nothing Matt	by Pete_UK	1	1,729
How do I create a formula that continuously numbers my invoices? Revive-A-Disc	by Roger Govier[_3_]	2	552
formulas krackerjack	by Sandy Mann	5	480
Compare 2 Worksheets and return differences in a third. TheBigStig	by TheBigStig	4	1,649
Calculating a complicated formula Chris	by Chris	4	520
Vlookup problem SoCal Rick	by JMB	1	407
EXCEL:Can't open any file without error saying it's ALREADY open??? Crackles McFarly	by Dave Peterson	1	1,280
Column Comparison Trouble RH	by Robert[_5_]	2	717
Another formula problem Frances C[_2_]	by Max	6	544
Excluding Hidden Rows from calculations Terry Bennett	by Peo Sjoblom	3	2,899
Normalize time series wowfed	by Myrna Larson	2	5,944
date validation LM	by LM	8	474
Using the returned value to look up an item Frankd410	by Dana DeLouis	9	498
COUNTIF Karen	by Dave Peterson	15	1,047
Sread sheet that sorts and totals as you enter new lines Carpenter Dave	by steve_k	2	398
GETPIVOTDATA kar	by Debra Dalgleish	1	419
Indicator lights Mikelmco	by Mikelmco	2	1,658
Vlookup a text string Tim Nealon	by T. Valko	6	646
How can I dynamically change a file link in a formula? GTX	by Bernard Liengme	2	918
Need help doing complicated formula mrl	by Gary[_2_]	10	1,176
What is the formula behind the VDB function? Rubble	by Rubble	0	739
When typing dates do not default to current year. Spreadsheet Geek[_2_]	by Spreadsheet Geek[_2_]	2	1,009
Formula problem Frances C[_2_]	by Gord Dibben	3	356
Conditional Data Validation Walt Herman	by Peo Sjoblom	5	490
Linked workbooks, changing links StephanieH	by StephanieH	0	325
Macro to check data from excel list against access query and return value back to excel dreamkeeper	by dreamkeeper	0	1,102
Tab order help kfaulkner	by Gord Dibben	4	399
Forecast v actual - row addition problem Tom Sharrocks	by Tom Sharrocks	2	837
Filling a formula down-need correct cell reference NeedExcelHelp07	by NeedExcelHelp07	13	1,023
can one delete or change automatic page breaks? TJ	by Gord Dibben	1	879
locking and unlocking worksheets adam	by RL	6	737
Customizing SAP Download in Excel Shams	by Shams	0	554
COUNTIF and leading zeros? c mateland	by T. Valko	3	849
How do I switch from one worksheet to the next without using the . Switching from one Worksheet to the next	by Soundar	2	677
Conditional Formatting on a Drawing? Storm	by Storm	2	626
Can't link cells between multiple workbooks DebbieC	by DebbieC	0	955
Pivot Table Help PLEASE Diane1477	by ryguy7272	1	320
Rows to repeat at top of each page Jane	by Gord Dibben	4	2,263
If any 3 of 5 values are 0 then 0. Gary[_2_]	by ilia	8	624
'if' formula selecting a cell from a table Aaron Hodson \(Coversure\)	by Aaron Hodson \(Coversure\)	3	561
Dates Frances C[_2_]	by Gary''s Student	2	349
fill column with formula Margo	by ilia	3	763
Applying formula on formula Aditya Kumar	by ilia	6	428
working out a date for a fixed day of the week Matt Sharman	by Matt Sharman	4	577
DMAX function for Office 2007 jswiryd via OfficeKB.com	by Peo Sjoblom	1	719
add 10 days to a date starman1	by ryguy7272	5	1,579
formula Help Frances C[_2_]	by Bernard Liengme	2	514
cell function to copy contents of another cell Margo	by Max	5	1,065
Need to update a ComboBox when selecting a sheet [email protected]	by Bernie Deitrick	1	473
Auto run of macros immediately after opening the files gane	by ryguy7272	2	798
Formula Noelline	by Noelline	7	511
2 Data Validations Q Sean	by Stefi	7	574
ROundup Esradekan	by Esradekan	2	392
COUNTIF & SUBTOTAL Dickie Worton	by Lori	2	1,662
how do I change cell colour to show function used stufree	by Lori	3	510
Rounding Esradekan	by Stefi	5	429
slide between sheets Nsireen Shalaby	by Nsireen Shalaby[_2_]	2	482
Add text to cell formulas? phillr	by Bob Phillips	6	565
Rounding GinGinW73	by Bernd P	2	353
IF with Rank Gary[_2_]	by ilia	5	371
Calculating/displaying elapsed time TOTALS USAOz	by T. Valko	3	576
How do I hide a function in formula bar Sandeep	by Sandeep	0	510
commission percentages mzmalia	by Peo Sjoblom	1	580
Copy rows if greater than zero AndyB	by Max	3	1,420
sales reps pricing Esradekan	by Max	6	555
How do I create a formula using cells from two different sheets? Elaine Z	by Alan	2	1,533
if usage based on two ranges NO sum required ross	by ross	6	613
3601 Too Few parameters Expected 1 Phil Smith	by JP[_3_]	1	465
Satisfying 2 conditions and lookup from a 3rd column to return a v Raj	by Pete_UK	1	868
Count number of cells and total in one column, based on another column suffix Pierre	by Dave Peterson	5	1,616
Counting fields on criteria in other fields [email protected]	by Roger Govier[_3_]	1	614