Results 1 to 3 of 3

Cell Referencing Using Min

Threaded View

  1. #1
    Registered User
    Join Date
    11-30-2010
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    13

    Cell Referencing Using Min

    Hi,

    Is there any way I can use the Min function within the data on the right, to reference the minimum score for each team per hole from the data on the left. I have done one example contained in cells R3:Z3 but would prefer a better method to which will allow me to drag the formula down through the rows once created. My current method would mean manually changing the references for the rows proceeding which will be time consuming. I tried to use the Indirect function with a value located in a cell on the same row but couldn't figure out how to combine this with the Min function.

    I hope that makes sense once you have looked at the spreadsheet.

    Many thanks,
    Sunil.
    Attached Files Attached Files
    Last edited by sun815613; 03-03-2011 at 03:45 PM.

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