Hi I have table
as
A B C D F
V 1 1 0 0 1
W 2 0 2 2 2
X 1 0 2 0 0
Y 1 1 1 1 2
Z 1 1 1 2 1
Where ABCD are columns B,C,D,E,F and VWXYZ rows
I want to autimatically to return the row headers for respective occurence of 1's ,2's and 0's when i choose
so it will look like
Eg; for 2's
A W
B
C W X
D W Z
E W Y
and vice versa
V
W A C D E
X C
Y E
Z D
Thanks can anyone help me?
I have tried using if function but that only returns values only where is is equal to whatever present in first table
Bookmarks