Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Oct 2003
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Offset Formula (Excel 2000)

    Hi, I have a list with the headings MONTH, NAME, AMOUNT starting at row 5. I apply a filter to extract monthly data before printing. Is there a formular that I can have that will return the top name of my filtered list. I'm trying to filter my list for the name "Smith", and have "Smith" automatically inserted in cell B2 after I've applied my filter. Any assistance would be appreciated.

    Regards Cliff

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Offset Formula (Excel 2000)

    See John Walkenbach's site. He has a function from Stephen Bullen for displaying the Autofilter criteria.

    Steve

  3. #3
    2 Star Lounger
    Join Date
    Sep 2003
    Location
    Louisville, Kentucky, USA
    Posts
    134
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Offset Formula (Excel 2000)

    I've never worked with Autofilters in VBA so I've never seen those objects, properties, or methods, but that function is way cool. <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>

  4. #4
    New Lounger
    Join Date
    Oct 2003
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Offset Formula (Excel 2000)

    Thanks for ther link Steve, looks like what I'm after.
    Cheers, Cliff

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •