PC Review


Reply
Thread Tools Rate Thread

List Formula

 
 
mkd
Guest
Posts: n/a
 
      31st Jul 2012
I have a problem with excel.
For example, I have a generic list like this:

3,40
2,05
#N/D
#N/D
#N/D
-1,5
#N/D
2,30

I would like (NOT VBA!) that excel give me a list without #N/D, in the
following form

3,40
2,05
-1,5
2,30

without spaces...
Which formula can I use?

Thanks.
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Compare List A to List B, Return List B Items Not in List A zwestbrook Microsoft Excel Programming 4 18th Sep 2008 10:32 PM
Replace formula with IF(error(formula;"";formula) =?Utf-8?B?bGVjYWJhbGxlcm8=?= Microsoft Excel Programming 1 2nd Nov 2005 12:46 PM
How can I add a new formula to Excel formula list =?Utf-8?B?RGFyYWZzaA==?= Microsoft Excel Worksheet Functions 1 4th Oct 2005 05:56 PM
find names on list 1 in list 2. list 1 4000 names list 2 400 name =?Utf-8?B?RWQ=?= Microsoft Excel Worksheet Functions 1 4th Sep 2005 12:48 AM
Commenting custom formula fields/formula on formula editor Muxer Microsoft Excel Programming 2 24th Jul 2003 01:02 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:17 AM.