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+shift+ENter. See attached sheet. On Wed, Feb 15, 2012 at 1:23 PM, Mohammed Muneer mmun...@ccc.com.qa wrote: -- Thanks regards, Noorain Ansari *http://noorainansari.com/* http://excelmacroworld.blogspot.com/

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?

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 noorain.ans...@gmail.comwrote: Dear Muneer, Please use.. =SUM(1/COUNTIF(A1:A356,A1:A356) with ctrl+shift+ENter. See attached

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?

Thank You, Mr. Noorain for u r help, praises to u r full presence of mind and salute to knowledge.. Regards, Muneer, CC... From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Wednesday,