Results 1 to 6 of 6

Thread: Urgent HELP needed in a formula !!

  1. #1

    Urgent HELP needed in a formula !!



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

    I have a project that i'm working on at work but i cant seem to get it working right.

    I'v got 9 values (BLUE) that will be filled by the "program user", it will contain 1 to 3 unique values.

    I want these 1 to 3 unique values to be called up in 3 new cells (RED) in order (smaller to bigger).

    What is the equation to write in these 3 cells??

    V1 V2 V3 V4 V5 V6 V7 V8 V9 Unique 1 Unique 2 Unique 3
    a b c c a b b a a a b c


  2. #2
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    769
    Articles
    0
    Excel Version
    2010
    Hello
    Just to clarify, am I correct in thinking that each user operation has a choice of 3 different values only, which they will enter into 9 cells?
    Will they always fill in all 9 ?
    Will the unique values be different each time?

  3. #3
    3 deffrent values in 9 cells
    Not necessarily 9 filled cells might be only one cell

    I'll give u the exact setuation
    Im a civil engineer and i work with concrete pouring .. so

    Each raw is for a structural elemnt and it could go on through 3 shift and it could be poured with 3 deffrent concrete classes

    So 3 shifts by 3 classes =9 cells

    I want 3 cells to have the 1- 3 unique concrete classes that casted in that element

    Thank you 😊

  4. #4
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    769
    Articles
    0
    Excel Version
    2010
    Quote Originally Posted by majoood85 View Post
    3 deffrent values in 9 cells
    Not necessarily 9 filled cells might be only one cell

    I'll give u the exact setuation
    Im a civil engineer and i work with concrete pouring .. so

    Each raw is for a structural elemnt and it could go on through 3 shift and it could be poured with 3 deffrent concrete classes

    So 3 shifts by 3 classes =9 cells

    I want 3 cells to have the 1- 3 unique concrete classes that casted in that element

    Thank you 
    Not sure I fully understand, but Sheet1 of the attachment has the numbers 11, 32 and 39 entered in Cell A1 to I1. Cells J1 contains a formula that finds the smallest number in the nine cells to the left. Cells K1 and L1 each contain a matrix formula that finds the next two smallest unique numbers.

    When you copy or amend the matrix formulae remember to confirm with Ctrl + Shift + Enter, not just Enter. Just Enter will be fine with the J1 formula.
    Attached Files Attached Files

  5. #5
    Thank you man that's exactly what i needed

    works pretty well

  6. #6
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    769
    Articles
    0
    Excel Version
    2010
    Pleased to be of help, and thanks for letting me know.

Posting Permissions

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