Duplicate values at the bottom, not at the top [Closed]

Report
Posts
34
Registration date
Monday March 10, 2014
Status
Member
Last seen
September 21, 2015
-
Posts
2674
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 27, 2020
-
Hi ,
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 for your help

2 replies

Posts
2674
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 27, 2020
446
Hi Jutulu,

The result is located where the formula is located.
So change the location of the formula to change the location of the result.

Best regards,
Trowa
Posts
34
Registration date
Monday March 10, 2014
Status
Member
Last seen
September 21, 2015
1
Thanks Trowa,

Can you please explain it a bit further? I thought of it before I send it and indeed changed the order of the formula, but no success. In my mind, my little knowledge, the last ),""), should avoid a false statement.
Posts
2674
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 27, 2020
446
Hi Jutulu,

I guess we are talking about different things.
What I meant was when you have a data range of A2:A10 and you have your formula in A1 then result will be on top. If you place your formula in A11 your result will be at the bottom.

Technically you are not avoiding the false statement with "". You are basically saying if the statement is false then input nothing.

Not sure what you are trying to achieve. Maybe post some sample data and explain what you want to do with it, along with result sample data.

Best regards,
Trowa