Only show rows that match tab name until a new row value

**Rafael1024** · 09-26-2022, 12:26 PM

Excel File included.

I have put together a same excel file of what i am hoping to achieve. Essentially, I only want to populate rows that match the tab name and be able to return the value in the next column over. I have tried using some vlookups, match, if statement that try to say " if this cell in column A matches the tab name, then show the values in column B until a new value in column A (which now matches another tab) no longer matches the (original) tab name. Hopefully the included spreadsheet can show what i am trying to achieve.

**dosydos** · 09-26-2022, 12:46 PM

for this to work i needed your data in zone group to have a zone group for every zone.
To accomplish this easily I selected the data in A3:A23 on the DATA tab. then i went to the home ribbon and under Find and Select i chose "Go to Special".
Then i select "Blanks: and then hit ok.
Now i press =
Then i press the up arrow on the keyboard.
Theni use CTRL and Enter at the same time. This should copy the zone groups donw correctly.
Finally i select all of column A and copy and paste as values so that there are no longer formulas.

as for the individual tabs , in A2 on every tab i used the following formula:

Formula:

Please Login or Register  to view this content.

**Rafael1024** · 09-26-2022, 01:11 PM

for some reason the formulas turn to n/a when i enable editing. i also posted a new thread of how i meant to include the spreadsheet.

**Rafael1024** · 09-26-2022, 01:18 PM

I included an updated file of the spreadsheet.

**oeldere** · 09-26-2022, 01:30 PM

Sheet Nord
a1 = Nord

A2 =IF((ROW()-1)<=COUNTIF(Data!$A$1:$A$22,$A$1),INDEX(Data!$A$1:$B$22,MATCH($A$1,Data!$A$1:$A$22,0)+ROW()-2,2),"") and drag down.

Same for the other sheets.

Edit:

Please also reply on your other questions or mark the question solved.

See the attached file.

**Rafael1024** · 09-26-2022, 03:07 PM

Thank you, that worked.

**oeldere** · 09-26-2022, 05:08 PM

Glad I could help.

If you are satisfied with the solution, please mark the question solved.

You can add reputation by clicking on the star * add reputation , to all members who helped you.

Only show rows that match tab name until a new row value

LinkBack

Thread Tools

Rate This Thread

Display

Only show rows that match tab name until a new row value

Re: Only show rows that match tab name until a new row value

Re: Only show rows that match tab name until a new row value

Re: Only show rows that match tab name until a new row value

Re: Only show rows that match tab name until a new row value

Re: Only show rows that match tab name until a new row value

Re: Only show rows that match tab name until a new row value

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Can't show different images on different rows that match cell contents

[SOLVED] Have excel show word match instead of partial match

[SOLVED] Index match show all matches from list (only showing the first match...)

[SOLVED] Rows containing information that doesn't match vs rows that match. How to sort them out?

Beginner needs help macro to only show rows of a spreadsheet that match list from another

Index Match: Show blank instead of #NA for no match

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions