most used value
Haralambus wrote:
hi,
I have data in 1300 rows and 8 columns (all numbers). How can I filter out
most used x values?
thanks
Assuming your data is in A1:H1300 and nothing in J1, put the following array
formula (commit with CTRL+SHIFT+ENTER) in J2 and copy down x rows:
=MODE(IF(COUNTIF($J$1:J1,$A$1:$H$1300)=0,$A$1:$H$1 300))
These are the most used values. Not sure what you want to do from there...
|