NEED HELP!!! Consolidate Similar looking data and count them in different sheet

preethamdevraj

New Member
Joined
Jun 7, 2020
Messages
2
Office Version
365
Platform
Windows
Hello,

I am using Excel 365 and trying to consolidate similar data in one column and count them in the column to the right. I have attached the data sheet and desired results as well. I have run this data every day and I have been doing it manually.
Here is the Google sheet link for the data
Attached is the picture of the Desired Result:
1591509872595.png





Any help from the Gods of Excel in this communicty would be of great help.....
 

Some videos you may like

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
44,622
Office Version
365
Platform
Windows
Here is the Google sheet link for the data
Welcome to the MrExcel board!
  • There is no link.
  • Is this a Google Sheets question?
What about using XL2BB so that helpers can easily copy your data/results for testing?
 

preethamdevraj

New Member
Joined
Jun 7, 2020
Messages
2
Office Version
365
Platform
Windows
Hi I am sorry, I just uploaded the data to a google sheet for reference.



@Peter_SSs
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
44,622
Office Version
365
Platform
Windows
Sorry, I don't intend to manually investigate 7000+ rows of data to try to work out what you want done. Can you make a much smaller sample that still demonstrates what you want and also explain how the consolidation is done manually? Then I could at least consider if I have a solution method. :)

You will also get more potential helpers if you provide the data/results with XL2BB as many people will not go to another site to download an unknown file, or are prevented from doing so by workplace security measures.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,004
Messages
5,465,955
Members
406,455
Latest member
mkadam

This Week's Hot Topics

Top