[quote=Lexus:1259097490]
It what You wanted?
[/quote]
[quote=Red Devil:1259099580]
Lexus,
Yes that's just what I wanted
Thanks
RD
[/quote]
nice n simple formula
lexus btw is there any agile code for И так далее (иÑÐ¿Ð¾Ð»ÑŒÐ·ÑƒÑ N+N1+N2+N3+N4+…) instead adding manually N+N1+N2+N3+N4+… :finger:
=MATCH(C$1,OFFSET($B$2,(
C2+C3),0):$B$20000,0)
i think this is light weight calculation for skip but the challenge are adding manually N+N1+N2+N3+N4+…
well maybe we can use another formula, thank to Carbob who enlighten me about vertical/horizontal skip formula using an array formula
=IF(ROWS(C$2:C3)<=COUNTIF($B$2:$B$1448,C$1),SMALL(IF($B$2:$B$1448=C$1,ROW($B$2:$B$1448)-ROW(C$1)+1),ROWS(C$2:C3))-SUM(C$2:C2)-1,"")
note: after copy and paste the formula press CTRL + ALT + DEL
good luck
You do not have the required permissions to view the files attached to this post.