I Wonder Why This Number Is Rising So...
Politics0 min ago
Excel Move Up Cells Function
2 Answers
I have located the useful LOOKUP and MATCH functions
That create a list in my worksheet by looking up the category
of a cell in another sheet, then inserting the corresponding item.
But the column has empty cells (where there is no relevant item
in the source column).
Is there a formula to make Excel delete empty cells and move cells below
up, I.e. to make a continuous list with no gaps. I could do it manually but
I'm hoping to find something like 'if no ref then delete contents of this cell
and move cells below up one row'.
Sorry this is a bit convoluted I know!
That create a list in my worksheet by looking up the category
of a cell in another sheet, then inserting the corresponding item.
But the column has empty cells (where there is no relevant item
in the source column).
Is there a formula to make Excel delete empty cells and move cells below
up, I.e. to make a continuous list with no gaps. I could do it manually but
I'm hoping to find something like 'if no ref then delete contents of this cell
and move cells below up one row'.
Sorry this is a bit convoluted I know!
Answers
1 to 2 of 2
Best Answer
No best answer has yet been selected by Barquentine. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.1 to 2 of 2
Related Questions
Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.