Hi 

I am facing an problem in filtering the value in online excel (o365).

I have 10000 rows of data which will a series of numbers like A/AR/24/0001 and there will be duplicate and also will be something like A/AR/23/0001so sometimes i need to filter multiple values in excel. When i try filtering since there are lot of individual value in a single column. I need to search for the value and add to the sheet. when i try to select multiple value and clicked that (add to selection list) but it took the last value which i have selected. so every time i need to select a value > add to current selection > apply then proceed for next filter. Is there any way to avoid this

​Hi I am facing an problem in filtering the value in online excel (o365).I have 10000 rows of data which will a series of numbers like A/AR/24/0001 and there will be duplicate and also will be something like A/AR/23/0001so sometimes i need to filter multiple values in excel. When i try filtering since there are lot of individual value in a single column. I need to search for the value and add to the sheet. when i try to select multiple value and clicked that (add to selection list) but it took the last value which i have selected. so every time i need to select a value > add to current selection > apply then proceed for next filter. Is there any way to avoid this  Read More

​