list missing values in a sequence

[Guest]

I've got a list of data with some values missing. Is there a way that I can
leave the data unaltered, while listing which values are missing from each
column?

So if my data looks like this:

<header> <data 1> <data 2<
1 .5 .6
2 .4
3
4 .6 .2

my list will have
data 1 data 2
2 3
3

Any help would be greatly appreciated.

 

[Guest]

Copy the data elsewhere. Sort the copied data by data1 and data2 ascending.
All your missing data will float to the top.

 

[Guest]

That works. Thanks.

But is there any way to automate this. The rest of my process is automated
into a macro, and it would be best if I could include this there. The missing
values will be different for each set of data.

Any help would be greatly appreciated.

 

[Dave Peterson]

Maybe you could just apply Data|Filter|autofilter to your range.

Then use the dropdown (for each column) to show just the blanks.

Then data|filter|show all
then filter by the next column.