Results 1 to 7 of 7

sort variable length column for min value--number of rows is variable

Threaded View

dloe sort variable length column... 04-13-2012, 03:10 PM
Marcol Re: sort variable length... 04-13-2012, 03:16 PM
protonLeah Re: sort variable length... 04-13-2012, 03:18 PM
dloe Re: sort variable length... 04-13-2012, 04:22 PM
Marcol Re: sort variable length... 04-13-2012, 08:25 PM
dloe Re: sort variable length... 04-13-2012, 09:37 PM
Marcol Re: sort variable length... 04-14-2012, 04:07 AM
  1. #7
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,216

    Re: sort variable length column for min value--number of rows is variable

    Why not post a sample of your workbook as an attachment? It makes life easier all round.

    Try this example workbook.

    With your data in Column B as shown.
    In A1
    =IF(ROW()=1,1,IF(B1="TOT",ROW(),""))
    Drag/Fill Down as required

    In C2
    =IF(B2="TOT",MIN(INDEX(B:B,MAX($A$1:$A1)):INDEX(B:B,ROW())),"")
    Drag/Fill Down as required.

    The helper, Column A, can be hidden, or use a grouping button as in this example.

    Note the conditional formatting in Columns B & C.
    Attached Files Attached Files

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