Finding and Locating Discrepancies using Formula.

I wanted to find all the discrepancies

What constitutes a discrepancy?

locating it

Locating what?

using HYPERLINK function

You cannot locate anything using the HYPERLINK function.

Clear as mud! Hopefully, when I look at your workbook, it will all become clear.

EDIT: No, not clear at all, largely because you have not mocked up your expected result, only showed us where it should be. How would you expect to be able to link to five different cells with the HYPERLINK function, anyway?

MUCH more detail needed. What's the ultimate aim here? What are you trying to achieve?

Unless you make it clear what it is you are trying to do, then we can't say whether or not it's achievable. If you don't have the time to answer my questions, then there's nothing more we can do - sorry.

By the way, I never said, nor did I imply, that I thought you were wasting our time. Please do NOT make silly assumptions of that sort. If I thought that, I certainly would not have spent time looking at your workbook and asking for clarification. I would have simply ignored your thread altogether.

Sorry about that.
Anyway thank for your time.