Subscribe
My Query is:-
I have Raw Data in ws1, now I want to extract some required data without using pivot table & VBA in ws2
Data in ws1
Brand (InCell A1) Product (In Cell B1)
a 1
b 2
c 3
a 4
b 5
Now in ws2, I want to know the name of product (in different cells) we under Brand Name
a
b
Data Extraction from Worksheet1 (ws1) for Worksheet2 (ws2)
(5 posts) (4 voices)-
Posted 4 months ago #
-
Good day nishant859@yahoo.co.in
I think you may wish to shorten your ID name as it runs in to the question box and members will find it some what irritating.
Posted 4 months ago # -
Hi
Assuming your data is in A1:B6 including your column headers. In D1 = a & E1 = b.
Then in A2:
=IFERROR(INDEX($B$1:$B$6,SMALL(IF($A$1:$A$6=D$1,ROW($A$1:$A$6)-ROW($A$1)+1,""),ROW(A1))),"") This is an array formula: CTRL + SHIFT + ENTERCopy across to B2 and down.
Posted 4 months ago #
Reply
You must log in to post.
Welcome to Chandoo.org. New here?
Thank you so much for visiting us & taking first step to become awesome in Excel. Please use below links to navigate our site.
