News1 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
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.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.