remove errors

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

one of my row output contains some output values and some erros.I want to
consolidate that row values without error values.I used iserror function but
results are more are less same output values and blank value and output
vales.To get in another row only output values whats the formula.suppose
b1:b6 range contains
data1,error,data2,error,error,data3,Iwant in another row serially in c1:c3
data1,data2,data3.
 
your formula gave me wrong result-data,blank,data,blank,blank,data.This is
not I want.please see my question.I want data,data,data rest should be
completely blank, even if I query in c4 isblank(c4) it should give result
'true'.
 
You want to basically filter out the bad results, not just make blanks out of
them. If your data was in a column, then a filter could be applied. I don't
know how to do this for a row without using VBA.


I will post a new question in the worksheet function area to see if anybody
knows.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Removing empty cells from spreadsheet data 1
How to convert........ 8
Automating references to tabs in formulas 4
Comparison of columns using Conditional Formatting 3
Copy paste from one worksheet to other. 2
Create Excel Spreadsheet from Access with 1 to many relationship 2
Ending Procedure When Condition is Met Anywhere in Procedure 2
Search CSV for string. 5

Back
Top