Sunday, June 17, 2018

yogi_Unique Values From Multiple Columns Based On Values In Another Column

Google Spreadsheet   Post  #2463

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Jun-16-2018

question by: classroom in school
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/2AmNIytMxiw;context-place=forum/docs
Unique list of names from multiple columns and based on value in another column?
https://docs.google.com/spreadsheets/d/1vizdH7_Eb5E7f1aHZY6TX_P6xqdxOhqMked2us1EXFI/edit?usp=sharing

I have three columns:
A2:A6 contains letters like A or B
B2:B6 contains names
C2:C6 contains names

A name  can appear in both column B and C, like "joe" or "ivan".

How can I create a list with unique names, where the names only appear on the same row as letter B in A2:A6?