• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Same "ID" for same "Month" and More than 2 Different Address should be highlighted

M

MohitMathur1234

Member
Hi,
Please find the attached file.
I have an excel file where I want same "ID" for same "Month" and More than 2 Different Address should be highlighted.

Please advise me any trick or formula to get the 3 conditions.
Same ID
Same Month
When Address is different more than 2 times.

Thanks
 

Attachments

  • Address_Test.xlsx
    8.8 KB · Views: 6
Hi Mohit ,

See the attached file for the counts ; seeing whether the counts are greater than 2 is a straightforward job.

Narayan
 

Attachments

  • Address_Test.xlsx
    11.4 KB · Views: 16
Thanks, I have found solution to find Month. But main formula (Sum) is not working.. I am doing same thing to find but unable to get 3 no. all are coming sum of 1.
please advise.
 
Hi Mohit ,

How can I advise when I do not know what you are doing ?

If you can upload your workbook , I can check it out and see where things are going wrong.

Narayan
 
hi Mohit - A question

How big is your dataset, if it is as big as in the attached..or may be a few more line items..it shouldnt take much time..
 
You must log in or register to reply here.
Back
Top