Require formula

[Ron99]

Hello,

From the below table I need a simple output.
There are ID's assigned to each item. If the item type and ID's are same the output should be 'TRUE" else "FALSE"

Example - ID 1000024 has all the same item type so the output should be "true" whereas ID 1000025 different item type it should be "FALSE"

ID	ITEM TYPE	OUTPUT
1000024	CONSUMABLE
1000024	CONSUMABLE
1000024	CONSUMABLE
1000024	CONSUMABLE
1000024	CONSUMABLE
1000025	CONSUMABLE
1000025	CONSUMABLE
1000025	CONSUMABLE
1000025	REPAIRABLE
1000025	EXPENDABLE
1000025	CONSUMABLE

<tbody>
</tbody>

 

[Aladin Akyurek]

Is this what you are after?

In C2 enter and copy down:

=COUNTIFS($A$2:$A$12,A2,$B$2:$B$12,B2)>1

 

[Ron99]

Hi,

Thank you for the reply. I used the formula but I would require a slight change

ID	ITEM TYPE	OUTPUT
1000024	CONSUMABLE	TRUE
1000024	CONSUMABLE	TRUE
1000024	CONSUMABLE	TRUE
1000024	CONSUMABLE	TRUE
1000024	CONSUMABLE	TRUE
1000025	CONSUMABLE	TRUE
1000025	CONSUMABLE	TRUE
1000025	CONSUMABLE	TRUE
1000025	REPAIRABLE	TRUE
1000025	EXPENDABLE	FALSE
1000025	CONSUMABLE

<tbody>
</tbody>

When There is false I want the entire ID to show up as "FALSE". In this case 1000025 should all show up as false.

 

[Marcílio_Lobão]

Ron99, Good morning.

Aladin Akyurek, Good morning. (Greetings from Brazil!)

Try this one:

=COUNTIFS($A$2:$A$20,A2,$B$2:$B$20,B2)=COUNTIF($A$2:$A$20,A2)

Please, tell us if it worked as you want.

I hope it helps.

 

[Aladin Akyurek]

Hi,

Thank you for the reply. I used the formula but I would require a slight change
[...]
When There is false I want the entire ID to show up as "FALSE". In this case 1000025 should all show up as false.

If uniqueness is required and any blank in A or B should be treated differently...

Control+shift+enter, not just enter:

=IF(OR(A2="",B2=""),"",1=SUM(IF(FREQUENCY(IF($A$2:$A$12=A2,MATCH("~"&$B$2:$B$12,$B$2:$B$12&"",0)),ROW($B$2:$B$12)-ROW($B$2)+1),1)))

 

[Ron99]

Thank you guys, there are no blanks.
Going by the formula "=COUNTIFS($A$2:$A$12,A2,$B$2:$B$12,B2)>1 " output will be

ID	ITEM TYPE	formula	EXPECTED OUTPUT
1000024	CONSUMABLE	TRUE	TRUE
1000024	CONSUMABLE	TRUE	TRUE
1000024	CONSUMABLE	TRUE	TRUE
1000024	CONSUMABLE	TRUE	TRUE
1000024	CONSUMABLE	TRUE	TRUE
1000025	CONSUMABLE	TRUE	FALSE
1000025	CONSUMABLE	TRUE	FALSE
1000025	CONSUMABLE	TRUE	FALSE
1000025	REPAIRBALE	TRUE	FALSE
1000025	EXPENDABLE	FALSE	FALSE
1000025	REPAIRBALE	TRUE	FALSE

<tbody>
</tbody>

If all item type are same then its TRUE, IF any one item type is different all should be false to that particular ID.

 

[Aladin Akyurek]

Thank you guys, there are no blanks.
Going by the formula "=COUNTIFS($A$2:$A$12,A2,$B$2:$B$12,B2)>1 " output will be

[...]

If all item type are same then its TRUE, IF any one item type is different all should be false to that particular ID.

If no blanks, see Marcilio's modification in post #4 . That is:

=COUNTIFS($A$2:$A$20,A2,$B$2:$B$20,B2)=COUNTIFS($A$2:$A$20,A2)

 

[Ron99]

Thank you guys!! great