Results 1 to 2 of 2

Min formula for non adjacent cells >0

Threaded View

  1. #1
    Registered User
    Join Date
    08-06-2008
    Location
    LONDON
    Posts
    10

    Min formula for non adjacent cells >0

    Hi,

    I need a formula that will test every 4th cell in a row to see if it is >0 and then returns the minimum value of the cells which are >0

    eg:

    A1 B1 C1 D1 E1 F1 G1 ..... Formula Result
    0 20 10 30 3 5 60 =30

    therefore only test A1, D1,G1 >0 then apply min to D1 and G1 (since A1 = 0 exclude)

    YEEEELLP !
    Last edited by VBA Noob; 08-06-2008 at 03:17 AM.

Thread Information

Users Browsing this Thread

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

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