Hi,
I have current problem which I am facing.I have a Summary Sheet in which I have to do analysis work.What I want is that I want to get unique data (numeric data which is of 9 digit) from 2 or more worksheets in column B(Here shown only two in actual it is more than 2 ).And corresponding to Right side is the sheet name.
Pls note,I will add further worksheets as here only two worksheets I have shown besides "Summary" worksheet.
Once again you are failing to give fully representative data. What about this type of data that you told us about halfway through your last thread?
Khitwan Polythene Bag Udhyog (Calami Eng.),Pght(300010459 (Main))
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Oops.I forget to incorporate.Thanx for reminding me.
Kindly take this into consideration assuming in worksheet 'Man'
Getting a bit fed up of having to remind you. Take more time over preparing your data.
I won't be helping, since you can't be bothered to update your sample workbook as requested. I don't have the time to waste today - sorry
Ok,now I have prepared an exhaustive list.Plz find enclosed in attachment.
Plz note that I have more than 2 worksheet in actual however the structure will be same as presented here.Kindly take this too in consideration.
I now hope this would be suffice info.
Does in the summury sheet Columns B , C,....Will be filled as you add more sheets.Give one example.
Why rows 2 - 7 in column C is blank.
Al the column From B willbe filled manually.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
ok let me explain again.In 'Summary' worksheet,
B3 & Below are the unique data that is extracted from other 2 or more worksheets (Currently here only shown 2).C1,D1 are the worksheet name.Data in C3 & Below as well as D3 & below are the data corresponding to the unique data of B column.In other words is a pivot to column B so that duplicates exists.Blank in D3:D7 as there is no corresponding data matches to B in worksheet as mentioned in D1.
Now as per your query,if I add more sheets,only unique data will be filled in B column and corresponding data in C,D,E,......Pls see the data as shown in B9,C9,D9 in a single row C9 and D9 data are more or less are different but due to its uniqueness/Common in B9 of C & D column,data is perfectly well placed.
I hope now this is suffice info.
Please Login or Register to view this content.
In B3 then copied down
Please Login or Register to view this content.
Thanx for your response.You have pulled in B column but other column such as C,D hasn't been pulled out.Originally Posted by kvsrinivasamurthy
In B3 then copied down
Please Login or Register to view this content.
Post #8 Jindon has been done as it was expected.
Thanx a lot to both forum contributors @Jindon & kvsrinivasamurthy for the consistent help & support.
I am marking this thread as solved based on Post #1
Last edited by paradise2sr; 09-30-2020 at 04:58 AM.
Re: Compile data into one
I am marking this thread as solved.
Last edited by paradise2sr; 09-30-2020 at 04:55 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks