Hello,

I was wondering if there is an easy way to round using the Subtotals? I
need to compare two lists of numbers. One list contains daily sales totals
by store. The second list contains numbers that when subtotaled by day and
store should equal the totals on the first list. My problem is that I'm
using vlookup to compare the totals to the subtotals, and my subtotals need
to be rounded in order for vlookup to find a match. Is there any easy way to
do this? I hope this make sense. Here's an example

List 1
a b c
1 1/5/06 Store 1 15000.37
2 1/5/06 Store 2 25090.16

List 2
a b c
1 1/5/06 St 1-Visa Sales 7500.18
2 1/5/06 St 1-MC Sales 7500.19
3 1/5/06 St 2-Visa Sales 10090.11
4 1/5/06 St 2-MC Sales 15000.05

The problem lies, in that the numbers on list two, although it only shows 2
digits past the decimal, it may actually contain more, while the numbers on
list one are ONLY 2 past the decimal. Therefore it's causing a rounding
probelm.

Any help you can provide is very much appreciated.

thanks.