Tech Support Guy banner
Status
Not open for further replies.
1 - 2 of 2 Posts

·
Registered
Joined
·
253 Posts
Discussion Starter · #1 ·
I have Excel 2002. On sheet 1 in column A are reference numbers and in column K the word “complete” is entered when a job is finalised. The columns are long (over 300 rows) and the word “complete” occurs infrequently. So far, I have been using a formula to show the data in A and K in Sheet 2. This leaves many blank cells, so I then sort Z-A to collect the data together at the top of the page ready for the printout.

Is there any way of getting Sheet 2 to ignore the blank cells and assemble all the data at the top of the page automatically?
 

·
Registered
Joined
·
253 Posts
Discussion Starter · #2 ·
there are two solutions, one using an array and the other (simpler) using a filter.

For the filter, highlight the column, go to then <Autofilter> then <nonblanks>
 
1 - 2 of 2 Posts
Status
Not open for further replies.
Top