Hi Everyone,

I've been a member on here for a while now and usually can find what I need through other posts, however this one has me stumped

I'm working on making a report with Excel as dynamic as possible for the end user and I am by no means a power user so would like to stay away from VBA if possible.

Column B is a text field which contains a list of staff names and the data (not including the header) starts in B11 and will vary in the number of rows, however to B1000 should be a safe bet.

I would like to populate cell C8 with the number of unique records, which will update when a field is filtered.

From everything that I have seen on the internet, it looks like this will be an array formula, however I've yet been able to addapt it to my scenario.

If you can steer me in the right direction that would be great

TIA
Sue