Data Entry Error Matrix

[Thomas Kuriakose]

Respected Sirs,

Kindly find attached a list of data entry errors by users with entered data and the required data.

We need to prepare a single matrix user wise based on this data which covers the following -
1. Count of entry per user
2. Count of correct entry per user - match of data entry and required entry
3. Count of incorrect entry per user - mismatch between required entry and data entry and show the required vs actual data entry. We need to show to user what was entered by the user and what should have been entered.

Thank you so much,

with regards,
thomas

 

[Chihiro]

I'd recommend helper column and PivotTable for your need.

Helper column formula:
=CHOOSE(--EXACT(B2,C2)+1,"ERROR","MATCH")

See attached for PivotTable example (Sheet2). Double click on Error Value Field and new sheet will show each Error line items.

 

[Thomas Kuriakose]

Respected Sir,

Thank you very much for the solution provided for this.

Thanks once again,

with regards,
thomas

 

[Thomas Kuriakose]

Respected Sirs,

A new method required to check the same.

The manager wants to monitor the entered parameter with respect to the actual parameter as per the attached file.

Kindly let me know how this can be done.

Thank you very much,

with regards,
thomas

 

[NARAYANK991]

Hi Thomas ,

One way.

Narayan

 

[Thomas Kuriakose]

Respected Sir,

This is simply amazing. Thank you so much.

I will check and let you know.

with regards,
thomas

 

[Thomas Kuriakose]

Respected Sir,

Your solution was so interesting that now we have many more ideas.

Kindly find attached the file with new requirements based on your solution.

Kindly let me know how we can get this.

Thank you so much,

with regards,
thomas

 

[Chihiro]

Another version of Pivot Can you tell that I like Pivot?

 

[Thomas Kuriakose]

Respected Sir,

Yes we would like to go with the pivot.

Kindly help with the file for this pivot solution.

Thanks,

with regards,
thomas

 

[Chihiro]

See attached.

You can customize design a bit more.
Go to PivotTable Tools -> Design Tab ->PivotTable Styles

Expand and then select "New Pivot Table Style" you can play with setting to see if can get the desired result.

 

[Thomas Kuriakose]

Respected Sir,

Thank you very much for the file and the solution provided for this.

Thanks once again,

with regards,
thomas