• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Copy All row if matches any cell in range

S

Suresh Badhani

Member
Dear all,
I have a some query as below:
I have part codes which are compatible with other parts also so I want if any one of this part match in range row or column copy that all row in new sheet.

part search may be any cell in that row result display excluding search part.

Please find attached sheet. and help to resolved the same.
 

Attachments

Dear All how can we combined duplicate cell value in
In data file there is multiple same cases id with multiple data field against for same case Id . We have required multiple data in single cell for unique cases ID.
Raw data as below:
upload_2015-2-9_13-41-40.png
Result required with unique case id :

Please help in this how can we do this.
Suresh Chandra
 

Attachments

I would strongly suggest NOT doing what you asked. Merging the records in the manner you show makes them much harder to analyzse, changes all the dates to text (so they won't wort correctly), and makes chance of using a PivotTable impossible. See the attached, where I took the raw data and made a PT. Visually, it looks a little cleaner (which may be what you were going for), but I still have all unique data.
 

Attachments

Thanks for your reply . but by pivot table data comes in multiple row and we use vlookup by case id in open case analysis then this retrieve only ist data for that case id other can not retrieve. As in data dates already in text format.
 
VLOOKUP would return dates as dates, not as text. Rather than trying to smoosh the raw data together, why not change your formulas so that it returns multiple results? Or, you could even adopt the macro I posted for your original question. The Search tool I built originally returns all lines that match. It just happened that in your sample, there was only 1 match.
 
Thanks for your concern but I think I fail to understand you problem. Issue that data coming in multiple raw not in single cell I attached sample file once again please check this map be help to understand execat isuue
 

Attachments

Ack! The data looks worse now, you can't tell which PO numbers line up with which dates easily. The route it appears you are trying to go is not good, my friend.

Again, I would say to go either with the PivotTable, which will summarize the CaseID, or use AutoFilter, to view only pertinent records. But taking individual records and trying to smoosh them all together into single cells is not how XL is meant to work. I can not help you in that endeavor. :(
 
You must log in or register to reply here.
Back
Top