Hi,
I need a formula that can read one cell and determine if it should do anything with that cell.
For example
I have cell M2 that is either blank or has data in it. So if M2 is blank, I want it to do nothing with the rest of the cells in that column. However, if it has data in that cell, I want it to go through the row, and where there isn't data (just blank cells) I want it to put a 0. Is there an easy way to do this? I appreciate any help. My sheet is about 28,000 rows long as well.
I need a formula that can read one cell and determine if it should do anything with that cell.
For example
I have cell M2 that is either blank or has data in it. So if M2 is blank, I want it to do nothing with the rest of the cells in that column. However, if it has data in that cell, I want it to go through the row, and where there isn't data (just blank cells) I want it to put a 0. Is there an easy way to do this? I appreciate any help. My sheet is about 28,000 rows long as well.