cell addition and moving questions

[Harold]

Hi,
I have two questions today,
1. I want to use the exell version of the following line

if a2>199 then let b2=(b2+1) i know thats a basic programming line bu
its the best way I could think of it

the second question is harder, I want to take data (using the larg
formula which is no problem out of 'e' colum and sort it into
presentation sheet as a top ten, this is easy but I want the name t
come with it

Eg peter 245
joe 210
mike 156
fred 235

to convert to on a seperate worksheet (no problem there) the numerica
list. I can move the number (again using the large thats easy) but
want the names to automatically cross with it

see attached


Thankyou

Paul Dal

Attachment filename: helpme.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=55990

 

[Frank Kabel]

Hi
1. not sure what you're trying to do. You can't have a value AND a
formula in one single cell (e.g. cell B2)

2.: see: http://www.cpearson.com/excel/rank.htm

 

[Harold]

Hi,
sorry I just read my last post, it didn't make a lot of sense even
to me.

I have a lot of data on a sheet, names games scores nightly scores etc
etc etc and I want to have another sheet as a report sheet. On that
sheet I want to extract data like the top and bottom five scores,
series, handicap scores etc. this I can do.

The problem lies in that I cannot get the corresponding names to come
over to the report sheet as well rather than having to go thru and
"fish thru tons of data" to find the name to match the number

ie on the report sheet I want to see Peter 555, I can get the 555 but I
cannot get the peter to come with it. however it wont always be peter
it could be 1 of about 60 names and thats one hell of an if statement.

The other thing I want to do is count the times that the 200 barrier is
broken by a particular bowler, however this data is coming of a sheet
that will be cleared each week so I am sort of after a "month to date"
sort of thing in the basic programmng language
if a2>200 then let b2=b2+1
ie if peter has already bowled 10 200+ games and bowls 2 more in the
following week I want the "counting square" to increase by 2.
remember the data from where you are getting the extra 2 from wont be
there next week it will have the following weeks data.

Hope this helps.

Paul Dale

 

[Harold]

sorry man I just saw the link at the bottom of your reply that has th
name problem beaten. however the summing total in a season to dat
fashion I cannot find


Thankyou for your help

Paul Dal

 

[Frank Kabel]

Hi
have a look at the VLOOKUP function for this. See:
http://www.mvps.org/dmcritchie/excel/vlookup.htm