As I sayd - hide helper columns! Place them as rightmost ones, and hide them. And unless you plan to use the workbook as shared one, define your table as Table like I did won Replacements sheet - then the formulas are added automatically into helper columns whenever new data is added into Table



You have to get rid of such entries. Either replace them with full list, or you'll need some additional helper columns where the entry is at first converted to full list, which is then used as source for further calculations.

Or don't use formulas at all. You design a stored procedure which writes desired result into specified column(s). The procedure is called from event of button on worksheet, or from keyboard shortcut.

Ok

Thanks for the help!!!!

I will check and get back to you if anything can't unresolved.

Thanks
Ganesan. G