Excel Data (Pivot) Help

[ramin23]

I have a Access Control log data of people for location offices.
Data Eg:
Employee_Name | Date | Time | Access_Control_Location | Event_Type

This data is system (software) generated based on the Fingerprint Authentication done by Employee on location point.

In some case data shows employee has logged In in 2 different location on same date - I need to find out that cases. I tried pivot but it shows full data I want to see only that data were employee has logged in >1 location on same date.

Please help.

[Pepe Le Mokko]

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[ramin23]

Thank You for the reply. Attached Test Report - almost same data what we get from the system.

If you check Employee are access multiple locations on same date - In pivot if you check 'Person 6' has accessed 'Location6' & 'Location9'

I want a pivot were I can see only those you have accessed multiple location on a particular date. - data is huge as real data will have 1000 employees daily access log.

Hope this info helps.

[:) Sixthsense :)]

Formula included in the attached file.

[ramin23]

Thank you for the reply, but your formula is showing wrong data.
In 1st June there is no multiple location entries done by any person. - On 3rd June Person6 has accessed Location6 & Location9. Please check the attached report.

I want my pivot to show only data of Person you has accessed more then 1 location on single date.

Hope this helps.

[:) Sixthsense :)]

Changed the formula. Please check the attached file.

[ramin23]

Thank You very much.. Great Help