F
Fie
Hi,
Hi,
What i wanted to do was the followen :
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.
I was given the answer:
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.
This works fantastically but my only problem is that I have 4000
records, 800 of them being true is there anyway in which I can then
pick out all the "Trues" from the "Falses" as the properties marked
"true" are to be used to conduct a survey.
Fiona
Hi,
What i wanted to do was the followen :
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.
I was given the answer:
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.
This works fantastically but my only problem is that I have 4000
records, 800 of them being true is there anyway in which I can then
pick out all the "Trues" from the "Falses" as the properties marked
"true" are to be used to conduct a survey.
Fiona