Formula to look up value for most(1) and least(3) while ignoring middle (2) from Survey?

[MarkM119]

Sorry if this has been posted but I wouldn't even know how to search for it. Right now, I am going through survey data where each of five questions has three options. Users were asked to rate each option their Most, Least and Middle important factors in their decision-making process.

I now need to somehow recall only the 1s (most) and 3s (least) by respondent ID while ignoring the 2s. So, as an example, if each option is ABC and the respondent answered 3 1 2, I need to get it to appear on another sheet as Most: B Least: A.

Does anyone have any idea how I can accomplish this? I've attached an example of what I'm working with and the type of table I'd like to put it into to. I'm not much of an excel person so I'm totally stumped. Any help is greatly appreciated. Thanks!

[Cutter]

See if this is what you want. I used the MATCH function within a CHOOSE() function. And I assumed the ID numbers were in the same order on both sheets. If not then the column A values could link directly to the other sheet.

[MarkM119]

See if this is what you want. I used the MATCH function within a CHOOSE() function. And I assumed the ID numbers were in the same order on both sheets. If not then the column A values could link directly to the other sheet.

Yes, thank you so much. You are awesome!

[Cutter]

You're welcome. Please remember to mark your thread as SOLVED (instructions are in rule#9 - click Forum Rules @ top of page to view).