I am a complete newbie and I am stuck with this problem. I am currently reconciliating 2 excel file in which i need to read the segment of the master file and compare it to the source file. However the master file contains blank cells in which we are to assume based on the file. Please see screenshot below:
Any idea how can I do this? How do I equate the blank cell to be the previous one. If the blank cell previous segment is consumer then the blank cell will be treated as consumer. Then if it passes the corporate segment, all the blanks after the corporate segment wil be treated as corporate not consumer.