Forum Discussion
Solved
How can i resolve this problem?
I prepared a table in excel with "IF" formula using a data, then i copied and pasted the values in the table as values. Then i have so many blank cells in my table and i cannot delete them easily as...
Have you tried the Filter function ?
Example in file with your source data "as is" in first sheet, and with your source data in a table in second sheet.
"=FILTER(Table1[Provinces];Table1[Countries]=G$1)"
Thank you so much. After your answer, i searched something about array functions and aggregate usage. I really loved your approach. That legacy solution is so helpful, and i spend a few hours to comprehend it. Thanks for sharing it with us !
Sekoleyte , glad to help