Concatenate VARIABLE ranges of Character Strings

Kvsrinivasasmurthy,

See attached with more detailed comments about the situation I have been running into with the last couple of attachments you have sent.

Just so I know, where are you? What time zone? It is 10:30 am PST Mon/23 right now.

I will do what I can but I still cannot get the values in Pattern2, Pattern of Values, and Count to go beyond what is already there. I keep getting the N/A error message in the Pattern2 field every time I put in a new pattern of values in the Killed and Injured fields, and so therefore I can't get Pattern of Values and Count to increase as well.

I will try to figure out what the N/A error message in Pattern2 is referring to, but could use some help here.

I've attached a screen shot of what I am talking about.

Don't worry about the J field--you can include it if you like--but it wasn't central to the main tasks. I have heard of the Ctrl+Shift+Enter keys part, but don't know what you mean by "confirming array formulas" by using the keys?

Thanks again. We are just about there if we can get these 3 columns to work.

Daniel B