If..then..Lookup?
J.E.
Thank you soooo much! First formula worked like a charm. I'm getting a #ref error on the second one, but I'll play with it some to figure out why :
I started this gradesheet to make my life and the lives of my faculty easier, but it seems the simple stuff I want to do aren't so simple. I've gained a whole new repect for programmers after tackling this little project
Have a happy holiday.
|