Count the Cell Value And Control the Cell Row Number

[Samael2021]

Dear Sir,
Let me request a VBA Code for this issue.
1. input file Column C is full of duplicate cell value.
2. For duplicate value, I want to delete this row and increase the count in Count Header Column and give this as output as shown in figure.
Please help and guide me, Thanks you so much......

 

[Radoslaw Poprawski]

is easy to do in Power query.
Provide minisheeet please or link to a workbook.

 

[Samael2021]

is easy to do in Power query.
Provide minisheeet please or link to a workbook.

I want to get it in VBA.
Could you please help me?

 

[Radoslaw Poprawski]

sadly im not good with VBA, there are much better easier simpler solutions then vba now.

i did found this article on vba duplicate removal:

Removing Duplicate Values in Excel with VBA - Automate Excel

In this ArticleRemoveDuplicates MethodRemoveDuplicates Usage NotesSample Data for VBA ExamplesRemove Duplicate RowsRemove Duplicates Comparing Multiple ColumnsRemoving Duplicate Rows from a TableRemove Duplicates From ArraysRemoving Duplicates from Rows of Data Using VBA This tutorial will...

www.automateexcel.com

 

[Samael2021]

sadly im not good with VBA, there are much better easier simpler solutions then vba now.

i did found this article on vba duplicate removal:

Removing Duplicate Values in Excel with VBA - Automate Excel

In this ArticleRemoveDuplicates MethodRemoveDuplicates Usage NotesSample Data for VBA ExamplesRemove Duplicate RowsRemove Duplicates Comparing Multiple ColumnsRemoving Duplicate Rows from a TableRemove Duplicates From ArraysRemoving Duplicates from Rows of Data Using VBA This tutorial will...

www.automateexcel.com

Thanks you. I knew this can remove the duplicates but Unfortunately, it doesn't match what I want. Deleting the duplicate depending on Column B and C and increasing the count in Next Column is still missing.

 

[Radoslaw Poprawski]

as I said, im not too good with VBA.
tried to help tho.

With power query this would be no issue at all

 

[Samael2021]

as I said, im not too good with VBA.
tried to help tho.

With power query this would be no issue at all

Whatever, Thank u so much, Sir. You are always helping me .

 

[Radoslaw Poprawski]

in PQ this would be simple duplicate all 4 columns. merge them, remove duplicates, delete helping column load - 4 steps and ur done in less then a minute

if data change simply refresh, ur done

 

[Marc L]

Let me request a VBA Code for this issue.

Hi, link your workbook on a files host website like Dropbox for example​

and well elaborate all the process …​