extended formulas
A report of what?
Can you send sample spreadsheet plus clear explanation of what is required to:
toppers at REMOVETHISjohntopley.fsnet.co.uk
"izzyt1972" wrote:
B C D E F G
H I J
| 01-Apr | 415426 | Thom | TOM4140 | G-THOF | 733 | 10:00 | 10:55 | 10:10 |
The above is a sample of the data in one of my rows . I need to run a
report based on date (B) or Catagory (D) or Reg (F) or a combination of the
3. This sheet has 1 month on a sheet. I have managed most other things, but
I am stuck on this.
Thanks. Iain
"Toppers" wrote:
Create a table with the values in (for example) Sheet2 columns A & B
A B
733 1
738 2
752 3
etc
in D1 put:
=VLOOKUP(D10,Sheet2!$A$1:$B$20,2,0)
Not sure about your copy/paste requirement - what data?
"izzyt1972" wrote:
I am trying to get a formula that will display a number between 1 and 20,
depending on the contents of a cell. for example I have in "D1" the
following formula =if(d10=733,1,if(d10=738,2,if(d10=752,3........... .) etc
etc. It only goes up to 8 and I run into an error. How do I write my
formula in a cell on a "calculations" worksheet? Also, how can I put this in
a Macro, to copy and paste the data elsewhere on a seperate worksheet?
Any help would be really appreciated. I am stuck.
|