Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

Excel Function Help!!!???

  • 16-05-2008 01: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

  • #2
    sirpsycho
    Registered Users, Registered Users 2 Posts: 883 ✭✭✭sirpsycho


    Sounds like a simple IF and vlookup.


  • #3
    EL_Loco
    Registered Users, Registered Users 2 Posts: 901 ✭✭✭EL_Loco


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


  • #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