Lookup the Odd One Out
 

I have three headings

Heading 1 Heading 2 Heading 3

In some other columns i have for example

Heading 2 Heading 3
Heading 1 Heading 3
Heading 3 Heading 2

In the third column i want the third heading that is not already displayed
to be displayed. So this is the outcome

Heading 1
Heading 2
Heading 1

Any help would be great

Lookup the Odd One Out
 

Assuming your 3 headings are in Sheet1 cells A1:C1 and your other columns
with 2 out of 3 headings start in Sheet2 A1:B1, one suggestion you could try:

=INDEX(Sheet1!A$1:C$1,MATCH(TRUE,ISNA(MATCH(Sheet1 !A$1:C$1,A1:B1,0)),0))

array entered with Ctrl+Shift+Enter, then copy down.



"KimC" wrote:

I have three headings

Heading 1 Heading 2 Heading 3

In some other columns i have for example

Heading 2 Heading 3
Heading 1 Heading 3
Heading 3 Heading 2

In the third column i want the third heading that is not already displayed
to be displayed. So this is the outcome

Heading 1
Heading 2
Heading 1

Any help would be great

Lookup the Odd One Out
 

Thankyou, that worked great!

"JMB" wrote:

Assuming your 3 headings are in Sheet1 cells A1:C1 and your other columns
with 2 out of 3 headings start in Sheet2 A1:B1, one suggestion you could try:

=INDEX(Sheet1!A$1:C$1,MATCH(TRUE,ISNA(MATCH(Sheet1 !A$1:C$1,A1:B1,0)),0))

array entered with Ctrl+Shift+Enter, then copy down.



"KimC" wrote:

I have three headings

Heading 1 Heading 2 Heading 3

In some other columns i have for example

Heading 2 Heading 3
Heading 1 Heading 3
Heading 3 Heading 2

In the third column i want the third heading that is not already displayed
to be displayed. So this is the outcome

Heading 1
Heading 2
Heading 1

Any help would be great