Can someone help me. How if in column A enter a value for example "C" to see in column B what was the last number next to the value of "C" and to add that value increased by one.
I attached excel file.

Thank in advanced

Attached Files

Example.xlsx (31.2 KB, 17 views)

Something like this?

=MAXIFS($B$1:B15,$A$1:A15,A16)+1

Attached Files

ExampleAR12.xlsx (9.8 KB, 10 views)

To get any meaningful answer, you have to explain, what you mean by 'last number'!

Is it a number in last row with same value in column A positioned above current row (i.e. determined by position of information rows in table)? When yes, then this means, that this number must be recalculated whenever the table is sorted. At same tame, it means you can use formula to calculate this number;

Or it is a number with same value in column A entered latest of all such rows (i.e. determined by time it was entered). When yes, then there must be a column with entry time or unique row id physically entered into table (which allows to calculate the value in column C using formula), or you must have a procedure which calculates and enters a value into column B whenever a new row is created and value is entered into column A.