Hi Guys
I use excel 2010
Need your help on this.
I have got source data which comes like this:
sales broker
2000 smith
3000 john
4000 mike
5000 julie
6000 belinda
7000 john
8000 smith
I want to delete all the rows where broker name is smith or john, and keep all the other rows .
data updates everyday, what will be the best option to create any macro to do this or is there any option in power query
to achieve this.
please advise both solutions with vba or macro and any option with the power query in excel 2010.
thanks
bondtk
Bookmarks