# How to Delete or Hide an excel column using a formula?

I was once challenged to tell a formula which can hide or delete the excel coulomb, depends on the calculation , …. for you information Dum people usually asked such question while inferring the other , so there is very simple answer to this question

First remember that excel formula is only work where it is pasted and on the bases of result excel formula cannot delete itself, so this means that you cannot find any formula in excel which can delete coulomb or Cell or even no formula can hide any thing on the bases of its result

the only way to do it is use the VB in Micro function , which is again not the formula but VB coding