How I use Advace Filter option for this?

thara05

New Member
Joined
Mar 28, 2014
Messages
30
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.
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
[TABLE="width: 884"]
<colgroup><col><col><col><col><col span="3"><col><col><col></colgroup><tbody>[TR]
[TD]Name[/TD]
[TD]Position[/TD]
[TD]Salary[/TD]
[TD]Net Salary[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Even[/TD]
[TD]Accountant[/TD]
[TD="align: right"]80,000.00[/TD]
[TD="align: right"]64,000.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Reymond[/TD]
[TD]Administrator[/TD]
[TD="align: right"]89,000.00[/TD]
[TD="align: right"]71,200.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Willee[/TD]
[TD]Administrator[/TD]
[TD="align: right"]75,000.00[/TD]
[TD="align: right"]60,000.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Ben[/TD]
[TD]Administrator[/TD]
[TD="align: right"]85,000.00[/TD]
[TD="align: right"]68,000.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Deen[/TD]
[TD]Clerk[/TD]
[TD="align: right"]60,000.00[/TD]
[TD="align: right"]48,000.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Fillen[/TD]
[TD]Clerk[/TD]
[TD="align: right"]40,000.00[/TD]
[TD="align: right"]32,000.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Moor[/TD]
[TD]Clerk[/TD]
[TD="align: right"]35,000.00[/TD]
[TD="align: right"]28,000.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Sandy[/TD]
[TD]Clerk[/TD]
[TD="align: right"]50,000.00[/TD]
[TD="align: right"]40,000.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Fred[/TD]
[TD]Clerk[/TD]
[TD="align: right"]59,000.00[/TD]
[TD="align: right"]47,200.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Nancy[/TD]
[TD]Clerk[/TD]
[TD="align: right"]55,000.00[/TD]
[TD="align: right"]44,000.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Rondy[/TD]
[TD]Manager[/TD]
[TD="align: right"]94,000.00[/TD]
[TD="align: right"]75,200.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Noor[/TD]
[TD]Manager[/TD]
[TD="align: right"]78,000.00[/TD]
[TD="align: right"]62,400.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Dandy[/TD]
[TD]Secretory[/TD]
[TD="align: right"]40,000.00[/TD]
[TD="align: right"]32,000.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Grue[/TD]
[TD]Secretory[/TD]
[TD="align: right"]56,000.00[/TD]
[TD="align: right"]44,800.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Salle[/TD]
[TD]Secretory[/TD]
[TD="align: right"]55,000.00[/TD]
[TD="align: right"]44,000.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Position[/TD]
[TD](All)[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Name[/TD]
[TD]Data[/TD]
[TD]Total[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Dandy[/TD]
[TD]Sum of Salary[/TD]
[TD="align: right"]40000[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD]Sum of Net Salary[/TD]
[TD="align: right"]32000[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Deen[/TD]
[TD]Sum of Salary[/TD]
[TD="align: right"]60000[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD]Sum of Net Salary[/TD]
[TD="align: right"]48000[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Fillen[/TD]
[TD]Sum of Salary[/TD]
[TD="align: right"]40000[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD]Sum of Net Salary[/TD]
[TD="align: right"]32000[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Fred[/TD]
[TD]Sum of Salary[/TD]
[TD="align: right"]59000[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD]Sum of Net Salary[/TD]
[TD="align: right"]47200[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Grue[/TD]
[TD]Sum of Salary[/TD]
[TD="align: right"]56000[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD]Sum of Net Salary[/TD]
[TD="align: right"]44800[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Moor[/TD]
[TD]Sum of Salary[/TD]
[TD="align: right"]35000[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD]Sum of Net Salary[/TD]
[TD="align: right"]28000[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Nancy[/TD]
[TD]Sum of Salary[/TD]
[TD="align: right"]55000[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD]Sum of Net Salary[/TD]
[TD="align: right"]44000[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Salle[/TD]
[TD]Sum of Salary[/TD]
[TD="align: right"]55000[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD]Sum of Net Salary[/TD]
[TD="align: right"]44000[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Sandy[/TD]
[TD]Sum of Salary[/TD]
[TD="align: right"]50000[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD]Sum of Net Salary[/TD]
[TD="align: right"]40000[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]Total Sum of Salary[/TD]
[TD="align: right"]450000[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]Total Sum of Net Salary[/TD]
[TD="align: right"]360000[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
a simple pivot table with the non required job titles excluded - you could pull the data to a neater formatted table if you wanted....
 
Upvote 0
We have in A:D with headers in row 1...

[TABLE="width: 365"]
<TBODY>[TR]
[TD="class: xl65, width: 98, bgcolor: white"]Name
[/TD]
[TD="class: xl65, width: 125, bgcolor: white"]Position
[/TD]
[TD="class: xl66, width: 135, bgcolor: white"]Salary
[/TD]
[TD="class: xl66, width: 129, bgcolor: white"]Net Salary
[/TD]
[/TR]
[TR]
[TD="class: xl63, width: 98, bgcolor: white"]Even
[/TD]
[TD="class: xl63, width: 125, bgcolor: white"]Accountant
[/TD]
[TD="class: xl64, width: 135, bgcolor: white"]Rs.80,000.00
[/TD]
[TD="class: xl64, width: 129, bgcolor: white"]Rs.64,000.00
[/TD]
[/TR]
[TR]
[TD="class: xl63, width: 98, bgcolor: white"]Reymond
[/TD]
[TD="class: xl63, width: 125, bgcolor: white"]Administrator
[/TD]
[TD="class: xl64, width: 135, bgcolor: white"]Rs.89,000.00
[/TD]
[TD="class: xl64, width: 129, bgcolor: white"]Rs.71,200.00
[/TD]
[/TR]
[TR]
[TD="class: xl63, width: 98, bgcolor: white"]Willee
[/TD]
[TD="class: xl63, width: 125, bgcolor: white"]Administrator
[/TD]
[TD="class: xl64, width: 135, bgcolor: white"]Rs.75,000.00
[/TD]
[TD="class: xl64, width: 129, bgcolor: white"]Rs.60,000.00
[/TD]
[/TR]
[TR]
[TD="class: xl63, width: 98, bgcolor: white"]Ben
[/TD]
[TD="class: xl63, width: 125, bgcolor: white"]Administrator
[/TD]
[TD="class: xl64, width: 135, bgcolor: white"]Rs.85,000.00
[/TD]
[TD="class: xl64, width: 129, bgcolor: white"]Rs.68,000.00
[/TD]
[/TR]
[TR]
[TD="class: xl63, width: 98, bgcolor: white"]Deen
[/TD]
[TD="class: xl63, width: 125, bgcolor: white"]Clerk
[/TD]
[TD="class: xl64, width: 135, bgcolor: white"]Rs.60,000.00
[/TD]
[TD="class: xl64, width: 129, bgcolor: white"]Rs.48,000.00
[/TD]
[/TR]
[TR]
[TD="class: xl63, width: 98, bgcolor: white"]Fillen
[/TD]
[TD="class: xl63, width: 125, bgcolor: white"]Clerk
[/TD]
[TD="class: xl64, width: 135, bgcolor: white"]Rs.40,000.00
[/TD]
[TD="class: xl64, width: 129, bgcolor: white"]Rs.32,000.00
[/TD]
[/TR]
[TR]
[TD="class: xl63, width: 98, bgcolor: white"]Moor
[/TD]
[TD="class: xl63, width: 125, bgcolor: white"]Clerk
[/TD]
[TD="class: xl64, width: 135, bgcolor: white"]Rs.35,000.00
[/TD]
[TD="class: xl64, width: 129, bgcolor: white"]Rs.28,000.00
[/TD]
[/TR]
[TR]
[TD="class: xl63, width: 98, bgcolor: white"]Sandy
[/TD]
[TD="class: xl63, width: 125, bgcolor: white"]Clerk
[/TD]
[TD="class: xl64, width: 135, bgcolor: white"]Rs.50,000.00
[/TD]
[TD="class: xl64, width: 129, bgcolor: white"]Rs.40,000.00
[/TD]
[/TR]
[TR]
[TD="class: xl63, width: 98, bgcolor: white"]Fred
[/TD]
[TD="class: xl63, width: 125, bgcolor: white"]Clerk
[/TD]
[TD="class: xl64, width: 135, bgcolor: white"]Rs.59,000.00
[/TD]
[TD="class: xl64, width: 129, bgcolor: white"]Rs.47,200.00
[/TD]
[/TR]
[TR]
[TD="class: xl63, width: 98, bgcolor: white"]Nancy
[/TD]
[TD="class: xl63, width: 125, bgcolor: white"]Clerk
[/TD]
[TD="class: xl64, width: 135, bgcolor: white"]Rs.55,000.00
[/TD]
[TD="class: xl64, width: 129, bgcolor: white"]Rs.44,000.00
[/TD]
[/TR]
[TR]
[TD="class: xl63, width: 98, bgcolor: white"]Rondy
[/TD]
[TD="class: xl63, width: 125, bgcolor: white"]Manager
[/TD]
[TD="class: xl64, width: 135, bgcolor: white"]Rs.94,000.00
[/TD]
[TD="class: xl64, width: 129, bgcolor: white"]Rs.75,200.00
[/TD]
[/TR]
[TR]
[TD="class: xl63, width: 98, bgcolor: white"]Noor
[/TD]
[TD="class: xl63, width: 125, bgcolor: white"]Manager
[/TD]
[TD="class: xl64, width: 135, bgcolor: white"]Rs.78,000.00
[/TD]
[TD="class: xl64, width: 129, bgcolor: white"]Rs.62,400.00
[/TD]
[/TR]
[TR]
[TD="class: xl63, width: 98, bgcolor: white"]Dandy
[/TD]
[TD="class: xl63, width: 125, bgcolor: white"]Secretary
[/TD]
[TD="class: xl64, width: 135, bgcolor: white"]Rs.40,000.00
[/TD]
[TD="class: xl64, width: 129, bgcolor: white"]Rs.32,000.00
[/TD]
[/TR]
[TR]
[TD="class: xl63, width: 98, bgcolor: white"]Grue
[/TD]
[TD="class: xl63, width: 125, bgcolor: white"]Secretary
[/TD]
[TD="class: xl64, width: 135, bgcolor: white"]Rs.56,000.00
[/TD]
[TD="class: xl64, width: 129, bgcolor: white"]Rs.44,800.00
[/TD]
[/TR]
[TR]
[TD="class: xl63, width: 98, bgcolor: white"]Salle
[/TD]
[TD="class: xl63, width: 125, bgcolor: white"]Secretary
[/TD]
[TD="class: xl64, width: 135, bgcolor: white"]Rs.55,000.00
[/TD]
[TD="class: xl64, width: 129, bgcolor: white"]Rs.44,000.00
[/TD]
[/TR]
</TBODY>[/TABLE]

Leave F1 empty.
Enter the following in F2:

=OR(B2="clerk",B2="secretary")

Now follow the following steps...
Select F1:F2.
Fire up Advanced Filter
Click OK.
For List range: Select the range in A:D including the headers.
For Criteria range: Select again F1:F2.
For Copy to, select cell F3.
Click OK.

The criteria range along with the output will look like:

[TABLE="width: 308"]
<COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 75pt; mso-width-source: userset; mso-width-alt: 3555" width=100><COL style="WIDTH: 97pt; mso-width-source: userset; mso-width-alt: 4579" width=129><COL style="WIDTH: 88pt; mso-width-source: userset; mso-width-alt: 4181" width=118><TBODY>[TR]
[TD="class: xl68, width: 64, bgcolor: #ffffcc"] [/TD]
[TD="class: xl67, width: 100, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 129, bgcolor: transparent"] [/TD]
[TD="width: 118, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: #ffffcc, align: center"]FALSE[/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl69, width: 64, bgcolor: white"]Name[/TD]
[TD="class: xl69, width: 100, bgcolor: white"]Position[/TD]
[TD="class: xl70, width: 129, bgcolor: white"]Salary[/TD]
[TD="class: xl70, width: 118, bgcolor: white"]Net Salary[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64, bgcolor: white"]Deen[/TD]
[TD="class: xl66, width: 100, bgcolor: white"]Clerk[/TD]
[TD="class: xl66, width: 129, bgcolor: white"]Rs.60,000.00[/TD]
[TD="class: xl65, width: 118, bgcolor: white"]Rs.48,000.00[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64, bgcolor: white"]Fillen[/TD]
[TD="class: xl66, width: 100, bgcolor: white"]Clerk[/TD]
[TD="class: xl66, width: 129, bgcolor: white"]Rs.40,000.00[/TD]
[TD="class: xl65, width: 118, bgcolor: white"]Rs.32,000.00[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64, bgcolor: white"]Moor[/TD]
[TD="class: xl66, width: 100, bgcolor: white"]Clerk[/TD]
[TD="class: xl66, width: 129, bgcolor: white"]Rs.35,000.00[/TD]
[TD="class: xl65, width: 118, bgcolor: white"]Rs.28,000.00[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64, bgcolor: white"]Sandy[/TD]
[TD="class: xl66, width: 100, bgcolor: white"]Clerk[/TD]
[TD="class: xl66, width: 129, bgcolor: white"]Rs.50,000.00[/TD]
[TD="class: xl65, width: 118, bgcolor: white"]Rs.40,000.00[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64, bgcolor: white"]Fred[/TD]
[TD="class: xl66, width: 100, bgcolor: white"]Clerk[/TD]
[TD="class: xl66, width: 129, bgcolor: white"]Rs.59,000.00[/TD]
[TD="class: xl65, width: 118, bgcolor: white"]Rs.47,200.00[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64, bgcolor: white"]Nancy[/TD]
[TD="class: xl66, width: 100, bgcolor: white"]Clerk[/TD]
[TD="class: xl66, width: 129, bgcolor: white"]Rs.55,000.00[/TD]
[TD="class: xl65, width: 118, bgcolor: white"]Rs.44,000.00[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64, bgcolor: white"]Dandy[/TD]
[TD="class: xl66, width: 100, bgcolor: white"]Secretary[/TD]
[TD="class: xl66, width: 129, bgcolor: white"]Rs.40,000.00[/TD]
[TD="class: xl65, width: 118, bgcolor: white"]Rs.32,000.00[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64, bgcolor: white"]Grue[/TD]
[TD="class: xl66, width: 100, bgcolor: white"]Secretary[/TD]
[TD="class: xl66, width: 129, bgcolor: white"]Rs.56,000.00[/TD]
[TD="class: xl65, width: 118, bgcolor: white"]Rs.44,800.00[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64, bgcolor: white"]Salle[/TD]
[TD="class: xl66, width: 100, bgcolor: white"]Secretary[/TD]
[TD="class: xl66, width: 129, bgcolor: white"]Rs.55,000.00[/TD]
[TD="class: xl65, width: 118, bgcolor: white"]Rs.44,000.00[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64, bgcolor: white"] [/TD]
[TD="class: xl66, width: 100, bgcolor: white"] [/TD]
[TD="class: xl66, width: 129, bgcolor: white"] [/TD]
[TD="class: xl65, width: 118, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64, bgcolor: white"] [/TD]
[TD="class: xl66, width: 100, bgcolor: white"] [/TD]
[TD="class: xl66, width: 129, bgcolor: white"] [/TD]
[TD="class: xl65, width: 118, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64, bgcolor: white"] [/TD]
[TD="class: xl66, width: 100, bgcolor: white"] [/TD]
[TD="class: xl66, width: 129, bgcolor: white"] [/TD]
[TD="class: xl65, width: 118, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl65, width: 64, bgcolor: white"] [/TD]
[TD="class: xl66, width: 100, bgcolor: white"] [/TD]
[TD="class: xl66, width: 129, bgcolor: white"] [/TD]
[TD="class: xl65, width: 118, bgcolor: white"] [/TD]
[/TR]
</TBODY>[/TABLE]
 
Last edited:
Upvote 0
I need to filter data using advance filter option

Out of curiosity: What does this mean? What does it matter what's the method you use if it solves the problem?

About what you posted, you have "Clerk" and "Secretory" in the same row. This means "Clerk" AND "Secretory".

If you want "Clerk" OR "Secretory" they must be in different rows.

For ex. erase "Secretory" from the second row and write it in row 3 and then run the Advanced Filter. Don't forget to include the third row in the Criteria range.
 
Upvote 0

Forum statistics

Threads
1,223,231
Messages
6,170,884
Members
452,364
Latest member
springate

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