Home |
Search |
Today's Posts |
#1
|
|||
|
|||
list missing values in a sequence
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. |
#2
|
|||
|
|||
Copy the data elsewhere. Sort the copied data by data1 and data2 ascending.
All your missing data will float to the top. -- Gary''s Student "matt" wrote: 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. |
#3
|
|||
|
|||
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. "Gary''s Student" wrote: Copy the data elsewhere. Sort the copied data by data1 and data2 ascending. All your missing data will float to the top. -- Gary''s Student "matt" wrote: 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. |
#4
|
|||
|
|||
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. matt wrote: 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. "Gary''s Student" wrote: Copy the data elsewhere. Sort the copied data by data1 and data2 ascending. All your missing data will float to the top. -- Gary''s Student "matt" wrote: 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. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
look up one value that can list multiple corresponding values | Excel Discussion (Misc queries) | |||
How to obtail a list of all Variables with values in halted proced | Excel Discussion (Misc queries) | |||
VBA to set AutoFilter to List all rows with same values in column? | Excel Discussion (Misc queries) | |||
Select values from list | Excel Discussion (Misc queries) | |||
Missing values in Excel Line Chart | Charts and Charting in Excel |