Return column headers from a 2D array

[mas_uqon]

Dear All.
Good days,

I have a question as picture below :
Sample.PNG

What if I want to know the unique number in row number Two (2) based on the unique number in column B, there's any suggestion?

Thank you.

[Junaid Azhar]

Use the formula in cell B11 with Ctrl+Shift+Enter and drag it forward
=IFERROR(INDEX($B$1:$M$1,0,SMALL(IF(INDEX($B$2:$M$8,MATCH($A$11,$A$2:$A$8,0),0)<>"",COLUMN($B$1:$M$1)-1),COLUMNS($B$11:B11))),"")

See the attached sample file.

[Glenn Kennedy]

Or:

=FILTER(B1:H1,FILTER(B2:H6,A2:A6=A9)=1)

[Glenn Kennedy]

mas uqon.

Hi. Forum Rule 1 is very short. It states: "Title must briefly summarize your request."

A GOOD thread title is the sort of thing you would use as a search term on Google*. Your chosen title would produce a squillion useless hits. In future, please take a bit more time to think of a descriptive title that would be "Google-friendly". Many people search the forum answers looking for help and your very general title wouldn't help them at all.

Since you are a new or very infrequent user of this site, on this occasion, I have changed it for you.

However, if you continue to use weak titles, you can expect to have your thread BLOCKED until you change it yourself. If that happens, to edit the thread title, open the original post, click "Edit Post" (bottom right) to access the area where you can edit your title.

To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

*Other search engines are available!!!



Regards,

Glenn.

[mas_uqon]

Dear Junaid Azhar,
thank you for your answer, it's work.

Dear Glenn,
Thanks for the answers and suggestions too.
I just don't know how to solve this case, next time I will check with other search engines first.
Thank you.

[Glenn Kennedy]

You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.