Formula to consider first value of multiple same values

Try changing the part >0 to =1

L2 would be:

Formula:

Please Login or Register  to view this content.

Good luck!

It is deleting one of the matches but the wrong one. It is showing matched in both the Tally rows whereas it has to show Matched one in Portal and one in Tally row. I want the yellow marked cell to show as blank.

I have a formula from a different application, used before but that will calculate only one column G. If this is edited to include column H and I then it may work for column O. Have to use control + shift + enter to get the result.

HTML Code: 

L24 matched because there are even 2 PORTAL rows with exact the same content in columns C, G, H and I. [row 22 and row 23]
L21 matched because there is 1 PORTAL row with exact the same content in columns C, G, H and I. [row 19]

This is why I need to edit or change the formulain columns L and O. So that, the formula selects only one value instead of multiple values.

You don't have an Excel issue, but a business issue.
The formulas do what they are supposed to do and indicate is there for a PORTAL row at least 1 TALLY MATCH or not and vice-versa.
PORTAL row 19 matched to TALLY row 20 and 21 and vice-versa (TALLY row 20 and 21 matched to PORTAL row 19).
TALLY row 24 matched to PORTAL row 22 and 23 and vice-versa (PORTAL row 22 and 23 matched to TALLY row 24).

If you say a row cannot be matched for the second time, then in my opinion there is a match at L24 and O24, but no match at L23 and O23.
After all, PORTAL rows are matched to TALLY rows, but PORTAL rows are not matched to each other.
Now I understand what you mean and a formula can be made, so that the MATCH on rows 21 and 23 is not displayed.

Please try for L2 this formula and copy down

Formula:

Please Login or Register  to view this content.

.
I'll have to take a closer look at the formula for O2 and will come later.

Column L formula is working fine. Thanks HansDouwe. WIll wait for the formula for O2.

Please try for O2:

Formula:

Please Login or Register  to view this content.

Wow! It must be one of the biggest formulas I have come across so far. Both formulas are working perfect. Thank You so much HansDouwe.

I am not able to add reputation to your post. It say you must spread some reputation around before giving it to HansDouwe again.

HansDowwe. I want only the first one to be matched and the other to be blank as the other is an actual mismatch. Your first formula is perfect for that. I checked all the 6 formulas and it is giving me exactly what I was expecting. If there are 5 same amounts, 3 in Portal and 2 in Tally, under one GSTIN then it will take 2 from portal and 2 from tally as matched and the remaining one will be blank (Mismatch). and if there are 7 same amounts.... and so on. Hope you understood.

Not to worry, your 2 formulas are perfect. If I face any other issue in future, I will post it in a new thread. For now this is solved. Thanks for still trying to help.