macro to filter out data
Hi,
click on the menu DATA | AUTO FILTER
Excel will create an arrow on the top of you column for the column A click
on the arrow select custom put igual S or N (you have two options) click OK
click on the column B arrow select Custom Higher than 10
HTH
Regards from Brazil
Marcelo
"shabb090177" escreveu:
I have an xls in which I need to FILTER OUT data
worksheet name: Format
columns name: a) Incentive Name
b) Level
criteria: a) Incentive Name = 'S' or 'N'
b) Level '10'
I have very little experience in Excel previously, more so in macro/VBA
programming. Thanks in advance.
|