Looking up date for values

  • Thread starter Thread starter Fie
  • Start date Start date
F

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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting values 1
Picking out thr 5th value 2
replace vbCrLf with , 3
Create Database Type Lookup In Excel 4
Comparing contents of two spreadsheets and outputting results to a 5
Simple problem, simple answer? 6
Repost - Forms Fill Fields automatically on form based on a control's value 5
Fill Fields automatically on form based on a control's value 1

Back
Top