Home |
Search |
Today's Posts |
#1
|
|||
|
|||
remove errors
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. |
#2
|
|||
|
|||
remove errors
In C1 =IF(ISERROR(B1),"",B1) and copy across.
This will substitute a blank for an error. -- Gary's Student "TUNGANA KURMA RAJU" wrote: 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. |
#3
|
|||
|
|||
remove errors
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'. "Gary''s Student" wrote: In C1 =IF(ISERROR(B1),"",B1) and copy across. This will substitute a blank for an error. -- Gary's Student "TUNGANA KURMA RAJU" wrote: 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. |
#4
|
|||
|
|||
remove errors
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. -- Gary''s Student "TUNGANA KURMA RAJU" wrote: 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'. "Gary''s Student" wrote: In C1 =IF(ISERROR(B1),"",B1) and copy across. This will substitute a blank for an error. -- Gary's Student "TUNGANA KURMA RAJU" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
remove last three characters of cell | Excel Discussion (Misc queries) | |||
Remove link fr a column of entries | Excel Discussion (Misc queries) | |||
Remove link fr a column of entries | Excel Discussion (Misc queries) | |||
Remove link fr a column of entries | Excel Discussion (Misc queries) | |||
Unresolved Errors in IF Statements - Errors do not show in results | Excel Worksheet Functions |