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)"
A workaround would be to change your formula, in the first step, to insert a character ("-"), rather than a blank ("") e.g. =IF($C2=K$1,$D2,"-")
Then copy / paste values as normal and a new step will be find / replace (CTRL + H); find - replace with nothing (leave the replace field empty)......now your special / blanks function will work.
- That's a good idea, i appreciate you for your help. İ can use any character that doesn't exist in any cell instead "", then i replace them with blank and i can delete blank cells. it absolutely works 🙂
