FORMULA BREAKDOWN?

[msimone]

Is there anyone out there who can break this formula down for me and tell me what it's doing?

Huge thanks in advance!!


=INDEX(A1:S25,MIN(IF(MOD(ROW(A1:S25)-ROW(A1),5)=0,IF(A1:S25=U1,ROW(A1:S25)-ROW(A1)+1)))+4,MATCH(U1,INDEX(A1:S25,MIN(IF(MOD(ROW(A1:S25)-ROW(A1),5)=0,IF(A1:S25=U1,ROW(A1:S25)-ROW(A1)+1))),0),0))

 

[VoG]

This is a duplicate - you should stick to your original http://www.mrexcel.com/board2/viewtopic.php?t=235832