Good afternoon, Mynda
Hope all is well with you.
Do you think that you can help me with this issue? I won’t be able to provide sample data. Sorry.
I have 2 Worksheets. One has over 150K records. Other has 1500 records. For the one that has 150K Records, I need to give a Filter on Column P and Choose a Specific Value let us call it PA. What I did is I copied and pasted these filtered records on a new Sheet so now I have roughly 40K Records with the filtered cells.
Please let me know if that is not the right way to do?
Column A in the Filtered Master Sheet(40K) is LastNameAndFirstName. I converted it to a Table Named CE.
Column X in Other Sheets Let us call it Second Sheet and the Table Named MR is LastNameAndFirstName.
Column A from table CE = Column X from table ME (Both have LastNameAndFirstName)
My Goal is to find these 2 things.
- I need to make sure that 1500 Records from Table MR exist in Master Sheet Table CE.
- If they exist, then I need to check if Col R (Job Start Date) From Table MR has the same date as in Col AG (Join Date) from Table CE.
Col R = Col AG (From 2 Tables CE and MR should have the same dates, if not then it should highlight or some message)
Note: In these columns, some cells have dates, and some are blank.
Thanks,
Pam
Hi Pam,
You can easily automate all of this with Power Query. Including the initial task of extracting the 40k rows of PA data. Then any new data or updates to the original data can be picked up with the click of a button.
It's hard to be more specific without an example file, even a small subset of anonymised data. If you want to mock one up then we can give you a proof of concept solution so you can see how it could work.
Hope that points you in the right direction.
Mynda
Pam
