asked on Formula to append new data and keep existing data
Hi Experts using excel 2010
Is there a way to usw a formula to append new data to a column and not to over write data that is already in the column. I have use a look to populate column A. Now i want to add new values to column A whilst keeping the original values in cilumn A.
Is there a way to usw a formula to append new data to a column and not to over write data that is already in the column. I have use a look to populate column A. Now i want to add new values to column A whilst keeping the original values in cilumn A.
Microsoft ExcelMicrosoft Office
Last Comment
route217
ASKER
Thanks for the feedback. So its not possible to have a formula that ignores values..and only adds data to blqnk cells
That's correct.
ASKER
What options do i have?
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks for the excellent feedback
You will have to look for a VBA workaround.