Awesome, this has worked so well, I really am thankful for your help. I should acutally read what is writtens 🙂
Thank you Velouria, for answering the question. I never wrote the formula, could you explain what the difference would be using SUMPRODUCT or IFERROR,...
Hi SunnyKow, I have now been using this formula for a year now and it has worked excellently. {=IF(COUNTIF('Data 2019'!$A$1:$A$517,$A$2)<ROWS...
this is the forumla i tried {=IF(COUNTIF(Data!$H$8:$H$1000,$C$6)<ROWS($A$8:A8),"",INDEX(Data!$A$8:$A$1000,SMALL(IF(Data!$H$1:$H$1000=$C$6,ROW(Da...
HI Sunny I have included the test sheet of what i am after. I have tried to play around with the forumla but i cant get it to work. I have ...
I like this example also as it will do excatly what i have in mind. just trying to work out the array formulas 🙂 SunnyKow said Hi Matthew As an...
thanks all, i am playing with all methods at the moment the most data i get in the month is no more that 500 lines. i think the pivot table wo...
Thanks for your replies i will try here is the headings of my data id code clients name visit date visit time visit type future appointment clinici...