Tricia Violeta
New Member
- Joined
- Aug 2, 2017
- Messages
- 8
The desired outcome is in the picture. Your help will be really appreciated.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Finding match (multiple occurrence) in table and returning column header titles. (Thank you for helping in advance)
- Thread starter Tricia Violeta
- Start date
jarjarbingie
Well-known Member
- Joined
- Nov 15, 2012
- Messages
- 607
The desired outcome is in the picture. Your help will be really appreciated.
D24 = IFERROR(SMALL(IF($C$13:$H$17=$C24,$C$12:$H$12,""),COLUMN()-COLUMN($C24)),"") press CTRL+SHIFT+ENTER
Upvote
0
Tricia Violeta
New Member
- Joined
- Aug 2, 2017
- Messages
- 8
jarjarbingie
Thank you so much. I really really appreciate it, you don't know how much time i have saved because of this formula. Thank you so much , hope you could help me with my new problem. :D
Thank you so much. I really really appreciate it, you don't know how much time i have saved because of this formula. Thank you so much , hope you could help me with my new problem. :D
Upvote
0
Similar threads
- Solved
- Solved
