Batch Naming

[Minaru]

Hello everyone and thanks in advance for your help.


This is what I'm trying to do: I have a sheet that is been populated with information from several places within the work book. What I need to do is to be able to have the sheet create the name of the batch depending on if the day have any payments if not leave it blank

Column A      -      Column B
Batch name   -      $$$$$$$
(Blank)       -          (Blank)
7A             -         10.00
7B             -         20.00
(Blank)       -          (Blank)
(Blank)       -          (Blank)
7C             -          15.00
etc

So the batch name should start with 7 + a letter, so 7a, 7b, 7c, 7d, etc.

 

[njimack]

The following formula in A2 will give you the desired output (although you haven't said what should happen after 7Z). For some reason, I can't get this to work in conjunction with testing the value in column B

(confirm with ctrl+shift+enter)

="7"&CHAR(CODE(RIGHT(INDIRECT(ADDRESS(MAX(IF(LEFT(A$2:A2)="7",ROW(A$2:A2))),1))))+1)

 

[Minaru]

Yeah I didn't because in the must usual cases there is not pass Z.

The Batches are renew every month and as there are up to 31 days in them what we do is use a 7 for the first full alphabet set and then 8 and start the alphabet again this will not go pass E as there is only 1 batch per day.

If I could get it to fill the cell with the letter on its own, say A, B, C, D, etc, I could work on the code for the rest I just can't see to figure out how to use letters to arrange it; if it would have been numbers a simple loot would have been sufficient.

Thanks