Excel Tables and Referencing Cells - Microsoft Community

i not know if possible, helpful if is. have table in excel looks this.

now when click on options under column 1 , choose "example 1", shows me option in column 2 on same row "example 1".

now if add "example 1" same row "green" , "blue" both colors appear when choose "example 1" column 1

however, looks bunched , lots of pointless information when working large table many more columns, rows, , data entries. makes table bunch of junk. question this:

is there way refer "green" , "blue" cells "example 1" cell without having put "example 1" in each row data entries refer are? in other words, when go pick "example 1" column 1, gives me "red", "green", , "blue" data entries it. tried searching answers on different forums, did not know how word issue @ all. make table cleaner, still allow people search instances , cells designated particular data entry in column. 

heya drew,

sorry, no. without having related records in a3:a4, records in column b become orphans. need have associated data in order make them whole.

but can use conditional formatting hide additional instances changing font color match background. since you're in table alternating rows, you'll need 2 conditions. these seem work ok:

=and(a2=a1,mod(row(),2)=0)

=and(a2=a1,mod(row(),2)=1)

just format font accordingly.

Office / Excel / Windows 10 / Office 365 for business