Prev: Regular Workbooks vs. Binary Workbooks
Next: HOW DO YOU ALPHABETIZE A LIST OF NAMES IN AN EXCELL SPREADSHEET?
From: LP on 27 Apr 2010 18:10
Without going into VB, is there a way to display the chosen autofilter
value?

Column D1 is where I want to filter is located and it has 200 rows.
Thanks.
From: Dave Peterson on 27 Apr 2010 20:00
Nope. You'll need VBA.

LP wrote:
>
> Without going into VB, is there a way to display the chosen autofilter
> value?
>
> Column D1 is where I want to filter is located and it has 200 rows.
> Thanks.

--

Dave Peterson
From: T. Valko on 27 Apr 2010 20:20
If they mean to return the first item from a filtered list...

Array entered** :

=INDEX(D2:D15,MATCH(1,SUBTOTAL(3,OFFSET(D2:D15,,,ROW(D2:D15)-ROW(D2)+1)),0))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.

That will return the first item from the filtered (or unfiltered) range
D2:D15.

--
Biff
Microsoft Excel MVP


"Dave Peterson" <petersod(a)verizonXSPAM.net> wrote in message
news:4BD77A82.29A8A160(a)verizonXSPAM.net...
> Nope. You'll need VBA.
>
> LP wrote:
>>
>> Without going into VB, is there a way to display the chosen autofilter
>> value?
>>
>> Column D1 is where I want to filter is located and it has 200 rows.
>> Thanks.
>
> --
>
> Dave Peterson


From: ozgrid.com on 27 Apr 2010 20:21
No, you need a Custom Function
http://www.ozgrid.com/VBA/autofilter-criteria.htm



--
Regards
Dave Hawley
www.ozgrid.com
"LP" <u208839(a)gmail.com> wrote in message
news:551ec7d7-5e94-462b-8053-3e64a204fe57(a)h37g2000pra.googlegroups.com...
> Without going into VB, is there a way to display the chosen autofilter
> value?
>
> Column D1 is where I want to filter is located and it has 200 rows.
> Thanks.

From: Dave Peterson on 27 Apr 2010 20:35
Unless the user is showing blank cells and those cells are really empty <vbg>.

Seriously, Biff's formula won't show you the criteria unless it's pretty
simple. All those contains, greater than, does not... would return a value, but
maybe not what you're looking for.



"T. Valko" wrote:
>
> If they mean to return the first item from a filtered list...
>
> Array entered** :
>
> =INDEX(D2:D15,MATCH(1,SUBTOTAL(3,OFFSET(D2:D15,,,ROW(D2:D15)-ROW(D2)+1)),0))
>
> ** array formulas need to be entered using the key combination of
> CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
> key then hit ENTER.
>
> That will return the first item from the filtered (or unfiltered) range
> D2:D15.
>
> --
> Biff
> Microsoft Excel MVP
>
> "Dave Peterson" <petersod(a)verizonXSPAM.net> wrote in message
> news:4BD77A82.29A8A160(a)verizonXSPAM.net...
> > Nope. You'll need VBA.
> >
> > LP wrote:
> >>
> >> Without going into VB, is there a way to display the chosen autofilter
> >> value?
> >>
> >> Column D1 is where I want to filter is located and it has 200 rows.
> >> Thanks.
> >
> > --
> >
> > Dave Peterson

--

Dave Peterson
 |  Next  |  Last
Pages: 1 2
Prev: Regular Workbooks vs. Binary Workbooks
Next: HOW DO YOU ALPHABETIZE A LIST OF NAMES IN AN EXCELL SPREADSHEET?