Excel Worksheet Functions - Page 1053

Thread / Thread Starter	Last Post	Replies	Views
Stock Reconciliation rajeev	by rajeev	1	2,876
Sheet Name Sheila	by Max	11	958
Excel 2003 - Find records Klaus	by Biff	7	572
LOOKUPS - Creating LOOKUPs where two different values must BOTH be satisfied. Mr Wiffy	by Charyn	2	848
The world is really unstable these days...... [email protected]	by [email protected]	0	548
Help with formulae Philip Atherton	by Max	2	416
IF/AND FORMULA Robert	by Robert	4	407
Macro problem Jonah	by Jonah	0	513
Non-signed Difference between 2 cells cherft	by cherft	6	535
Count Position of Filtered TEXT cells in a column Sam via OfficeKB.com	by Sam via OfficeKB.com	0	1,944
Computing full Months Mike M.	by Ron Rosenfeld	5	684
convert $ value to day values bo	by Ragdyer	2	558
Stop text from stringing into next field when empty NothingButRomance	by Max	2	947
vehicle fleet maintenance diggy	by Max	3	1,194
how does excel read only odd numbered rows of data froma column? Rose_mina	by Max	3	1,287
room schedule jenn	by Gilles Desjardins	1	492
Import various Worksheets Mark J	by Mark J	0	437
3 highest values indicated using formatting John	by John	7	605
How do I use 3 cells to create the string for a lookup function? Bencomo	by Biff	1	1,181
were can i find a beginners guide to pub bookeeping olive	by olive	0	443
Is there a function that will return info of the cursor location? cbre_bryork	by Biff	3	712
Automatisk nummerering (fortlÃ¸bende) petil	by Peo Sjoblom	1	1,629
round numbers to the nearest quarter? LeelooIvy	by Dave Peterson	3	1,312
Lookup Oldest date from previously selected Group Data Jim May	by Bob Phillips	8	706
Installed Analyst Toolpak but not working for files used at work? SJB567	by Gord Dibben	2	664
Deleting a file from within Excel Night Owl	by Night Owl	3	633
Convert $12.00 to text (Twelve dollars) like you would on a chec.. Dave	by Dave	2	778
How can i set up a MONTE CARLO SIMULATION macro in Excel? thx MonteUser	by Alok	4	1,296
How to pull numbers from two tables with conditions? Anna	by Alok	1	804
VLOOKUP-How do I get answers pulled from different appropriate col rOn	by Alok	2	562
formula to copy last positive number in range of cells rolan	by Tommy	6	1,318
How do I Change column labels to ABC from 123 ? Jeff	by Don Guillett	1	1,301
data validation and using hyperlink to email Anastassia	by Anastassia	0	675
calculate APR on ARM John McHugh	by Mangesh Yadav	1	938
add hours (calculated by functions) on a timesheet drewer	by Peo Sjoblom	6	844
Sum every 10th cell in a range of cells? JKJ95	by Jerry W. Lewis	9	1,114
Finding Time difference John Harris	by Dave Peterson	2	672
SUM or COUNT and adding a row Alex	by Ken Wright	2	460
Drop down menu for page references Al	by Al	8	650
How do I validate data from another validation cell? Bo	by Max	20	1,977
special characters tjh	by Ken Wright	3	880
stop excel from rounding a result Hazeldean	by Peo Sjoblom	3	874
How do I change rows content to column & vice versa Excel spread s Harinath	by Ken Wright	2	769
checkbox Chas	by Alok	2	692
Copying and Pasting between Workbooks NothingButRomance	by NothingButRomance	0	961
Can this be done...? Mudflap	by Ken Wright	1	365
CHANGE LOWER TO UPPER CASE IN EXCEL FOR WHOLE SPRDSHT Impossible One	by Ron de Bruin	1	940
Name Range with three requirements Carole O	by bj	3	436
Can you save a single sheet directly to a new file defensiveone	by Ron de Bruin	2	449
Excel Macro to insert rows in a list MartyCole	by Bob Phillips	1	680
Add images or logos to the Header in Ms- Excel Sheets Rohit Gupta	by Gord Dibben	2	817
How to deploy custome toolbar/Menu commands in Excel? Hiten	by Gord Dibben	3	779
Copying and Pasting between Workbooks NothingButRomance	by NothingButRomance	0	839
Another SUMPRODUCT array anomaly Jerry W. Lewis	by Harlan Grove	6	738
Finding min and max date of a given month Caro-Kann Defence	by Caro-Kann Defence	2	839
pulling certain data out of a cell D richardson	by D richardson	6	931
how can I remove seasonality from my data Tigger123	by Mike Middleton	1	2,368
How do I use multiple "Does not contain" function in excel? Raph_baril	by Ron de Bruin	3	3,392
Removing numbers from the beginning of a text string Night Owl	by Night Owl	3	1,377
Replacing specific characters with spaces Night Owl	by Night Owl	3	683
Suppress First Page Header Jamie	by Ron de Bruin	7	645
2 dimensional MATCH David	by Harlan Grove	8	384
Excel to create codes using the 321 system Mirsten Choiple	by Harlan Grove	5	407
HOW DO I ADD CLOCK TIMES, WHEN DIRIVED FROM A FORMULA? [email protected]	by	1	529
Can I compare 2 lists to combine duplicate entries in new list? Tinytall	by Tinytall	0	849
conditionally format cells elad	by RagDyeR	2	541
how do i find data in multiple sheets in excel Karline	by LanceB	2	979
What do I use to find the last liste information in a row? BGarcia	by RagDyeR	13	929
Allocate a value to a cell from an if statement Louis Pretorius (Johannesurg, RSA)	by JulieD	1	609
How to auto arrange the worksheet in a excel 2002 file? Balaji's	by JulieD	1	859
how do i use a formula to work a precentage of a percentage Natalie	by Tom Ogilvy	2	466
Improve autofilter combine conditionals with filter criteria dmcauli3	by dmcauli3	0	653
Refering to a tab using data from a cell dan	by dan	5	685
Lookup's for and totals Purfleet	by bj	2	405
Look up part of a date Purfleet	by Purfleet	2	396