one other quick question, is there another way to copy the b2 equation
down the list other than dragging it? It's a very long spreadsheet,

2 ways
1. If there's no in-between blank cells in col A, just double click on the
fill handle
2. Type the range in the namebox*, eg, type: B2:B10000
Press ENTER, this selects the range with B2 active
Paste the formula into the formula bar,
then just press CTRL+ENTER
*the dropdown just to the left of the formula bar
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---