#1
|
|||
|
|||
Auto-increment numbers
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 |
#2
|
|||
|
|||
Something like this?
=MAXIFS($B$1:B15,$A$1:A15,A16)+1 |
#3
|
|||
|
|||
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. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Auto-incrementing variable needed for macro - to automatically increment chapter numbering & headers | Fred Doolie | Word | 2 | 06-30-2020 03:13 PM |
Increment Numbers | Darbsp | Word | 3 | 03-10-2015 05:25 AM |
Page numbers increase at wrong increment | leah wen | PowerPoint | 3 | 04-16-2014 10:57 AM |
Transpose Issue (need custom increment on auto fill down) | gretchen | Excel | 3 | 11-28-2012 02:33 PM |
Increment Numbers Help | Jazz43 | Word | 2 | 07-30-2010 02:48 AM |