Request for formula
Good evening, I am looking for a formula to achieve the following:
Column 1 name: login
Column 2 name: supply type
There will be multiple login names within column 1, if there is a repeat login I would like to count the matches in column 2.
Example is listed below, login and supply type would be auto filled by a form and on the right side (which will actually be on a separate spreadsheet/summary page would show a count based upon the login. Hopefully that makes sense. I am looking to consolidate all supplies requested by a certain login providing me with a total count of supplies requested. Thanks in advance!
Help Article Resources
Check out the Formula Handbook template!