Hi,
Pls. help. I'm having problem counting unique person in a number of Columns for each row. I only know how to count unique value if it is in 1 column.
Activities JOINT1 JOINT2 JOINT3 JOINT4
WELDING 1 Allan Allan
WELDING 2 Allan Bob
WELDING 3 Bob Allan Bob
WELDING 4 David Carl
WELDING 5 Francis Francis Francis Francis
WELDING 6 Carl Ed Carl Carl
WELDING 7 Francis Francis Ed
NAME # of Welding (Formula in this column)
Allan 3
Bob 2
Carl 2
David 1
Ed 2
Francis 2
Sorry, I wanted to upload the file but I don't understand why I can't upload this time. I copied the example in this post from excel file and the values are not align properly.
Thanks
Ricky
Bookmarks