G2=IFERROR(ROW()*(1^MATCH(E2,I:I,)),"/")
then you could direct sort all row by column G (all rows with number in column G is your "service area")
or
you could also use row# in column G to extract all columns in service area only.
G2=IFERROR(ROW()*(1^MATCH(E2,I:I,)),"/")
then you could direct sort all row by column G (all rows with number in column G is your "service area")
or
you could also use row# in column G to extract all columns in service area only.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks