Looking up date for values

[Fie]

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

 

[Ken Wright]

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.