Paul Naylor
Board Regular
- Joined
- Sep 2, 2016
- Messages
- 98
- Office Version
- 365
- 2003 or older
- Platform
- Windows
- Mobile
- Web
Hi Hoping someone can help.
I have a workbook with daily worksheets titled Sunday! : Saturday! Which contains a list of refunds comprising of nymbers Ord1234567..... column A and names column B. If the refund is not done on the same day it is carried forward onto the next days sheet.
What to be able to count the total unique order numbers across all the worksheets ( Sunday: Saturday) for a given name e.g. " Robot". Ignoring duplicate occurances e.g. if a given order number appeared 3 times across sheets only count it as one, but need the ability to vary the name.
We're still using excel 97
I have a workbook with daily worksheets titled Sunday! : Saturday! Which contains a list of refunds comprising of nymbers Ord1234567..... column A and names column B. If the refund is not done on the same day it is carried forward onto the next days sheet.
What to be able to count the total unique order numbers across all the worksheets ( Sunday: Saturday) for a given name e.g. " Robot". Ignoring duplicate occurances e.g. if a given order number appeared 3 times across sheets only count it as one, but need the ability to vary the name.
We're still using excel 97
Last edited by a moderator: