Excel Worksheet Functions - Page 1053

Thread / Thread Starter	Last Post	Replies	Views
Stock Reconciliation rajeev	by rajeev	1	2,880
Sheet Name Sheila	by Max	11	967
Excel 2003 - Find records Klaus	by Biff	7	583
LOOKUPS - Creating LOOKUPs where two different values must BOTH be satisfied. Mr Wiffy	by Charyn	2	862
The world is really unstable these days...... [email protected]	by [email protected]	0	552
Help with formulae Philip Atherton	by Max	2	418
IF/AND FORMULA Robert	by Robert	4	411
Macro problem Jonah	by Jonah	0	515
Non-signed Difference between 2 cells cherft	by cherft	6	539
Count Position of Filtered TEXT cells in a column Sam via OfficeKB.com	by Sam via OfficeKB.com	0	2,063
Computing full Months Mike M.	by Ron Rosenfeld	5	686
convert $ value to day values bo	by Ragdyer	2	568
Stop text from stringing into next field when empty NothingButRomance	by Max	2	972
vehicle fleet maintenance diggy	by Max	3	1,199
how does excel read only odd numbered rows of data froma column? Rose_mina	by Max	3	1,293
room schedule jenn	by Gilles Desjardins	1	503
Import various Worksheets Mark J	by Mark J	0	440
3 highest values indicated using formatting John	by John	7	615
How do I use 3 cells to create the string for a lookup function? Bencomo	by Biff	1	1,203
were can i find a beginners guide to pub bookeeping olive	by olive	0	444
Is there a function that will return info of the cursor location? cbre_bryork	by Biff	3	725
Automatisk nummerering (fortlÃ¸bende) petil	by Peo Sjoblom	1	1,635
round numbers to the nearest quarter? LeelooIvy	by Dave Peterson	3	1,329
Lookup Oldest date from previously selected Group Data Jim May	by Bob Phillips	8	715
Installed Analyst Toolpak but not working for files used at work? SJB567	by Gord Dibben	2	674
Deleting a file from within Excel Night Owl	by Night Owl	3	646
Convert $12.00 to text (Twelve dollars) like you would on a chec.. Dave	by Dave	2	785
How can i set up a MONTE CARLO SIMULATION macro in Excel? thx MonteUser	by Alok	4	1,307
How to pull numbers from two tables with conditions? Anna	by Alok	1	819
VLOOKUP-How do I get answers pulled from different appropriate col rOn	by Alok	2	575
formula to copy last positive number in range of cells rolan	by Tommy	6	1,336
How do I Change column labels to ABC from 123 ? Jeff	by Don Guillett	1	1,311
data validation and using hyperlink to email Anastassia	by Anastassia	0	687
calculate APR on ARM John McHugh	by Mangesh Yadav	1	943
add hours (calculated by functions) on a timesheet drewer	by Peo Sjoblom	6	854
Sum every 10th cell in a range of cells? JKJ95	by Jerry W. Lewis	9	1,117
Finding Time difference John Harris	by Dave Peterson	2	681
SUM or COUNT and adding a row Alex	by Ken Wright	2	474
Drop down menu for page references Al	by Al	8	659
How do I validate data from another validation cell? Bo	by Max	20	1,991
special characters tjh	by Ken Wright	3	884
stop excel from rounding a result Hazeldean	by Peo Sjoblom	3	906
How do I change rows content to column & vice versa Excel spread s Harinath	by Ken Wright	2	783
checkbox Chas	by Alok	2	705
Copying and Pasting between Workbooks NothingButRomance	by NothingButRomance	0	971
Can this be done...? Mudflap	by Ken Wright	1	367
CHANGE LOWER TO UPPER CASE IN EXCEL FOR WHOLE SPRDSHT Impossible One	by Ron de Bruin	1	945
Name Range with three requirements Carole O	by bj	3	451
Can you save a single sheet directly to a new file defensiveone	by Ron de Bruin	2	461
Excel Macro to insert rows in a list MartyCole	by Bob Phillips	1	698
Add images or logos to the Header in Ms- Excel Sheets Rohit Gupta	by Gord Dibben	2	844
How to deploy custome toolbar/Menu commands in Excel? Hiten	by Gord Dibben	3	792
Copying and Pasting between Workbooks NothingButRomance	by NothingButRomance	0	845
Another SUMPRODUCT array anomaly Jerry W. Lewis	by Harlan Grove	6	742
Finding min and max date of a given month Caro-Kann Defence	by Caro-Kann Defence	2	850
pulling certain data out of a cell D richardson	by D richardson	6	940
how can I remove seasonality from my data Tigger123	by Mike Middleton	1	2,373
How do I use multiple "Does not contain" function in excel? Raph_baril	by Ron de Bruin	3	3,405
Removing numbers from the beginning of a text string Night Owl	by Night Owl	3	1,383
Replacing specific characters with spaces Night Owl	by Night Owl	3	696
Suppress First Page Header Jamie	by Ron de Bruin	7	651
2 dimensional MATCH David	by Harlan Grove	8	385
Excel to create codes using the 321 system Mirsten Choiple	by Harlan Grove	5	414
HOW DO I ADD CLOCK TIMES, WHEN DIRIVED FROM A FORMULA? [email protected]	by	1	531
Can I compare 2 lists to combine duplicate entries in new list? Tinytall	by Tinytall	0	869
conditionally format cells elad	by RagDyeR	2	551
how do i find data in multiple sheets in excel Karline	by LanceB	2	990
What do I use to find the last liste information in a row? BGarcia	by RagDyeR	13	936
Allocate a value to a cell from an if statement Louis Pretorius (Johannesurg, RSA)	by JulieD	1	620
How to auto arrange the worksheet in a excel 2002 file? Balaji's	by JulieD	1	869
how do i use a formula to work a precentage of a percentage Natalie	by Tom Ogilvy	2	467
Improve autofilter combine conditionals with filter criteria dmcauli3	by dmcauli3	0	659
Refering to a tab using data from a cell dan	by dan	5	702
Lookup's for and totals Purfleet	by bj	2	411
Look up part of a date Purfleet	by Purfleet	2	407