Hello, I'm trying to figure out how to use the IF function or any function for that matter to grab info from a row if its true, but then if the next one is false, instead of giving me a blank line, it would skip to the next TRUE row. I do not want this to be done by creating filters. I need a formula for this.
See attached
Also, I do not know very intricate formulas so when you post one please tell me exactly what the formula is telling me to do please
Something like: "The formula is telling excel to do this while doing that because of this part of the formula...and then it's saying to do this because of this part..."
Thank you! please help!
Bookmarks