I have 2 Excel spreadsheets that I must do a side by side comparison on. I am comparing one employee spreadsheet to another spreadsheet of the same employee and there are columns that need a 'Y' or 'N' in reference to things like "Does employee have access to this?".
The reason I am doing this is because the employee had a name change but still needs the same file access as before. Now that the employee has a new employee id, etc.... it is imperative that I be certain the new employee(same employee but different name) has the same access('Y' and 'N') as before, to their over 600 files.
I need to be absolutely certain I have a 'Y' or 'N' on that employee's access, and that their access to certain systems is the same as their previous name.
Is there a way to tell Excel to count up all the row values and see how many 'Y' or 'N' values there are? Or is there a way to have Excel do an actual comparison of one spreadsheet's values in a certain column to another spreadsheet with the same column?