6 Replies Latest reply on Apr 16, 2018 6:13 AM by sagar a

# To find the only one's in the each Claim Number

Hi,

I got a requirement that to find the only ones in the  column of each claim number  and to count the the number of 1's but the ones in each claim number repeated the 1's,but to count only one time of each claim number and total should use in the bar graph.

Thanks,

A.Sagar.

• ###### 1. Re: To find the only one's in the each Claim Number

Hi Sagar,

~Tushar

• ###### 2. Re: To find the only one's in the each Claim Number

Hi Tushar,

If we take in the Excel sheet column has complaint for each claim number  1's are repeated more than one like complaint column has 3 ones of the claim number A123 . i want count of which claim numbers has  atleast 1 and count of which claim numbers has only zeros.

complanint  Output

A123          1

A123          1              1

A123          1

A123          0

A123          0

A124          0              0

A124          0

Total count of claim numbes which has 1 is :1

Total count of claim numbers which has only 0's :1

• ###### 3. Re: To find the only one's in the each Claim Number

Thanks for the explanation. Here is the modified approach in the attached workbook v10.3

Let me know if that helps.

~Tushar

• ###### 4. Re: To find the only one's in the each Claim Number

Hi Tushar,

Workbook is not attached.

• ###### 5. Re: To find the only one's in the each Claim Number

Sorry Its attached.