Copy from one sheet to another baed on an IF AND OR

swingline

New Member
Joined
Oct 29, 2019
Messages
11
I'm not sure if what I'm asking is possible to accomplish with excel. But what I would like to do is on sheet one copy list names that meet specific criteria based on IF AND OR of contents of columns next to their names.

NameYNMYES
jim11y
jeff1y
bill1n
sam1y
doug1y

<tbody>
</tbody>

So the idea is that the columns to the right of the names are in order of priority between Y, N, M values from the name column would be copied onto another sheet, and if the YES column has an "n" that row can be ignored. Below would be the expected results, the name list is dynamic, but the columns and their order of priority are static.


ynm
jimsamdoug
jeff

<tbody>
</tbody>
 

Special-K99

Well-known Member
Joined
Nov 7, 2006
Messages
8,301
You dont want jim appearing in column m before doug even though he has 1 in column M and a y in Yes?

Shame, otherwise this would work.

With jim in A2
in F2
=IFERROR(INDEX($A$2:$A$6,AGGREGATE(15,6,ROW($A$2:$A$6)/((B$2:B$6=1)*($E$2:$E$6="y")),ROWS(A$2:A2))-(2-1),1),"")
copy down and across to H6

Only difference from your output is in the m column jim appears before doug
 
Last edited:

Forum statistics

Threads
1,077,855
Messages
5,336,782
Members
399,102
Latest member
chudson1

Some videos you may like

This Week's Hot Topics

Top