Hi There,
Can anyone help me with the following scenario:
I have 2 sheets. In sheet 1, i have following data:
A1 A2 A3
A X S
M F T
C D F
N C D
Y A
Z
Where A1, A2, A3 are column headers and A to Z are the column headers in sheet 2.
In sheet 2, i have some calculations performed in sheet 2 based on the user entered data in sheet 1. I would like to select the unique values identified from user entered data in sheet 1 and hide those columns in sheet 2.
Please find the attached sample spreadsheet that has example data to help understand my task above.
Any help will be greatly appreciated.
Thanks,
kon.
Bookmarks