How to get formula drop down in a cell

[milankumarsahu]

Hi All,

Recently i came across an excel file, where in there are a set of data in a column. The last cell which gives the 'total' figure has a dropdown containing names like 'sum', 'average' etc. and when you select a particular formula in the dropdown, the cell gives the required result. The drop down and the final result are in the same cell. I am not sure, how to do it. Can somebody please help in doing the same.

 

[vijay.vizzu]

I think that... it is pivot table

 

[milankumarsahu]

I think that... it is pivot table

no its not a pivot table. and there is a drop down in the cell. In pivot, we don't get drop down, in the resultant cell

 

[sgmpatnaik]

@milankumarsahu

Welcome to Chandoo.org Forum, Glad you are here

as per Vijay said may be it is Pivot Table if it is not please upload a sample file

Thanks

SP

 

[NARAYANK991]

Hi Sahu ,

Can you clarify if it was a .xlsx file or a .xlsm file ? This can certainly be done with macros , though it is not really of such importance , since you have to go to a lot of trouble to achieve it.

Narayan

 

[sudipto3003]

dear sahu,
i have attach a sample file herewith, please confirm are you asking the same or else?

 

[NARAYANK991]

Hi Sudipto ,

Nice one ; it works only if you use the + sign ! Using the = sign does not work.

Narayan

 

[sudipto3003]

@narayan,

yes, but i don't know is it solve the problem of sahu or not?

 

[Debraj]

Hi Milan,

If you convert any Data to TABLE, you can get it as complimentary.

Just check the TOTAL ROW check box.