Hi All
Is there a formula which can generate a sequence of number on higher then the other such as 1,2,3,4,5,6 etc I know in MS Acess you use something like this:
NewNum: "1234" & Max(Right([StudentID],4)+1)
just need to know if excel can
Hi All
Is there a formula which can generate a sequence of number on higher then the other such as 1,2,3,4,5,6 etc I know in MS Acess you use something like this:
NewNum: "1234" & Max(Right([StudentID],4)+1)
just need to know if excel can
yeah, pretty much exactly the same.
A1 = studentID
the existing student ID number
A2 = "1234" & (right(A1, 4) +1)
the new number, as a text string; wrap a converter if you want it to be a number
So yes, it can be done, I guess?
I mean, something like,
A1 = student ID number
A2 = A1 + 1
that might be easier....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks