Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-12-2021, 11:20 AM
allex011 allex011 is offline Auto-increment numbers Windows 7 32bit Auto-increment numbers Office 2007
Advanced Beginner
Auto-increment numbers
 
Join Date: Dec 2017
Posts: 39
allex011 is on a distinguished road
Default 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
Attached Files
File Type: xlsx Example.xlsx (31.2 KB, 15 views)
Reply With Quote
  #2  
Old 05-15-2021, 02:46 AM
Purfleet Purfleet is offline Auto-increment numbers Windows 10 Auto-increment numbers Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

Something like this?

=MAXIFS($B$1:B15,$A$1:A15,A16)+1
Attached Files
File Type: xlsx ExampleAR12.xlsx (9.8 KB, 8 views)
Reply With Quote
  #3  
Old 05-17-2021, 12:25 AM
ArviLaanemets ArviLaanemets is offline Auto-increment numbers Windows 8 Auto-increment numbers Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto-increment numbers 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
Auto-increment numbers 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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:53 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft