Ooooo SHARE!!!

Umm not sure if this will make sense but if you use =ABS(K10) you can make a negative number

from another cell show up as positive in the cell you want

"ABS" stands for "absolute value"

so it grabs a positive # in one cell and makes it a negative in another? Dont worry, im an excel freak, i love new formulas

errr i meant negative into a positive

It takes a number that is either positive or negative, and outputs a positive

ooooo, very handy

yeah it really is but I don't use excel much so I'm easily impressed

data sorting still gets me excited

one day I'll learn v look ups and rule the world

once you get v look ups down, you can rule the galaxy!

vlookups are not hard. I could talk you through them if you want

Ooh the galaxy? Sign me up!

thanks for the offer antimony. I've actually got a whole office of people to help. I just haven't had a burning need yet.

she could reverse engineer vlookups. I would have had them down already.