Comparing data in multiple excel worksheets [Closed]

Report
Posts
1
Registration date
Tuesday March 12, 2013
Status
Member
Last seen
March 12, 2013
-
Posts
2401
Registration date
Sunday September 23, 2012
Status
Moderator
Last seen
December 13, 2018
-
Hello,

For work, I was given an excel document with a different worksheet for each month in 2012. Clients can come to our food pantry one time in each calendar month. On the worksheet for each month, column A has the client's last name, B has the first name, and the other columns have information about things like gender and zip code and birthdate. We are trying to find a way to compare the data in the different worksheets, with the ultimate goal of figuring out how many total, unduplicated clients we have seen throughout the year. (If the same person came in July and then October, we only count it as one person.) Does that make sense?? And does anyone know any efficient way to do this???

Thank you very much!

1 reply

Posts
2401
Registration date
Sunday September 23, 2012
Status
Moderator
Last seen
December 13, 2018
532
Hi anglcol,

You can use Microsoft Excel's COUNTIFS() Worksheet Function to accomplish this task. You can find more details about this function from the below mentioned link:

https://support.office.com/en-us/article/countifs-function-dda3dc6e-f74e-4aee-88bc-aa8c2a866842?ocmsassetID=HA010047494&CorrelationId=4540eb07-0167-43b5-98d5-75b4799f0a24&ui=en-US&rs=en-US&ad=US

If you need further assistance, you can upload the sample data sheet to the below mentioned website:

https://authentification.site

Note: Before you upload any files please make sure there is no personal or confidential information contained in it.

Please do write back to us.