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

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
 

p45cal

Super Moderator
Staff member
Joined
Dec 16, 2012
Messages
2,168
Reaction score
10
Points
38
Excel Version(s)
365
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.
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
It puts it at the bottom of the duplications for me toony, not the top!
 

p45cal

Super Moderator
Staff member
Joined
Dec 16, 2012
Messages
2,168
Reaction score
10
Points
38
Excel Version(s)
365
It puts it at the bottom of the duplications for me toony, not the top!
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.
 

toony

New member
Joined
Mar 6, 2014
Messages
49
Reaction score
0
Points
0
Location
UK
Excel Version(s)
Excel 2016
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
 

p45cal

Super Moderator
Staff member
Joined
Dec 16, 2012
Messages
2,168
Reaction score
10
Points
38
Excel Version(s)
365
Please supply an Excel file with a column of data and a few expected results in the right places.
 

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
Excel 2016
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:

toony

New member
Joined
Mar 6, 2014
Messages
49
Reaction score
0
Points
0
Location
UK
Excel Version(s)
Excel 2016
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
 

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
Excel 2016
toony,

where is the link to the other forums?
 
Top