Selecting specific columms with BE in the lines

Copper Contributor

Hi everyone,

 

I am new to this forum and I would like to get some help with a excel sheet. My client works with Bol.com, a online webshop and I receive a specification every month of the sales. The only problem is that I can't filter the sales in BE (Belgium) for some reason.

I need to now what the amount of sales in € was in BE for the VAT taxes. All I want to know is how I can select all the numbers in specific columns (L & M) with the BE. Remember: the sorting option does not work in this file, because Excel will shutdown then.

So to be specific:

All the prices (column L) need to be filtered from Belgium (BE) from column L.

 

I hope that you guys understand with i'm saying.

 

Thanks in advance! 

1 Reply

@SBoekhouding 

 

Hello, you need to upload the excel workbook. The picture isn't clear