Looking up date for values

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Fie - 31 Oct 2006 12:19 GMT

Hi,

Please can someone advise me on how to do the following:

I have an excel spreadsheet which has the following columns

Name Address Town Postcode

What I require is some way that allows the user to choose a town (Towns
are Buckie, Elgin, Forres, Lossie etc) and then form the list of
properties corresponding to that town every 5th property in the list to
be displayed.

Fiona

Reply to this Message

Ken Wright - 31 Oct 2006 13:49 GMT

Assuming your data is sorted on Town, and that the header for Town is in say
cell C1, add a column to the end of your data (Assume Col E and labelled
"VIEW"), and in say E2 use a formula such as =MOD(COUNTIF($C$2:$C2,C2),5)=0
and copy down as far as necessary.

Now use Data / Filter / Autofilter and filter on Town View for Town and
"TRUE" respectively.

Signature

Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------
It's easier to beg forgiveness than ask permission :-)

> Hi,
>
[quoted text clipped - 10 lines]
>
> Fiona

Reply to this Message

Rate this thread: