Please help with metric sheet formulas!
I need help with a couple of formulas for my metric sheet.
1- I have a master sheet and am trying to figure out a formula for my metric sheet to list all duplicate names on that sheet.
2- I have built a couple of reports from one master sheet. I need a formula to get a count of how many names are on each report.
3- I have an expiration date column that calculates many expiration dates on that row and returns the earliest date. If that expires, I want to see the name on that row, the representative responsible to follow up (from a dropdown) and which task from that filter expired.
Help Article Resources
Check out the Formula Handbook template!