Identifying formula cells with adjustment

[neeraj2050]

Greetings!!

I have different columns into excel and few of the them are having formulas. Sometimes to make adjustment, manually some addition or deletion is made into the formula i.e +100, -50, etc


Is there any way to identify only those cell with aforementioned adjustments?

Thanks in advance!!


Regards

Neeraj Kumar Agarwal

 

[NARAYANK991]

Hi ,

If the formula is the same in all cases , it is simple ; otherwise , it may require VBA unless you happen to have Excel 2013 or later version , in which case you can make use of the Formulatext function.

See the attached file for the simple case.

Narayan

 

[neeraj2050]

Practically it is not like that, I identify the cell and make adjustment manually. And that is random. Can't you help with any other way out except VBA

Regards
Neeraj Kumar Agarwal

 

[NARAYANK991]

Practically it is not like that, I identify the cell and make adjustment manually. And that is random. Can't you help with any other way out except VBA

Regards
Neeraj Kumar Agarwal

Hi ,

I am sorry , but I cannot think of any other approach for a general case where the formula can be any formula , in any cell.

Either you use VBA , or if you have Excel 2013 or later version , you use the FORMULATEXT function.

https://support.office.com/en-us/article/FORMULATEXT-function-0a786771-54fd-4ae2-96ee-09cda35439c8

Narayan

 

[neeraj2050]

I am having Excel 2010 into my system. It means only VBA would work. But I am sorry as not looking for VBA

Thanks a lot for your valuable time!!

Regards
Neeraj Kumar Agarwal