Hi Guys,
can you please help me how to use the "Skip Blanks" effectively on a worksheet ?
Hi Guys,
can you please help me how to use the "Skip Blanks" effectively on a worksheet ?
Hi,
I assume you're wanting to extract a range of contiguous cell values to another position from a list which contains blank cells.
In which case Filter the list and exclude the blanks, copy the filtered range and then use Paste Special and tick the 'Skip Blanks' option.
Rgds
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks