LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
matt
 
Posts: n/a
Default 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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
look up one value that can list multiple corresponding values Stephanie A., STL Excel Discussion (Misc queries) 0 August 3rd 05 04:32 PM
How to obtail a list of all Variables with values in halted proced Dennis Excel Discussion (Misc queries) 2 August 1st 05 10:15 PM
VBA to set AutoFilter to List all rows with same values in column? Dennis Excel Discussion (Misc queries) 2 June 24th 05 12:37 AM
Select values from list Bepi Excel Discussion (Misc queries) 2 June 21st 05 11:07 AM
Missing values in Excel Line Chart mw55309 Charts and Charting in Excel 1 January 19th 05 12:10 PM


All times are GMT +1. The time now is 02:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"