I need some help filtering out cells that a formula returns as "". I want to organize my cells so that cells that a formula returns data to is at the top and there are no empty "" cells above.
The following is how my sheet looks:
and I am using match/index formulas to return the values I want.
My question is how to take the Model# I have found at the bottom right and organize them so they are at the top with no empty cells above.
Thanks
The following is how my sheet looks:
and I am using match/index formulas to return the values I want.
My question is how to take the Model# I have found at the bottom right and organize them so they are at the top with no empty cells above.
Thanks