Hi,
I need help how best to combine the Small function with Index/match for a rolled-up summary. I have team members listed in column A with projects listed in row 1. Not every team member is on every project. I need to have an automated summary which only lists what project each team member is apart of (essentially find a way to automate the red text in excel attached).
Any help would be greatly appreciated! Thanks!
with a spill formula = with CTRL+SHIFT+Enter instead of Enter
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Thanks! What I'm hoping to get as a returned value is "Project 1" rather than the numeric value that's in the chart. That value is more so indicating that they worked on the project, but what I really want is an automated way to list the projects.
try below formula in B8, copy and paste across
=IFERROR(INDEX($1:$1,AGGREGATE(15,6,COLUMN($B$1:$E$1)/(INDEX($B$2:$E$5,MATCH($A8,$A$2:$A$5,0),)<>""),COLUMNS($B8:B8))),"")
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Try this formula as an array formula in B8 (Control + shift + enter) then drag across and down
Example attached too
Please Login or Register to view this content.
Happy with my advice? Click on the * reputation button below
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks