Making a column of numbers created from a formula permanent.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database of participants in an annual event, who need to be
categorized by age. I have added to coumns past the age, one is all 1, the
last is the formula =B2+C2=D2
where B2 is the age last year
C2=1
D2 is the age for this year.

I would like to eliminate the first two columns after the third is
completed, but this eliminates the results - is there any way to make those
numbers permanent as is?
 
I did figure out the copy and paste special - value and number formats....
thanks....
 
You must log in or register to reply here.

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

Date Formula 85 factor 7
Copying formulas across columns 2
Copy last entry of column to bottom of column 3
NETWORKDAYS Formula 1
More Planned and Actual Cycle Times 5
Ratio - How To Create Your Own Function/Formula 2
Excel formula calculating age 4
how do I create a nonadjacent series for autofill to go by? 3

Back
Top