Merged Cell Error

Merged Cell Error

I presented the file sample in the attachment. Help please

[Blocked Image: https://www.ozgrid.com/forum/]">

Quote from Carim

Hello and Welcome to the Forum

Merged Cells are a total disaster ...

You should completely get rid of them ...

I know, but now I have to

Quote from Carim

Not sure to understand ...

You have to ... what exactly ...???

Quote from royUK

To help solve your problem we need clear examples. Post a small Excel workbook, not an image, showing a realistic sample of your data with confidential information removed.

Also, provide as much information as possible - error messages, etc.

I can't speak your language. I use translate.google.com

But I added my full file. I want to find out how many "MAHALLE" there are by colors. There are 2495 lines in the file in total. For example, there are 20 red colors. But excel 13 shows.