Ask Your Question

How to compare data across calc worksheets

asked 2019-07-13 00:02:18 +0200

LibreNacho gravatar image

I am looking to compare data from two separate worksheets.

Unfortunately the data is not formatted the same. One is a do not call list and one is a list of leads. one is formatted in a single cell as (###)###-#### and the the other is formatted across two cells. first cell area code ### and second cell #######

I am assuming I first need to make the formatting the same in both? If so and suggestions? Macro? Manual data entry (I hope not but do have admin staff...)


edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2019-07-13 19:36:02 +0200

LibreNacho gravatar image

vlookup didn't do exactly what I wanted but is workable.

edit flag offensive delete link more

answered 2019-07-14 00:10:28 +0200

PaulHaz gravatar image

If you compare two cells, it is the values of those cells being compared and not the formatting.

Assuming the data is in columns, I guess you may need to create one or two new columns to manipulate the original values into a common form (edit out the brackets if they are part of the data, combine two cells into one). You can then reliably compare the data in the new columns.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-07-13 00:02:18 +0200

Seen: 91 times

Last updated: Jul 14 '19