MS excel question [Closed]

Report
-
Posts
2774
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
July 13, 2021
-
Hello,
I am having a name list in column A and category list in column D and I want to list names of same category in column G in another worksheet. Example
.Worksheet1. .Worksheet2.[Result I want]
Col. A Col. D Col.G{here I want only category 1}
a 1 a
b 2 d
c 3 g...and so on
d 1
e 2
f 3
g 1
h 2
i 3

Plz help.

1 reply

Posts
2774
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
July 13, 2021
465
Hi Shyam,

Could this be a solution?:
Filter data in sheet 1 on column D on the value 1. Then copy the results from column A to sheet 2 column G.

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!