Sequential Concatenation

[efolsom54]

Hello,
I am new here, but have a question I have not been able to answer anywhere else. I woulk to have the window tag section, which is a concatenate formula [=IF($B44>0,CONCATENATE($D$5,-1),"")] pull the floor number from cell D5, and then for each sequence that is added in this case below, add another number. For example, "MARK" A would be 13-1; "MARK" B would be 13-2; "MARK" C would be 13-3; "MARK" D would be 13-4 and so on. Basically, I was thinking that everytime there is a value >0 in the "MARK" column I would like the second half of the "Window Tag" concatenation to increase by "1". Anyone have any ideas? Does anyone actually understand what I am asking? HAHA

Thank you!

concatenate.png

[FDibbins]

Hi and welcome to the forum

I understand what you want, but please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you Also, not all members can upload picture files (Company firewalls and stuff)

[efolsom54]

Thank you for the clarification! Attached you will find a copy of the sheet I am working with. Please note that I would like to have my sequential concatenation begin in cell A44, and continue down to A103. If anyone has any questions or requires additional information or clarification from me, please let me know.

Thank you!

[martindwilson]

you could try
=IF(B44<>"",$D$5&"-"&COUNTA($B$44:B44),"")

[FDibbins]

Thanks, that makes things much easier

If you want to have the sequence to continue, despite blanks in B (ie 13-1, 13-2, 13-3, 13-6, 13-7), then use this...
=IF($B44>0,$D$5&"-"&ROWS($A$1:A1),"")

If you dont want the blanks counted, use this instead...
=IF($B44>0,$D$5&"-"&COUNTA($K$43:K43)-COUNTBLANK($K$43:K43),"")

[efolsom54]

Thank you! That was EXACTLY what I was looking for!

[FDibbins]

Just out of curiosity, which 1 worked for you?

[efolsom54]

MartinDWilson's answer was exactly what I was looking for.

Thank you again.