Importing Stock data into new cell, only on Positive Condition

[Mike Slattery]

Column has dates in first cell, only when conditions in other cells are met.

I want to produce a condensed Column of this data, in a new Column that eliminates all rows of data without the dates, with no blank spaces, meaning that the cells where the conditions were not met are eliminated from the columns and rows of data?

I have accomplished limited success by sorting the field but the only way I can get the correct order puts the target data at the bottom the sorted columns. I would then need another condition to determine where this condensed target data starts.

Hope this is not clear as mud ;√)

I am obvious trying to get around a Macro.

Any ideas?

Thanks Michael

 

[Drrellik]

without VBA you can try something like this. in columnA on new sheet =if(oldsheet!A1<>"",oldsheet!A1,"") and copy down for as much as you need. then in B1 = iferror(vlookup($A1,oldsheet!$A$1:$E$20,2,"") and drag across to E or as far as you need changing the range E20 to match what you need. once you drag right and edit each formula to look at the next column in the range by changing ,2 to ,3 and ,4 and ,5 and so on. then you will be able to select the row from B1 to ?? and drag down. then new sheet will populate based on those cells with a date in them and then do a sort on only column A of the new sheet.

 

[Mike Slattery]

Hello Drrellik:

Christmas has interfered with the really important stuff, I will try your solution this evening,

thanks for your assistance,

Michael

 

[Mike Slattery]

Hi Drrellik:

I really don't want this to be in a new sheet. Is there a way around that element in your solution.

Thanks, Michael

 

[Mike Slattery]

Hi Drrellik:

I really don't want this to be in a new sheet. Is there a way around that element in your solution.

Thanks, Michael

If I am using this in a new sheet the only information on this sheet is the two formulas you provided. Nothing to drag and capture in the second formula.

I have little doubt that there is something fundamental that I am missing in you original post, My fault not your.

Thanks Michael