Re: $$Excel-Macros$$ plz, check how many categories are there in the column A totally by formula that is applied in single cell to display the result?

2012-02-15 Thread NOORAIN ANSARI
Dear Muneer, Please use.. =SUM(1/COUNTIF(A1:A356,A1:A356) with ctrl+shift+ENter. See attached sheet. On Wed, Feb 15, 2012 at 1:23 PM, Mohammed Muneer wrote: > -- Thanks & regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blog

Re: $$Excel-Macros$$ plz, check how many categories are there in the column A totally by formula that is applied in single cell to display the result?

2012-02-15 Thread The Viper
in addition to noorain formula you can use =sumproduct(1/COUNTIF(A1:A356,A1:A356) without ctrl+shift+enter On Wed, Feb 15, 2012 at 1:56 PM, NOORAIN ANSARI wrote: > Dear Muneer, > > Please use.. > > =SUM(1/COUNTIF(A1:A356,A1:A356) > with ctrl+shift+ENter. > > See attached sheet. > On Wed, Feb 1

RE: $$Excel-Macros$$ plz, check how many categories are there in the column A totally by formula that is applied in single cell to display the result?

2012-02-15 Thread Mohammed Muneer
, February 15, 2012 11:27 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ plz, check how many categories are there in the column A totally by formula that is applied in single cell to display the result? Dear Muneer, Please use.. =SUM(1/COUNTIF(A1:A356,A1:A356) with ctrl