I want to filter the data if 'position' equal to clerk or secretory using advance filter option.
This is my data table :
[TABLE="width: 420"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Name[/TD]
[TD]Position[/TD]
[TD]Salary[/TD]
[TD]Net Salary[/TD]
[/TR]
[TR]
[TD]Even[/TD]
[TD]Accountant[/TD]
[TD="align: right"]Rs.80,000.00[/TD]
[TD="align: right"]Rs.64,000.00[/TD]
[/TR]
[TR]
[TD]Reymond[/TD]
[TD]Administrator[/TD]
[TD="align: right"]Rs.89,000.00[/TD]
[TD="align: right"]Rs.71,200.00[/TD]
[/TR]
[TR]
[TD]Willee[/TD]
[TD]Administrator[/TD]
[TD="align: right"]Rs.75,000.00[/TD]
[TD="align: right"]Rs.60,000.00[/TD]
[/TR]
[TR]
[TD]Ben[/TD]
[TD]Administrator[/TD]
[TD="align: right"]Rs.85,000.00[/TD]
[TD="align: right"]Rs.68,000.00[/TD]
[/TR]
[TR]
[TD]Deen[/TD]
[TD]Clerk[/TD]
[TD="align: right"]Rs.60,000.00[/TD]
[TD="align: right"]Rs.48,000.00[/TD]
[/TR]
[TR]
[TD]Fillen[/TD]
[TD]Clerk[/TD]
[TD="align: right"]Rs.40,000.00[/TD]
[TD="align: right"]Rs.32,000.00[/TD]
[/TR]
[TR]
[TD]Moor[/TD]
[TD]Clerk[/TD]
[TD="align: right"]Rs.35,000.00[/TD]
[TD="align: right"]Rs.28,000.00[/TD]
[/TR]
[TR]
[TD]Sandy[/TD]
[TD]Clerk[/TD]
[TD="align: right"]Rs.50,000.00[/TD]
[TD="align: right"]Rs.40,000.00[/TD]
[/TR]
[TR]
[TD]Fred[/TD]
[TD]Clerk[/TD]
[TD="align: right"]Rs.59,000.00[/TD]
[TD="align: right"]Rs.47,200.00[/TD]
[/TR]
[TR]
[TD]Nancy[/TD]
[TD]Clerk[/TD]
[TD="align: right"]Rs.55,000.00[/TD]
[TD="align: right"]Rs.44,000.00[/TD]
[/TR]
[TR]
[TD]Rondy[/TD]
[TD]Manager[/TD]
[TD="align: right"]Rs.94,000.00[/TD]
[TD="align: right"]Rs.75,200.00[/TD]
[/TR]
[TR]
[TD]Noor[/TD]
[TD]Manager[/TD]
[TD="align: right"]Rs.78,000.00[/TD]
[TD="align: right"]Rs.62,400.00[/TD]
[/TR]
[TR]
[TD]Dandy [/TD]
[TD]Secretory[/TD]
[TD="align: right"]Rs.40,000.00[/TD]
[TD="align: right"]Rs.32,000.00[/TD]
[/TR]
[TR]
[TD]Grue[/TD]
[TD]Secretory[/TD]
[TD="align: right"]Rs.56,000.00[/TD]
[TD="align: right"]Rs.44,800.00[/TD]
[/TR]
[TR]
[TD]Salle[/TD]
[TD]Secretory[/TD]
[TD="align: right"]Rs.55,000.00[/TD]
[TD="align: right"]Rs.44,000.00[/TD]
[/TR]
</tbody>[/TABLE]
I had tried it like this, but I it wasn't no luck.
[TABLE="width: 497"]
<colgroup><col span="2"><col><col span="2"></colgroup><tbody>[TR]
[TD]Name[/TD]
[TD]Position[/TD]
[TD]Position[/TD]
[TD]Salary[/TD]
[TD]Net Salary[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Clerk[/TD]
[TD]Secretory[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
hope somebody may help me.
Thank you.
This is my data table :
[TABLE="width: 420"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Name[/TD]
[TD]Position[/TD]
[TD]Salary[/TD]
[TD]Net Salary[/TD]
[/TR]
[TR]
[TD]Even[/TD]
[TD]Accountant[/TD]
[TD="align: right"]Rs.80,000.00[/TD]
[TD="align: right"]Rs.64,000.00[/TD]
[/TR]
[TR]
[TD]Reymond[/TD]
[TD]Administrator[/TD]
[TD="align: right"]Rs.89,000.00[/TD]
[TD="align: right"]Rs.71,200.00[/TD]
[/TR]
[TR]
[TD]Willee[/TD]
[TD]Administrator[/TD]
[TD="align: right"]Rs.75,000.00[/TD]
[TD="align: right"]Rs.60,000.00[/TD]
[/TR]
[TR]
[TD]Ben[/TD]
[TD]Administrator[/TD]
[TD="align: right"]Rs.85,000.00[/TD]
[TD="align: right"]Rs.68,000.00[/TD]
[/TR]
[TR]
[TD]Deen[/TD]
[TD]Clerk[/TD]
[TD="align: right"]Rs.60,000.00[/TD]
[TD="align: right"]Rs.48,000.00[/TD]
[/TR]
[TR]
[TD]Fillen[/TD]
[TD]Clerk[/TD]
[TD="align: right"]Rs.40,000.00[/TD]
[TD="align: right"]Rs.32,000.00[/TD]
[/TR]
[TR]
[TD]Moor[/TD]
[TD]Clerk[/TD]
[TD="align: right"]Rs.35,000.00[/TD]
[TD="align: right"]Rs.28,000.00[/TD]
[/TR]
[TR]
[TD]Sandy[/TD]
[TD]Clerk[/TD]
[TD="align: right"]Rs.50,000.00[/TD]
[TD="align: right"]Rs.40,000.00[/TD]
[/TR]
[TR]
[TD]Fred[/TD]
[TD]Clerk[/TD]
[TD="align: right"]Rs.59,000.00[/TD]
[TD="align: right"]Rs.47,200.00[/TD]
[/TR]
[TR]
[TD]Nancy[/TD]
[TD]Clerk[/TD]
[TD="align: right"]Rs.55,000.00[/TD]
[TD="align: right"]Rs.44,000.00[/TD]
[/TR]
[TR]
[TD]Rondy[/TD]
[TD]Manager[/TD]
[TD="align: right"]Rs.94,000.00[/TD]
[TD="align: right"]Rs.75,200.00[/TD]
[/TR]
[TR]
[TD]Noor[/TD]
[TD]Manager[/TD]
[TD="align: right"]Rs.78,000.00[/TD]
[TD="align: right"]Rs.62,400.00[/TD]
[/TR]
[TR]
[TD]Dandy [/TD]
[TD]Secretory[/TD]
[TD="align: right"]Rs.40,000.00[/TD]
[TD="align: right"]Rs.32,000.00[/TD]
[/TR]
[TR]
[TD]Grue[/TD]
[TD]Secretory[/TD]
[TD="align: right"]Rs.56,000.00[/TD]
[TD="align: right"]Rs.44,800.00[/TD]
[/TR]
[TR]
[TD]Salle[/TD]
[TD]Secretory[/TD]
[TD="align: right"]Rs.55,000.00[/TD]
[TD="align: right"]Rs.44,000.00[/TD]
[/TR]
</tbody>[/TABLE]
I had tried it like this, but I it wasn't no luck.
[TABLE="width: 497"]
<colgroup><col span="2"><col><col span="2"></colgroup><tbody>[TR]
[TD]Name[/TD]
[TD]Position[/TD]
[TD]Position[/TD]
[TD]Salary[/TD]
[TD]Net Salary[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Clerk[/TD]
[TD]Secretory[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
hope somebody may help me.
Thank you.