+ Register

[montis]

Hello,
I need help
I have excel formula which let for different  numbers appear in the same cell, 
=IF(OR(F7={10,10.5,11,11.512,12.5,13,13.5,14,14.5,15}),5,IF(OR(F7={15.5,16,16.5,17,17.5,18,18.5,19,19.5,20}),11,IF(OR(F7>=20.5),15,"")))

for example we have AS1 cell in which appear first number 15, then it change to 5, then it change to 15, then it change to 11 etc. What i need is to capture and lock  just the first shown number (in this ex. it has to be 15) and put it to another cell (for ex. cell AT1)
Maybe there is any formula ?
Thanks.
M.

[VLS]

Hello Montis,

Over here we're more focused in systems programming.

You are more likely to find excel sheet programming assistance at http://betforum.cc/excel-forum/

Cheers!
Vic