HELP ME PLEASE
Please help me to
11010
11011
11014
21020
21022
251010
101011
I want to get a result which will give roman i, ii,iii,iv etc if the diffence of succesive row is <10 and 2nd digit from right is same in two succesive cell.
Result Should be
1
i
ii
2
i
3
4
HELP ME PLEASE
Your request is clear. However, example of your result does not comply to your data above.
If I understood you correctly, in first instance you want:
11010
11011
- difference of successive rows is <10 (it is 1)
- 2nd digit from right for both is same (1)
- you want result (difference) in roman,
- otherwise, you want 2nd digit from right in arabic
If you want something different please specify:
Try this (11011 is in cell A3):
=IF(AND((ABS(A3-A2)<10);MID(A3;LEN(A3)-1;1)=MID(A2;LEN(A2)-1;1))=TRUE;ROMAN(ABS(A3-A2));MID(A3;LEN(A3)-1;1))