$$Excel-Macros$$ Formula for calculate max number for unique values

2013-11-04 Thread Ali Abbas
On Nov 2, 2013 9:03 AM, "Ali Abbas" wrote: > Dear All, How can we develop a Formula for calculate max number in unique > values like if we have 1000 total values and 10 values are unique in this > data. I have needed a single formula which can calculate unique values max > number (problem is all

RE: $$Excel-Macros$$ Formula for calculate max number for unique values

2013-11-03 Thread Ravinder
PFA with two solution, if you are looking for this. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ali Abbas Sent: Saturday, November 02, 2013 2:33 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Formula for calculate max number for

$$Excel-Macros$$ Formula for calculate max number for unique values

2013-11-02 Thread Ali Abbas
Dear All, How can we develop a Formula for calculate max number in unique values like if we have 1000 total values and 10 values are unique in this data. I have needed a single formula which can calculate unique values max number (problem is all 1000 values in a single column and their number in ot