Importing Stock data into new cell, only on Positive Condition

Mike Slattery

Board Regular
Joined
Dec 11, 2004
Messages
101
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

Well-known Member
Joined
Apr 29, 2013
Messages
738
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

Board Regular
Joined
Dec 11, 2004
Messages
101
Hello Drrellik:

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

thanks for your assistance,

Michael
 

Mike Slattery

Board Regular
Joined
Dec 11, 2004
Messages
101
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

Board Regular
Joined
Dec 11, 2004
Messages
101
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
 

Forum statistics

Threads
1,081,680
Messages
5,360,503
Members
400,590
Latest member
Mikealphatangoc

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top