toony
New member
The below formula gives me the results for AT column at the top of each duplicated code in column AJ. How could I make it to give me the results at the bottom of the duplicated codes instead of at the top?
=IF(COUNTIF($AJ2191:$AJ$10000,$AJ2191)=1,COUNTIFS($AJ2191:$AJ$10000,$AJ2191,$AT2191:$AT$10000,">"&0),"")
Many thanks
=IF(COUNTIF($AJ2191:$AJ$10000,$AJ2191)=1,COUNTIFS($AJ2191:$AJ$10000,$AJ2191,$AT2191:$AT$10000,">"&0),"")
Many thanks