Hello
In the light yellow cells by formula need to plot the next immediate lower level number `Set Text'.
thanks in advance
Hello
In the light yellow cells by formula need to plot the next immediate lower level number `Set Text'.
thanks in advance
Sekar
This works on your example data
=INDEX(C$1:C3,MAX(IF((A3-1=A$2:A3)*(LEN(A$2:A3)>0),ROW(A$2:A3))),1)
Depends what the rest of your data looks like, but this works.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Hello
Thanks for the formula, But the formula shows error and i have attached the attachment.
You've entered the formula in D2, but that row doesnt need a formula since subtracting 1 from A2 (which is 0) will result in -1 and there is no -1 to find in column A.
Perhaps I should have said what cell to enter it in.
Enter the formula in D3
=INDEX(C$1:C3,MAX(IF((A3-1=A$2:A3)*(LEN(A$2:A3)>0),ROW(A$2:A3))),1)
Also this is an array formula
Array formula, use Ctrl-Shift-Enter
and copy down the column.
d2=IFERROR(LOOKUP(A2-1,A$1:A1,C$1:C1),"")
Try this and copy towards down
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Hello
Special-K and Samba Thanks to both of you
Both of your formulas working well, thank you again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks