Hello, i need help to format my data.
why is it that after using the if(isblank...) formula in a blank column it cannot be detected if it is blanks if you use "Go To Special" even though you have used a pasted value in another column.
Coloumn E3 if use "Go To Special" cannot be detected if it is blanks. Is there a formula or setting to detect blanks? because it will use filled macro merge duplicate value and beforehand it was necessary to fill in blank rows in Excel according to the contents above.
why is it that after using the if(isblank...) formula in a blank column it cannot be detected if it is blanks if you use "Go To Special" even though you have used a pasted value in another column.
Coloumn E3 if use "Go To Special" cannot be detected if it is blanks. Is there a formula or setting to detect blanks? because it will use filled macro merge duplicate value and beforehand it was necessary to fill in blank rows in Excel according to the contents above.