Multiple Column Data Comparision and Output

[nostra]

My scenario:
I have 3 columns of data say A, B & C. I need to look for duplicates in Column A and compare each entry with corresponding values in column B. Now in a new table, print the entry from column A once, entry from B once and the total count A matched with duplicates in B as well as the corresponding values from C.
Attached is the sample worksheet with Ex. input and desired output.
I have close to 500K entries(rows) that I need to run this against. Any help will be well appreciated and thank you in advance.

[jraj1106]

Hi.

Post an excel file please.

[FDibbins]

Hi nostra, and welcome to the forum

Often, a copy/paste of your data to here does not show exactly what the layout is, so it is always better to upload a sample workbook, showing what data you are working with, a few examples of what your expected outcome would be, and how you would arrive at that (remove any confidential info if necessary).
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[nostra]

Thank you and sorry about that FDibbins.
The worksheet is attached with sample data and desired output. So just to reiterate, I want to pick the first value in column A, and print it's corresponding values in column B & C in a new table. Now the sheet has to look if the same value is ever repeated again in column A, if yes match against the value in column B and if both match to the first entry in the new table then increment counter by one otherwise just insert a new row.

Bottom line I am trying to figure out the number of times an ID shows up in a particular room with it's time stamp.

Thanks...

[henkdevreisch]

Hello,

This is my first post on the excel forum and this is the same problem that I am occuring. Is there already a solution for this?

best regards

[FDibbins]

Henk welcome to the forum


The only posts to this thread are what you see

Also, just in case the answer to this thread does not meet your needs, you need to start your own thread (reference this 1 if it is relevant). Based on forum rules, you are not allowed to post your own questions on some-one elses thread

Thanks