Hello all! This is my first post, and I hope I'm not asking something that has been covered before. I believe this will be a unique situation. After searching, it looks like people only have issues with deleting and/or finding duplicates.
I have a table from excel with multiple columns, and it actually has a new column added each day. For each day (column) user names appear for each user that has logged on. I would like to find a way to create a report that only shows which users names have appeared a certain number of times (such as 4). Ex: Using the table below, 2 different users (Chris and Jennifer) logged on at least 4 times. I need to make a report that lists which users logged on 4 or more times, and the count of those occurrences as well.
The reason we need to do this, is because we are having problems with users continuing to log on in a manner we don't want them logging in. After they have continued to log in after so many times, we are going to disable their access completely.
Thanks for your help! Let me know if you need any further explanation.
<tbody>
</tbody>
I have a table from excel with multiple columns, and it actually has a new column added each day. For each day (column) user names appear for each user that has logged on. I would like to find a way to create a report that only shows which users names have appeared a certain number of times (such as 4). Ex: Using the table below, 2 different users (Chris and Jennifer) logged on at least 4 times. I need to make a report that lists which users logged on 4 or more times, and the count of those occurrences as well.
The reason we need to do this, is because we are having problems with users continuing to log on in a manner we don't want them logging in. After they have continued to log in after so many times, we are going to disable their access completely.
Thanks for your help! Let me know if you need any further explanation.
Day 1 | Day 2 | Day 3 | Day 4 | Day 5 |
Chris | Chris | Chris | Chris | Chris |
John | Robert | Robert | Robert | Scott |
Amanda | Jennifer | Jennifer | Larry | Kate |
Jennifer | Larry | Mary | John | Jennifer |
Kevin | Rich | Mary |
<tbody>
</tbody>