I have numbered by list of inquiries as E00001, E00002, E00003 and so on.. (row wise)
However, each inquiry may have more items and hence i number them as E00002a, E00002b and so on. (consecutive rows)
I my next sheet i would like to link the inquiry nos. (i.e if i enter E00002 all the rows which have E00002 including E00002a, E00002b should be listed consecutively as in the inquiry sheet.
I tried with
=INDEX(Marketing!$A$6:$A$22,MATCH('Mktg-Comm'!A19,Marketing!$A$6:$A$22,0)+1)
In the above formula all the Enquiry nos. next to E00002 is being listed.
Need a formula to break the loop once E00002 and the consecutive items pertaining to E00002 is over.
Solved by V. Y. in 23 mins