Multiple Return in Array

R

rohankekatpure1987

New Member
Joined
Oct 28, 2015
Messages
34
Hi,

I've the following columns :


[TABLE="width: 722"]
<tbody>[TR]
[TD="align: center"]Segment 1[/TD]
[TD="align: center"]Segment 2[/TD]
[TD="align: center"]Segment 3[/TD]
[TD="align: center"]Segment 4[/TD]
[TD="align: center"]Segment 5[/TD]
[TD="align: center"]Segment 6[/TD]
[TD="align: center"]Segment 7[/TD]
[/TR]
[TR]
[TD="align: center"]X[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD="align: center"]X[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]Y[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]Y[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]Z[/TD]
[/TR]
</tbody>[/TABLE]

Segment 1.....7 are different columns. We have 5 different rows. Each row will have either a value: X,Y,Z or FALSE. I want to find out what value(X or Y or Z) is present in each row.

Expected Output:
[TABLE="width: 818"]
<tbody>[TR]
[TD="align: center"]Segment 1[/TD]
[TD="align: center"]Segment 2[/TD]
[TD="align: center"]Segment 3[/TD]
[TD="align: center"]Segment 4[/TD]
[TD="align: center"]Segment 5[/TD]
[TD="align: center"]Segment 6[/TD]
[TD="align: center"]Segment 7[/TD]
[TD="align: center"]Result [/TD]
[/TR]
[TR]
[TD="align: center"]X[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]X[/TD]
[/TR]
[TR]
[TD="align: center"]X[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]X[/TD]
[/TR]
[TR]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]Y[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]Y[/TD]
[/TR]
[TR]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]Y[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]Y[/TD]
[/TR]
[TR]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]Z[/TD]
[TD="align: center"]Z[/TD]
[/TR]
</tbody>[/TABLE]

Tried using Index Match but it is not good as can't work with multiple match statements. Can anyone help on how to use multiple Match or by solving this by any other function?
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
Sort by date Sort by votes
If those FALSE values are Boolean FALSE values and not text, then try

=LOOKUP("Z",A2:G2)
 
Upvote 0
You must log in or register to reply here.

Similar threads

L
  • Question Question
Prevent Pagebreak from hidden columns and rows, combine visible columns to one page wide
Replies
1
Views
228
bobsan42
bobsan42
M
  • Solved
XLOOKUP help (maybe), not sure what function to use
Replies
4
Views
230
MeaclH
M
M
  • Solved
run formula based on cell value to the last row
Replies
5
Views
310
MMM_84
M
M
  • Question Question
VLOOKUP?
Replies
1
Views
179
MeaclH
M
I
  • Question Question
Advice to remove old code for a new code
Replies
2
Views
191
ipbr21054
I

Forum statistics

Threads
1,223,104
Messages
6,170,126
Members
452,303
Latest member
c4cstore

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top