Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,665
- Office Version
- 365
- 2016
- Platform
- Windows
Is there an efficient way to code a comparison between two ranges (values) to determine whether there are any differences?
Range A
Range B
As a minimum, I need to a simple TRUE or FALSE as to whether there are differences between the two. In a perfect world, a list of changes would be cool, but I fear that may take some intense coding. Maybe meeting somewhere in the middle with a total number of differences would be acceptable.
Thank you in advance to anyone that wishes to help me.
Range A
Excel Workbook | |||||||
---|---|---|---|---|---|---|---|
R | S | T | U | V | |||
2 | CUE1 | 1 | Kelly | 0.291667 | 0.625 | ||
3 | CUE2 | X | Not Staffed | 0.291667 | 0.625 | ||
4 | CUL1 | 2 | Jen | 0.666667 | 1 | ||
5 | HPE1 | C | Tessa | 0.291667 | 0.625 | ||
6 | HPE2 | X | Not Staffed | 0.291667 | 0.625 | ||
7 | HPL1 | A | Morgan | 0.5625 | 0.895833 | ||
8 | HPL2 | X | Not Staffed | 0.5625 | 0.895833 | ||
9 | RPE1 | C | Ashley B. | 0.291667 | 0.625 | ||
10 | RPE2 | X | Not Staffed | 0.291667 | 0.625 | ||
11 | RPL1 | A | Corey | 0.5625 | 0.895833 | ||
12 | RPL2 | X | Not Staffed | 0.291667 | 0.625 | ||
13 | WPE1 | C | Lauren | 0.291667 | 0.625 | ||
14 | WPE2 | X | Not Staffed | 0.291667 | 0.625 | ||
15 | WPL1 | A | Kiana | 0.5625 | 0.895833 | ||
16 | WPL2 | X | Not Staffed | 0.291667 | 0.625 | ||
17 | PTE1 | X | Not Staffed | 0.291667 | 0.625 | ||
18 | PTE2 | X | Not Staffed | 0.291667 | 0.625 | ||
19 | PTL1 | A | Jessica | 0.645833 | 0.8125 | ||
VAR_HOLD |
Range B
Excel Workbook | |||||||
---|---|---|---|---|---|---|---|
R | S | T | U | V | |||
25 | CUE1 | 1 | Kelly | 0.291667 | 0.625 | ||
26 | CUE2 | X | Not Staffed | 0.291667 | 0.625 | ||
27 | CUL1 | 2 | Jen | 0.666667 | 1 | ||
28 | HPE1 | C | Tessa | 0.291667 | 0.625 | ||
29 | HPE2 | X | Not Staffed | 0.291667 | 0.625 | ||
30 | HPL1 | A | Morgan | 0.5625 | 0.895833 | ||
31 | HPL2 | X | Not Staffed | 0.5625 | 0.895833 | ||
32 | RPE1 | C | Ashley B. | 0.291667 | 0.625 | ||
33 | RPE2 | X | Not Staffed | 0.291667 | 0.625 | ||
34 | RPL1 | A | Corey | 0.5625 | 0.895833 | ||
35 | RPL2 | X | Not Staffed | 0.291667 | 0.625 | ||
36 | WPE1 | C | Lauren | 0.291667 | 0.625 | ||
37 | WPE2 | X | Not Staffed | 0.291667 | 0.625 | ||
38 | WPL1 | A | Kiana | 0.5625 | 0.895833 | ||
39 | WPL2 | A | Jessica | 0.645833 | 0.8125 | ||
40 | PTE1 | X | Not Staffed | 0.291667 | 0.625 | ||
41 | PTE2 | X | Not Staffed | 0.291667 | 0.625 | ||
42 | PTL1 | ||||||
VAR_HOLD |
As a minimum, I need to a simple TRUE or FALSE as to whether there are differences between the two. In a perfect world, a list of changes would be cool, but I fear that may take some intense coding. Maybe meeting somewhere in the middle with a total number of differences would be acceptable.
Thank you in advance to anyone that wishes to help me.