Excel 2003:-
You can see only 1000 records in the Autofilter Dropdown. Not more than
that.
Excel 2007/2010:-
You can see 1 records in the Autofilter Dropdown. Not more than that.
So try to use some helper column based on your data criteria use some
formula in helper column like Istext, Isnu
hope this helps,
Paul
From: renuka chari
To: MS EXCEL AND VBA MACROS
Cc: jva.ch...@gmail.com
Sent: Wed, December 22, 2010 10:28:45 AM
Subject: $$Excel-Macros$$ help required for large range of data filteration
hi
good evening to all experts
currentely i am t
hi
good evening to all experts
currentely i am trubling in large range data with filtaration
my company data having nearly 4lac of rows in one file
i need to sort that data using auto filter Option then it was not
showing all filterd data i don't know how to filter that large rang of
data
can u
