Krishna2385
New Member
Hi,
I have a daily activity which requires me to update the company names which are in separate cells into one cell based on the count. for example : if the count is two I need to combine company 1 and company 2 in one cell , like wise for count 3 and so on.
the data is huge the challenge for me is to add up the formula for the count more than 5. the count varies from data to data and it is not mandate that count 2 is followed by 3 nd 4 , if the data is not there it will skip 3&4 and updates 5 .
the formula which am using to update count 2,3 & 4 are as follows:
=C2&CHAR(10)&C3
=C3&CHAR(10)&C4&CHAR(10)&C5
=C4&CHAR(10)&C5&CHAR(10)&C6&CHAR(10)&C7
as I mentioned if its a sequential order I would have updated a simple macro but the count is not stable and may vary
I have a daily activity which requires me to update the company names which are in separate cells into one cell based on the count. for example : if the count is two I need to combine company 1 and company 2 in one cell , like wise for count 3 and so on.
the data is huge the challenge for me is to add up the formula for the count more than 5. the count varies from data to data and it is not mandate that count 2 is followed by 3 nd 4 , if the data is not there it will skip 3&4 and updates 5 .
the formula which am using to update count 2,3 & 4 are as follows:
=C2&CHAR(10)&C3
=C3&CHAR(10)&C4&CHAR(10)&C5
=C4&CHAR(10)&C5&CHAR(10)&C6&CHAR(10)&C7
as I mentioned if its a sequential order I would have updated a simple macro but the count is not stable and may vary