Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Excel Function Help!!!???

Options
  • 16-05-2008 1:15pm
    #1
    FastFonz
    Closed Accounts Posts: 27 ✭


    Im pretty handy with Excel and use it everyday, but for the life of me i cant create a suitable formula to express what i want!

    Basically this is the layout of the sheet in question:

    Column A: Long list of products
    Column Y: A numerical value based on the product in the same row

    I want to make a formula that tests the numerical value(ie. >8.5) and if it meets the condition, i want it to copy the value in Column Y(Number) and its related test in Column A to a new sheet...

    I used an IF and Lookup function to do this much, and it worked fine..However i only want the values that meet the condition to be copied, i dont want the other values to show up at all on the new sheet(they show up as blank spaces with IF/Lookup)

    Any help would be greatly appreciated!!!


Comments

  • Options
    #2
    sirpsycho
    Registered Users Posts: 876 ✭✭✭sirpsycho


    Sounds like a simple IF and vlookup.


  • Options
    #3
    EL_Loco
    Registered Users Posts: 901 ✭✭✭EL_Loco


    trying sorting the results. the blank fields should go to the bottom?


  • Options
    #4
    cyberbob
    Closed Accounts Posts: 82 ✭✭cyberbob


    you could code up an array function (not all that practical )

    or

    apply a filter

    or

    write a macro to copy and paste the appropriate rows into the new sheet...


    which ever is appropriate for your scenario..


Advertisement