Results 1 to 5 of 5

Use one column for function and return a value of another?

Threaded View

  1. #1
    Registered User
    Join Date
    04-14-2007
    Location
    Phoenix AZ
    Posts
    32

    Use one column for function and return a value of another?

    I'm really new to Excel, and don't have even a basic grasp yet. So please forgive me if I can't even phrase the question right.

    I'm trying to make a lottery spreadsheet so I can analyze the numbers in a simple way......

    What I'm trying to do here is to select the min number picked but I want to return the actual number not the number of times it was picked.


    =MIN(U1:U35) here's the function I used to find the smallest number in this column, but I want to display the number from column "N" as a return....

    See image below>


    http://server6.theimagehosting.com/i...Hunter_008.jpg
    Last edited by farmerTom; 04-14-2007 at 11:21 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