+ Reply to Thread
Results 1 to 2 of 2

i want required vba. I am looking for a small value from the Range

  1. #1
    Forum Contributor
    Join Date
    09-14-2012
    Location
    mumbai,india
    MS-Off Ver
    Excel 2003
    Posts
    367

    i want required vba. I am looking for a small value from the Range

    Value Range Requirement
    25.000 1750.000 17.000
    17.000 1750.000 17.000
    33.000 1750.000 17.000
    18.000 1750.000 17.000
    33.000 1750.000 17.000
    47.000 1750.000 17.000
    66.000 1750.000 17.000
    21.000 1750.000 17.000
    41.000 1750.000 17.000
    98.000 3500.000 5.000
    45.000 3500.000 5.000
    70.000 3500.000 5.000
    5.000 3500.000 5.000
    53.000 3500.000 5.000
    55.000 3500.000 5.000
    47.000 3500.000 5.000
    12.000 3500.000 5.000
    15.000 5250.000 14.000
    66.000 5250.000 14.000
    14.000 5250.000 14.000
    45.000 5250.000 14.000
    68.000 5250.000 14.000
    21.000 5250.000 14.000
    75.000 5250.000 14.000
    77.000 5250.000 14.000
    89.000 5250.000 14.000
    17.000 5250.000 14.000


    Need VBA Codes. Ex.Test(A2,B2)
    I am looking for a small value between Range
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: i want required vba. I am looking for a small value from the Range

    Use a pivot table for that kind of work.

    choose Range for rows

    choose min for values for values
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Macro modification required (very small)
    By nur2544 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-21-2012, 01:34 PM
  2. SUMPRODUCT - small correction required
    By Madiya in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-10-2006, 06:55 AM
  3. [SOLVED] to group in small range, and count
    By Carolina in forum Excel General
    Replies: 1
    Last Post: 12-04-2005, 10:10 PM
  4. Excel VBA expert required! Small to medium job.
    By Sonny in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-22-2005, 07:05 PM
  5. Paste Small Range into Big Range
    By tim in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-03-2005, 03:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1