Hi,
I wanna tell you that fillter work in nested (One inside another) manner. Means
after you apply one filter on a data the remaining data is according to you
filter criteria. After this if you apply another filter ( Without removing the
first one) then the filter is according to your first
What I understand is that you want multiple filters on single
worksheet...say, one from row 1 to 16 and other from row 17 to 30 and so
onif i got your query right i am afraid it is not possible (as far as i
know). Let's see if any of the geniuses of the can tell a work around.
Rgrds
On Sat,
Dear Friends...
I am novice in excel but I think the list function can help us out.
It can be used in the following manner :
1.
DATA - LIST - CREATE LIST Define range and tick on - My list as headers
than u can use filters on both the data attaching for your reference
Respected members of group,
I want the 2 filter option in Raws not in Columns.
Is it possible.
Thanks
On Thu, Sep 24, 2009 at 10:21 AM, big smile bigsmile...@gmail.com wrote:
Hellow group members,
Have a nice time with excel master.
I have query that can it possible to
Dear Shah,
You can assign autofilters in two data range within a worksheet, attached
example has the solution for it. Though it is a tricky way, but yes it can
be used to some extent.
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com