identifying number associated with most recent unique id

You MAY be able to ID the latest entry in col A by using INDEX() and COUNTA().

Are there formulas in col A?
Are there gaps in col A?

No formulas in the unique id column. Each row is an instance of information associated with that unique id. The only gaps are complete row gaps to identify when a new month occurs.

Can you post a sample file showing the setup (covering 2 or 3 gap rows) so I can see how to get last row?

Here is an example. So again, I want to create a formula to count the most recent instance of each uinque id and then be able to indicate the total number of activities.

So for instance there are 4 id's with 3 activities (unique id's 1, 2, 3 & 4). There are four id's with 1 activity (unique id's 5, 6, 8, & 9).

Make sense?

Might even be easier if we were to create a formula to simply identify the most recent instance of the unique id, and then create suming formulas based on that...

I'm not getting what it is that you're after.

A simple COUNTIF(A:A,"X") where X is a unique ID yields the results you gave in Post #5.

INDEX(A:A,COUNTA(A:A)) gives the last ID number in col A.

Where do you want to go from there?

So the number of activities for each instance could be more than 1. This is why the summed column of activiteis based on unique id is important.

I think if I could create a formula that would identify the most recent (furthest down) instance of a unique ID I could then create seperate summing formulas to indicate which ID have a certain number of total activities...

Still at a loss to know what the end goal is but does this help?

Change the ID number in cell F2 and then use a MAX() on the F column to ID the most recent occurrence of that ID #

This does help, thank you!

The end goal is to identify the most recent occurance of each unique id and then create seperate counting formulas to see how many of these unique ids have a certain number of total activities.

For instance, I need to know how many have 5+ activities, how many have 4, 3, 2, etc.

If there is a drag down formula that could identify the most recent occurance, similar to the max function you proposed except not conditional on the inputting of the each id independently, I could then create a countif function based on the identification of the most recent occurnace.

This help? Change the row 1000 to a higher number if you anticipate that.

How's this:

Change the # in cell H2 and you get an X beside ID's that equal or exceed that number.
Cell I2 counts the X's

Thank you, Cutter! -- That works well.