Oct 23 2022 02:03 PM - edited Oct 23 2022 02:38 PM
Oct 23 2022 02:15 PM
The easiest way would be to use the FILTER() function. However, this is somewhat newer and is therefore not yet available to everyone. If it works for you, you can use the following function in cell M4. Please copy the header rows from the original data.
If you can't use FILTER() yet, please give some feedback.
Oct 23 2022 02:38 PM - edited Oct 23 2022 02:59 PM
Unfortunately I tried what you said but it didn't work, I think it doesn't happen because I want to do it on a separate page.
I have attached my sample excel file.
Oct 23 2022 03:08 PMSolution
If you have Microsoft 365 of Office 2021, you can use
If you use comma as decimal separator:
See the attached workbook.