Results 1 to 2 of 2

Thread: Urgent Help

  1. #1

    Urgent Help

    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have a list of 100 values (prices in figures) in a single column. in next column i have their code names. i want that for each value, anyother value which is within 10 dollar range, less and more, their codes should show up in third column. E.G
    2000 A D,B
    2009 B A,G
    2020 C G
    1993 D A
    4000 E
    700 F
    2015 G B,C

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Excel Version
    A very convoluted solution using only built-in worksheet formulae is in the attached alongside an easy to use user-defined function.
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts