now we are going to talk about how to add
letters to numbers that are occurring a row I was asked by a customers so she
had several occurrences of a number in a row and she'd like to have the ABCD
appearing with the new with these numbers and then when it changes to
another number they would like to start all over again at ABCD for each occurance so
how I am solving this problem is I'm gonna break it down so let's go in the first
cell and let's ask the system is this number of the same as the number a head of
it or on top of it so let's go an ifs statement here and let's go equals
if and so what we're gonna do with the bracket and will say is A2 equal to
A1 so if that is equal we are going to do is leave a blank spot for right now and if it is not equal
we are going to take this value here and we're gonna add the A letter to it so how this would go is we would go open
bracket and then we would select this value and then we'll put the and sign and then
we're gonna put quotation marks and in A and the end of quotation marks
and into the brackets and if so what happens is you get that so now when you
drag down every time there's a new occurrence of a number you get it with an
A beside so that's part of the first problem so now let's deal with so you
have the number below it and you want it to be
B ok so let's let's go
equals so this A is a character code so let's go so character and then code
what we are going to do is take the first number that first character from the right side of the cell above so we will go right
and we will select this one B2 and we want just one character and put another bracket
and then we are going to add one to that because we want it to increment by one
and there it is working it has b, c, d but wait here forgot that it has to start over again at A so now let's put everything
together and see if we can get it to work so you start up here
with our if function which we have already got here so let's put our formula in here so
what we are going to do is go opening bracket and we are going to go A2 and then we are going to go charcter code and then we are going to go right
and then we will go B1 and it is just the first character we want and then close that bracket and then we want to increment it by one so lets put a plus sign and one and then we will close these brackets
lets press enter with the letter so now if we drag this down
we have each of our numbers with a letter beside it and when it changes to a new number we will have it starting at A again