How do you quary a column of data?

[Paul Grgurich]

I am sure this is easy but here we go.

If I have a column of data - in this case the age of a series o
industrial buildings - they can be anywhere from 0 years to 100 year
of age.

I want to query this info so that i generate a new column whereb
buildings of 0-5 years old generate a 0, 5-10 years old generate a 1
10-15 years old generate a 2 etc etc.

Can anyone help me

Regard

 

[Nick Hodge]

Paul

In a new column, (where column B has the age of the building), enter the
formula

=CEILING(B1/5,1)-1

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[Jamie Collins]

Paul Grgurich wrote ...

If I have a column of data - in this case the age of a series of
industrial buildings - they can be anywhere from 0 years to 100 years
of age.

I want to query this info so that i generate a new column whereby
buildings of 0-5 years old generate a 0, 5-10 years old generate a 1,
10-15 years old generate a 2 etc etc.

Sorry to be pedantic but according to your spec a five year old
building falls into both the 0-5 years old and 5-10 years old groups.
It's this kind of error that can result in buildings falling over <g>.

Jamie.

--