Thanks very much Riny. Both for explaining why I wasn't able to get pivot data to work and for taking it that one stage further!
Hi Riny, Bizzarely I have just found the same solution. I think it was due to my lack of understanding of grouping. When I saw month wasn’t appea...
So I think I do have the completion field in the row labels and the value fields if I understand you correctly. (see attached) Where my pivot seems ...
Thanks Mynda! - I think I'm close your suggestion got me the 'highest' date for each month in the values column so now I think I 'just' need to work...
If its not possible to getting the dd/mm/YYYY format I can live with the date of the entry in day month form - which you have got but I haven't. T...
Thanks for your reply Riny. That’s close (and closer than I’ve been able to get!) but is it possible to get the rows to display in dd/mm/YYYY forma...
Hi Riny, I have created a small dummy sheet and tried out your suggestion and it works as you knew it would. I can see the mistake I was making was...
Hi Riny, Thanks for your response. I haven’t tried what you suggest and will do next time am in the office. I did try to cut and paste a column but ...
Thanks Mynda, that was it! Frustrated with myself because I thought I had checked that but one thing for certain, I won’t forget it again! 🙂 ...
Thanks Mynda, that’s very helpful. My data is in tabular layout as you surmised and we don’t have any performance issue at the moment. I’ll focus on...