# Thread: results at the top of each day, not at each cell

1. ## results at the top of each day, not at each cell

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

2. 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.

3. It puts it at the bottom of the duplications for me toony, not the top!

4. Originally Posted by Bob Phillips
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.

5. 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

6. Please supply an Excel file with a column of data and a few expected results in the right places.

7. 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.

8. 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

9. toony,

where is the link to the other forums?

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•