It never fails to amaze me what Excel can do - however, I'm still a novice!
There are lots of similar threads on the www, but I haven't been able to find exactly what I need.
I have a large data table (20+columns, 500+ rows) of data.
In one column (column C in the attached example), there may be some blank cells.
I want to use a formula (trying to avoid VBA - a dark art...) to copy onto another sheet, only those rows where there is a value (always a number) in column C.
As usual, this is part of a larger project. I've got all the fancy data analysis at the end of the process all sorted out, but I'm struggling to get the valid dataset arranged. Can you help??
Bookmarks