Make multiple filter in rows at a time.

avisoft20

Board Regular
Joined
Sep 10, 2016
Messages
63
I WANT TO MAKE MULTIPLE FILTER IN ROWS AT A TIME ,IS IT POSSIBLE ?

example:

ROW-1 CELL1 CELL2 CELL3



ROW-10 CELL1 CELL2 CELL3
 
Last edited:

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
Not possible I don't think there would be a possible use case for this if you wish why don't you add tables in your sheet ???
 
Upvote 0
Thank you so much Ritika :).

I have a table given below.
i want two filter with range on date.is it possible ?



Dateinvoice noinv_Dateinv. Timeinv. Total
11-03-201517499611-02-20158:1743
11-03-201517502711-02-201514:4417
11-04-201517506911-03-20158:2710
11-04-201517507211-03-20158:3749
11-05-201517513311-04-201510:246
11-05-201517513111-04-20159:4731
11-06-201517517011-05-201510:2014
11-06-201517516911-05-20158:2947
11-07-201517524211-06-20159:5523
11-07-201517525111-06-201514:5823
11-10-201517529411-09-20159:4612
11-10-201517529211-09-20158:1518
11-12-201517533711-10-20158:1249
11-12-201517537611-10-201514:2660
13/11/201517545111-12-20159:0521
13/11/201517545811-12-201511:5575
Dateinvoice noinv_Dateinv. Timeinv. Total
14/11/201517555613/11/201513:0918
14/11/201517554713/11/20159:1632
17/11/201517559916/11/20159:347
17/11/201517560316/11/20159:5735
19/11/201517564418/11/20158:0934
19/11/201517566318/11/20159:04115
21/11/201517580820/11/20159:5440
21/11/201517584520/11/201515:0341
24/11/201517594623/11/201510:0828
24/11/201517592123/11/20158:3647
26/11/201517600525/11/20158:2226
25/11/201517600425/11/20158:1367

<tbody>
</tbody>
 
Upvote 0

Forum statistics

Threads
1,214,911
Messages
6,122,199
Members
449,072
Latest member
DW Draft

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top