Excel Worksheet Functions - Page 1053

Thread / Thread Starter	Last Post	Replies	Views
Stock Reconciliation rajeev	by rajeev	1	2,853
Sheet Name Sheila	by Max	11	929
Excel 2003 - Find records Klaus	by Biff	7	564
LOOKUPS - Creating LOOKUPs where two different values must BOTH be satisfied. Mr Wiffy	by Charyn	2	822
The world is really unstable these days...... [email protected]	by [email protected]	0	522
Help with formulae Philip Atherton	by Max	2	391
IF/AND FORMULA Robert	by Robert	4	396
Macro problem Jonah	by Jonah	0	493
Non-signed Difference between 2 cells cherft	by cherft	6	523
Count Position of Filtered TEXT cells in a column Sam via OfficeKB.com	by Sam via OfficeKB.com	0	1,890
Computing full Months Mike M.	by Ron Rosenfeld	5	674
convert $ value to day values bo	by Ragdyer	2	528
Stop text from stringing into next field when empty NothingButRomance	by Max	2	924
vehicle fleet maintenance diggy	by Max	3	1,172
how does excel read only odd numbered rows of data froma column? Rose_mina	by Max	3	1,232
room schedule jenn	by Gilles Desjardins	1	477
Import various Worksheets Mark J	by Mark J	0	429
3 highest values indicated using formatting John	by John	7	578
How do I use 3 cells to create the string for a lookup function? Bencomo	by Biff	1	1,150
were can i find a beginners guide to pub bookeeping olive	by olive	0	419
Is there a function that will return info of the cursor location? cbre_bryork	by Biff	3	698
Automatisk nummerering (fortlÃ¸bende) petil	by Peo Sjoblom	1	1,617
round numbers to the nearest quarter? LeelooIvy	by Dave Peterson	3	1,260
Lookup Oldest date from previously selected Group Data Jim May	by Bob Phillips	8	684
Installed Analyst Toolpak but not working for files used at work? SJB567	by Gord Dibben	2	625
Deleting a file from within Excel Night Owl	by Night Owl	3	606
Convert $12.00 to text (Twelve dollars) like you would on a chec.. Dave	by Dave	2	762
How can i set up a MONTE CARLO SIMULATION macro in Excel? thx MonteUser	by Alok	4	1,275
How to pull numbers from two tables with conditions? Anna	by Alok	1	748
VLOOKUP-How do I get answers pulled from different appropriate col rOn	by Alok	2	540
formula to copy last positive number in range of cells rolan	by Tommy	6	1,280
How do I Change column labels to ABC from 123 ? Jeff	by Don Guillett	1	1,264
data validation and using hyperlink to email Anastassia	by Anastassia	0	655
calculate APR on ARM John McHugh	by Mangesh Yadav	1	925
add hours (calculated by functions) on a timesheet drewer	by Peo Sjoblom	6	829
Sum every 10th cell in a range of cells? JKJ95	by Jerry W. Lewis	9	1,097
Finding Time difference John Harris	by Dave Peterson	2	655
SUM or COUNT and adding a row Alex	by Ken Wright	2	449
Drop down menu for page references Al	by Al	8	640
How do I validate data from another validation cell? Bo	by Max	20	1,944
special characters tjh	by Ken Wright	3	855
stop excel from rounding a result Hazeldean	by Peo Sjoblom	3	856
How do I change rows content to column & vice versa Excel spread s Harinath	by Ken Wright	2	744
checkbox Chas	by Alok	2	665
Copying and Pasting between Workbooks NothingButRomance	by NothingButRomance	0	897
Can this be done...? Mudflap	by Ken Wright	1	358
CHANGE LOWER TO UPPER CASE IN EXCEL FOR WHOLE SPRDSHT Impossible One	by Ron de Bruin	1	914
Name Range with three requirements Carole O	by bj	3	430
Can you save a single sheet directly to a new file defensiveone	by Ron de Bruin	2	430
Excel Macro to insert rows in a list MartyCole	by Bob Phillips	1	663
Add images or logos to the Header in Ms- Excel Sheets Rohit Gupta	by Gord Dibben	2	795
How to deploy custome toolbar/Menu commands in Excel? Hiten	by Gord Dibben	3	702
Copying and Pasting between Workbooks NothingButRomance	by NothingButRomance	0	798
Another SUMPRODUCT array anomaly Jerry W. Lewis	by Harlan Grove	6	718
Finding min and max date of a given month Caro-Kann Defence	by Caro-Kann Defence	2	820
pulling certain data out of a cell D richardson	by D richardson	6	914
how can I remove seasonality from my data Tigger123	by Mike Middleton	1	2,341
How do I use multiple "Does not contain" function in excel? Raph_baril	by Ron de Bruin	3	3,376
Removing numbers from the beginning of a text string Night Owl	by Night Owl	3	1,351
Replacing specific characters with spaces Night Owl	by Night Owl	3	661
Suppress First Page Header Jamie	by Ron de Bruin	7	626
2 dimensional MATCH David	by Harlan Grove	8	374
Excel to create codes using the 321 system Mirsten Choiple	by Harlan Grove	5	400
HOW DO I ADD CLOCK TIMES, WHEN DIRIVED FROM A FORMULA? [email protected]	by	1	513
Can I compare 2 lists to combine duplicate entries in new list? Tinytall	by Tinytall	0	808
conditionally format cells elad	by RagDyeR	2	527
how do i find data in multiple sheets in excel Karline	by LanceB	2	952
What do I use to find the last liste information in a row? BGarcia	by RagDyeR	13	911
Allocate a value to a cell from an if statement Louis Pretorius (Johannesurg, RSA)	by JulieD	1	585
How to auto arrange the worksheet in a excel 2002 file? Balaji's	by JulieD	1	831
how do i use a formula to work a precentage of a percentage Natalie	by Tom Ogilvy	2	451
Improve autofilter combine conditionals with filter criteria dmcauli3	by dmcauli3	0	623
Refering to a tab using data from a cell dan	by dan	5	664
Lookup's for and totals Purfleet	by bj	2	397
Look up part of a date Purfleet	by Purfleet	2	379