How do you quary a column of data?

  • Thread starter Thread starter Paul Grgurich
  • Start date Start date
P

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
 
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)
 
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.
Click to expand...

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.

--
 
Back
Top