results at the top of each day, not at each cell

T

toony

New member
Joined
Mar 6, 2014
Messages
49
Reaction score
0
Points
0
Location
UK
Excel Version(s)
Excel 2016
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
 
completely untested but try replacing
=1
with:
=COUNTIF($AJ$2:$AJ$10000,$AJ2191)
the red $2 assumes your data starts at row 2; adjust if it doesn't. The $ symbol is important.
 
It puts it at the bottom of the duplications for me toony, not the top!
 
Bob Phillips said:
It puts it at the bottom of the duplications for me toony, not the top!
Click to expand...
It does indeed!

Depending on what you're counting it might be this:
=IF(COUNTIF($AJ2191:$AJ$10000,$AJ2191)=1,COUNTIFS($AJ$2:$AJ$10000,$AJ2191,$AT$2:$AT$10000,">"&0),"")
Again, the red 2 assumes your data starts at row 2; adjust if it doesn't and the $ symbol is important.
 
Sorry, but it doesn't seam to work. It does count from the top of first AJ countif, but I need it to count from the bottom of the first AJ countif.

IF(COUNTIF(AJ$2:AJ2390,AJ2390)=1,COUNTIFS(AJ2390:AJ$10001,AJ2390,AQ2390:AQ$10001,">"&0),""))

Thank you for your patience
 
Please supply an Excel file with a column of data and a few expected results in the right places.
 
toony, please post links to all forums that you crossposted at. You have several people working on the same problem and we don't know it.

Please read this article to understand the problem: http://www.excelguru.ca/content.php?184

 
Last edited:
Apologies about it. I understand. I think that I didn't apply it correctly and that's why is not working for me. I should try it tomorrow and let you know, but should work. Many thanks for your help and for your pacience
 
toony,

where is the link to the other forums?
 
You must log in or register to reply here.
Back
Top