If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
After IF formulae - how to extract results into other sheet?
HI,
I have applied a IF statement to Colun H with results in Column I, (thanks to this group on showing me how) BUt now I would like to condense the results in Column I to a seperate sheet all together without all the spaces that are in the I after the IF statement was applied. Thanks for the extra help. Mike |
#2
|
|||
|
|||
After IF formulae - how to extract results into other sheet?
Checkout:
http://www.cpearson.com/excel/noblanks.htm -- Gary''s Student - gsnu200841 "MikeR-Oz" wrote: HI, I have applied a IF statement to Colun H with results in Column I, (thanks to this group on showing me how) BUt now I would like to condense the results in Column I to a seperate sheet all together without all the spaces that are in the I after the IF statement was applied. Thanks for the extra help. Mike |
#3
|
|||
|
|||
After IF formulae - how to extract results into other sheet?
HI Gary's Student, I have ahd a quick look at the link.
I need the detail from across the other columns (to theleft) of what has been placed in the last column based on the IF statement. So it seems to me the array as it shifts the findings up to eliminate spaces would not work. Is my assumption correct as I need the detail in the columns A - ..up to the IF column? Mike "Gary''s Student" wrote: Checkout: http://www.cpearson.com/excel/noblanks.htm -- Gary''s Student - gsnu200841 "MikeR-Oz" wrote: HI, I have applied a IF statement to Colun H with results in Column I, (thanks to this group on showing me how) BUt now I would like to condense the results in Column I to a seperate sheet all together without all the spaces that are in the I after the IF statement was applied. Thanks for the extra help. Mike |
#4
|
|||
|
|||
After IF formulae - how to extract results into other sheet?
Dear Mike
Is this what you are looking for..Sheet1 Column I contain your values. You want to populate the values without spaces to another sheet . Let us say Sheet2 Col A To remove the spaces before and after use this in Cell A1 =Trim(Sheet1!I1) To remove the spaces inbetween the cells use this in Cell A1 =SUBSTITUTE(Sheet1!I1," ","") If this post helps click Yes --------------- Jacob Skaria "MikeR-Oz" wrote: HI Gary's Student, I have ahd a quick look at the link. I need the detail from across the other columns (to theleft) of what has been placed in the last column based on the IF statement. So it seems to me the array as it shifts the findings up to eliminate spaces would not work. Is my assumption correct as I need the detail in the columns A - ..up to the IF column? Mike "Gary''s Student" wrote: Checkout: http://www.cpearson.com/excel/noblanks.htm -- Gary''s Student - gsnu200841 "MikeR-Oz" wrote: HI, I have applied a IF statement to Colun H with results in Column I, (thanks to this group on showing me how) BUt now I would like to condense the results in Column I to a seperate sheet all together without all the spaces that are in the I after the IF statement was applied. Thanks for the extra help. Mike |
#5
|
|||
|
|||
After IF formulae - how to extract results into other sheet?
Jacob, I musrt have something wrong.
To explain. I have data that fills Columns A thru H. i then applied a IF statement to the data to extract data from H that was only above a certain level i.e numbers above 10. This info went into Column I. I want to bring the data pertaining to only the 'I' column and assoaciated rows back to column A on a seperate sheet all together. There is 2000 records and the IF statement has many blanks with only say 50 entries fitting the IF statment so I fugured if I could get this data onto a single sheet it would make it easier and more meaningful. Mike "Jacob Skaria" wrote: Dear Mike Is this what you are looking for..Sheet1 Column I contain your values. You want to populate the values without spaces to another sheet . Let us say Sheet2 Col A To remove the spaces before and after use this in Cell A1 =Trim(Sheet1!I1) To remove the spaces inbetween the cells use this in Cell A1 =SUBSTITUTE(Sheet1!I1," ","") If this post helps click Yes --------------- Jacob Skaria "MikeR-Oz" wrote: HI Gary's Student, I have ahd a quick look at the link. I need the detail from across the other columns (to theleft) of what has been placed in the last column based on the IF statement. So it seems to me the array as it shifts the findings up to eliminate spaces would not work. Is my assumption correct as I need the detail in the columns A - ..up to the IF column? Mike "Gary''s Student" wrote: Checkout: http://www.cpearson.com/excel/noblanks.htm -- Gary''s Student - gsnu200841 "MikeR-Oz" wrote: HI, I have applied a IF statement to Colun H with results in Column I, (thanks to this group on showing me how) BUt now I would like to condense the results in Column I to a seperate sheet all together without all the spaces that are in the I after the IF statement was applied. Thanks for the extra help. Mike |
Thread Tools | |
Display Modes | |
|
|