Jan 21 2020 04:13 AM
Hi,
I am trying to make an IF Function where if the answer is "false" rather than just leaving a blank cell, Excel will automatically skip to the next line.
You will find in my example, that if a product is checked (in the checkbox) on sheet1, I want this product to appear in my table on sheet3. But for the time being, the table will also count the blank cells and this is very annoying.
How can I do ?
Jan 22 2020 12:05 AM
You omitted to attach your example. Please try again.