Hi all.
I have two columns in which specific names of items exist. I need to be able to show as a table the amount of rows between where the specific name exists.
The Data columns and Specific item lists are dynamic and can be of any length.
I've attached an example of what I'm trying to achieve.
Many thanks in advance
Frankie
Try this, copied down:Formula:
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Try.
In H3 copied up to O24
Formula:Please Login or Register to view this content.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks