okay found my error...was a circular reference i was having trouble tracking..right in front of my eyes...lol
works perfectly now, just had to change the formula reference in C3 to C2 NOT C3!!
will put solved up now, and thanks for all the help JBeaucaire, very much appreciated!!
Will click your star when it lets me again![]()
Bookmarks