Compare workbooks excel for mac6/8/2023 ![]() ![]() ![]() With this second image, you can see there are some differences in the column labelled PR (the column is AR). The location of the file to compare is listed above. I am then wanting to know if the 4th columns (AR) also match. If the date, time and name match on both sheets, then it is the correct selection. ![]() The same columns A, C & Q, but with some differences in the 4th column. Here is an example of the sheet I am wanting to compare. Here is an example of the original sheet with A, C & Q showing date, time and name (I have hidden the columns in between) The sheet which will NOT have the code shows as this location when open August2021! I am using Excel 16 for Mac if that makes any difference VBA is not the preferred way for this task, as the column for comparing will change as other columns are to be compared. The hope is to input the code into one sheet and have a TRUE or FALSE answer in the other, depending if the data matches or not. The sheets in question are horse racing results and so to make sure the selection is the same one, the date (A), time (C) and name (Q) need to match and the column I am wanting to compare is AR in both sheets. Is there a way to compare 2 columns of data in 2 different workbooks based on matching certain criteria?
0 Comments
Leave a Reply. |