Multiple lookups across Colums Return only values that match

[Warpug]

Im going to be very simple with my question. I have worksheet 1 with 10 columns and multiple rows on a spreadsheet. I want to have a worksheet2 in the same workbook that looks at the data on worksheet 1 and returns entire rows of data where column A, B and C contain original data. (by original data I mean I don't want duplicates where the combined data is the same)

 

[oldbrewer]

you could use a helper column that tests if A,B,C are unique, sort by the helper column then pull results into your second sheet only if say the helper is 1 otherwise pull blanks

 

[Warpug]

you could use a helper column that tests if A,B,C are unique, sort by the helper column then pull results into your second sheet only if say the helper is 1 otherwise pull blanks

Im not quite sure what a "helper column" is. But can this helper column be used to advise whether (A,B,C) as a unit are unique, or will it only advise if each is unique in a column? Thank you for responding to my original post btw

 

[Aladin Akyurek]

Try to post a small sample as input along with the output you want to construct from that sample.

 

[oldbrewer]

a helper column is an extra column that can be located well to the right of your data. My suggestion is a helper to test if A,B and C are all different, if they are return 1 if not return a blank. Then sort by the helper and all your desired rows will be in one block.