Dear Experts,
Can you let me know how i can extract specific information from Data in one sheet using criteria from only one column and to transfer it to another sheet? For example:
Sheet 1:
1 2 3 4
A a b c x
B c a b z
C b a c z
D c c c x
Sheet 2: I want for all x from the 4th column to get only the information in the 1st and the 3th column:
a c x
c c x
Thank You!!!
Bookmarks