Sort and Count Data

[madnhain]

Good morning all!
I am looking for a solution to complete a series of tasks. Preferably VB...
Basically, on sheet3 I want to collect a long list of 6 digit numbers from sheet2 (B:B), remove all duplicate values, place the unique values in sheet3(A:A) and in the adjacent column sheet3(B:B), calculate the number of original occurrences of the number in column A.

I can do this manually, but I'd like it work automagically, continually updating as new data is entered.

Thank you in advance!

[MarvinP]

Hi madnhain,

Automagically is a great term. If you can upload a sample of your data with some expected results, we can see if the magic can be applied. I don't see how you can count original occurrences if you've removed duplicates. To upload/attach a workbook click on the "Go Advanced" button below the message area and then on the paperclip icon above the advanced message area.

[madnhain]

I'll have to adjust the data in the workbook as it is sensitive material. This may take some time but I will try to get to it asap.

I'd calculate the original occurrences using a COUNTIF of the original data.

[madnhain]

sample_data.xlsx
Here's some sample data.

Thank you!

[madnhain]

Any ideas on this yet?

[jindon]

To Sheet3 code module

Please Login or Register  to view this content.

Will update each time you select Sheet3

[madnhain]

Automagical! Thank you kind sir! That works perfectly! I'd like it to sort B descending as well, but I'm pretty sure I can add some code to do that.
The only issue I have, it deletes all other info in the sheet. is there a way to keep the other information? In column C is a VLOOKUP that gives the corresponding name to the number in column 1 taken from sheet 1 column D. I can deal with not having that, but it would be nice.

[jindon]

Change to

Please Login or Register  to view this content.

[madnhain]

Beautiful. Simply automagical. Sorry for the delay, I've been away on vacation. Thank you for your help! This works perfectly!