Bob & Pecoflyer


Just got back to this and see that you guys have helped me even more. I so appreciate it!!

Bob, I wouldn't mind the helping column, but the users will be exporting the data on a weekly basis and replacing the [Check_In]EmployeeData worksheet and I would rather that they don't have to add that column.

I like the custom formatting idea. I now understand that much better. (BTW[$-409] is the formatting code for English(U.S.), [$-804] is code for Chinese, etc. You piqued my interest and I had to look it up ) Thanks a bunch.

Peco,
Thank you for the solution you presented but also for the link to the explanation of the SumProduct function. Your formula looked so daunting and I couldn't figure out how that worked. Now I understand the logic and can replicate it in the future.

You guys are geniuses!!