none
How can I find next small value(look up value) in a range? RRS feed

  • 질문

  •                    

    I like to find a small value for look up value in a range, then use a next small value for next look up value and so on...

    I don't know how to find..

    please help me..

    Thank you!!

                do untill (find a name)       

                        small = Application.WorksheetFunction.Min(rng)

                       how can I find next small one?

                        ingrow = Application.WorksheetFunction.Match(small, rng, 0)

                        name = rng.Cells(ingrow, -13).Value


                        ss = Application.WorksheetFunction.VLookup(name, Range("sc"), i, 0)
                        sy = Application.WorksheetFunction.VLookup(name, Range("sc"), i + 1, 0)



                    If Worksheets("aa").Range("bb").Cells(y, x - 1) > 0 And _
                       ss = "S" And sy = "S" Then

                        Worksheets("aa").Range("bb").Cells(y, x) = name
                        Worksheets("cc").Cells(ingrow, 16) = Worksheets("cc").Cells(ingrow, 16) + 1


                    Else

                      find a next small value to find a name to use for lookup value..

          loop

                    Thank you again..                                                                                        
    • 편집됨 jjuunn 2018년 5월 20일 일요일 오전 8:17
    2018년 5월 19일 토요일 오후 11:52

모든 응답