Hey!!
I have been struggling with this for a few days. I have used some basic if statements but can't get what I need. My spread sheet is 160k rows by 15 columns. I can’t show the spread sheet here due to confidentially. But here is a small example. Now I want to see If I search using column A , can I add the line below in the same cell if it matches, and count it as one so its not Gary, Gary Green, Green. But if there is something new it only adds it once.
So basically I want to search by my only constant Column A and if it matches the one above it, it adds info the cell above it, if it doesn’t it leaves and keep searching, but if there is new info it adds it to the cell.
4 Gary Green
4 Gary Green
10 Agrawal Rohit R.
48 Steve Nabil
48 Steve Nabil
50 Billy Sames
50 Billy Sames
125 Ben Heart
125 Ben Wash
125 Ben Heart
125 Ben Heart
125 Ben Heart
125 Ben Heart
125 Ben Heart
125 Ben Heart
125 Ben Heart
125 Ben Heart
125 Ben Heart
125 Ben Heart
125 Ben Heart
125 Ben Gray
So this is what it would kind of look like when its done:
4 Gary Green
10 Agrawal Rohit R.
48 Steve Nabil
50 Billy Sames
125 Ben Heart
125 Ben Heart,Wash, Gray
Let me know if this makes sense.. Please help would love to be done!
Bookmarks