Thanks for the quick response.
Unfortunately I can't open this workbook as its created in a new version (I am currently on 6.1).
Are you able to save this as a 6.1 file?
Hi Cathal, not easily (I'd have to install/uninstall) but the formula is fairly straight forward:
IF ISNULL(ATTR([Reference Number])=LOOKUP(ATTR([Reference Number]),-1)) THEN
ELSEIF ATTR([Reference Number])=LOOKUP(ATTR([Reference Number]),-1) THEN
Put that on the filter shelf and set the compute using to "table down." Will look something like this:
If you have any trouble, post the workbook and I'll take a look (I can read 6.1 just can't create them).
Thanks Shawn, just getting back to this today!
I have tested your formula and it works fine which is fantastic.
Is it possible to get the formula to work without having the dimensions used (ie created date and reference number) in the row shelf? I need to present the data in summary format, I have 12 different types of work and I need to include a count of each in the period.
Not sure if this is possible?
In saw your suggestion on Cathal's query. I am also facing same problem on duplicate records. I want to remove the duplicates on mobile numbers like i want to show only one count per number instead of two or more . I tried the solution suggested by you to Cathal but still my issue isn't resolved. i am attaching one sample sheet with this mail. Please suggest me the possible solution as soon as possible. I am awaiting for your reply.