Filtered Rows using Mode Function?
 

Hi Excel Forum,

I am using numeric "filtered" data and I need to find the most frequen
/ re-occurring values (1st, 2nd, 3rd, 4th, 5th etc.) from the visibl
filtered rows. The Mode function seemed likely, but I cannot get it t
work with filtered rows.

Can you assist with working examples, please:

Formula based input direct to worksheet.
VBA Macro using Formula.
VBA UserDefined Function.

Thank you
QT

--
Message posted from http://www.ExcelForum.com