+ Reply to Thread
Results 1 to 5 of 5

finding the minum rows name

  1. #1
    Registered User
    Join Date
    04-14-2005
    Posts
    4

    finding the minum rows name

    hello..

    i have problem i want to find the row name where the minumum number is found

    i have row
    A B C D E F G H ...............................
    1 32 32 32 8748 6 5 32 13 54 65 78 989 21

    i wanted to take the the row name which contains the minumum number.

    for example in thişs example 'A'

    can anybody help me...
    Last edited by hasimturker; 04-14-2005 at 09:23 AM.

  2. #2
    Registered User
    Join Date
    02-25-2005
    Posts
    84
    Do you mean find the column name ??

    I would put in A2, and fill across to column M (or however many you need):-

    =if(A1=min($A$1:$M$1),col(),"")

    In row 2, a number will a appear in 1 cell only, that number is the numerical representation of the column 'number', ie A=1 , B=2 etc.

  3. #3
    Registered User
    Join Date
    04-14-2005
    Posts
    4
    like this in here i make this for a 25 rows
    Attached Images Attached Images

  4. #4
    Registered User
    Join Date
    02-25-2005
    Posts
    84
    Again, I'm guessing you mean 25 columns, A to Y, not 25 rows ??

    OK, seeing you have so many, it cant be done with a nested IF formula, that only allows 7, unless you had 4 hidden columns, each with a messy formula.

    No, I would guess that you'd have to write a macro to do it.

  5. #5
    Registered User
    Join Date
    04-14-2005
    Posts
    4
    can you show me the solution

+ Reply to Thread

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