[TABLE="width: 500"]
<tbody>[TR]
[TD]Item#[/TD]
[TD]Sending from[/TD]
[TD]Receiving at[/TD]
[TD]Received by[/TD]
[TD]# of receivers[/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD]warehouse1[/TD]
[TD]HQ[/TD]
[TD]Rep1[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD]
[/TD]
[TD]<strike></strike>
[/TD]
[TD]Rep2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD]
[/TD]
[TD]<strike></strike>
[/TD]
[TD]Rep3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]456[/TD]
[TD]
[TD]warehouse3[/TD]
[TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]456[/TD]
[TD]
[/TD]
[TD]
[TD]Rep5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]852[/TD]
[TD]
[/TD]
[TD]<strike></strike>
[/TD]
[TD]<strike></strike>
[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]852[/TD]
[TD]
[/TD]
[TD]<strike></strike>
[/TD]
[TD]<strike></strike>
[/TD]
[TD]<strike></strike>
[/TD]
[/TR]
[TR]
[TD]852[/TD]
[TD]
[/TD]
[TD]<strike></strike>
[/TD]
[TD]<strike></strike>
[/TD]
[TD]<strike></strike>
[/TD]
[/TR]
[TR]
[TD]852[/TD]
[TD]
[/TD]
[TD]<strike></strike>
[/TD]
[TD]<strike></strike>
[/TD]
[TD]<strike></strike>
[/TD]
[/TR]
</tbody>[/TABLE]
Above is a mockup data that I have. I am looking to populate column "# of receivers" with the number of unique representatives for each item. Is this possible with a formula in the "# of receivers" column?
<tbody>[TR]
[TD]Item#[/TD]
[TD]Sending from[/TD]
[TD]Receiving at[/TD]
[TD]Received by[/TD]
[TD]# of receivers[/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD]warehouse1[/TD]
[TD]HQ[/TD]
[TD]Rep1[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD]
warehouse1
<strike></strike>[/TD]
[TD]<strike></strike>
HQ
<strike></strike>[/TD]
[TD]Rep2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD]
warehouse1
<strike></strike>[/TD]
[TD]<strike></strike>
HQ
<strike></strike>[/TD]
[TD]Rep3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]456[/TD]
[TD]
warehouse2
[/TD][TD]warehouse3[/TD]
[TD]
Rep4
[/TD][TD]2[/TD]
[/TR]
[TR]
[TD]456[/TD]
[TD]
warehouse2
<strike></strike>[/TD]
[TD]
warehouse3
[/TD][TD]Rep5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]852[/TD]
[TD]
warehouse1
<strike style="background-color: transparent; border-collapse: collapse; color: rgb(34, 34, 34); font-family: Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: line-through; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; width: auto; word-spacing: 0px;"></strike><strike></strike>[/TD]
[TD]<strike></strike>
warehouse3
<strike style="background-color: transparent; border-collapse: collapse; color: rgb(34, 34, 34); font-family: Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: line-through; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; width: auto; word-spacing: 0px;"></strike><strike></strike>[/TD]
[TD]<strike></strike>
Rep1
<strike></strike>[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]852[/TD]
[TD]
warehouse1
<strike style="background-color: transparent; border-collapse: collapse; color: rgb(34, 34, 34); font-family: Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: line-through; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; width: auto; word-spacing: 0px;"></strike><strike></strike>[/TD]
[TD]<strike></strike>
warehouse3
<strike style="background-color: transparent; border-collapse: collapse; color: rgb(34, 34, 34); font-family: Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: line-through; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; width: auto; word-spacing: 0px;"></strike><strike></strike>[/TD]
[TD]<strike></strike>
Rep1
<strike></strike>[/TD]
[TD]<strike></strike>
[/TD]
[/TR]
[TR]
[TD]852[/TD]
[TD]
warehouse1
<strike style="background-color: transparent; border-collapse: collapse; color: rgb(34, 34, 34); font-family: Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: line-through; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; width: auto; word-spacing: 0px;"></strike><strike></strike>[/TD]
[TD]<strike></strike>
warehouse3
<strike style="background-color: transparent; border-collapse: collapse; color: rgb(34, 34, 34); font-family: Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: line-through; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; width: auto; word-spacing: 0px;"></strike><strike style="background-color: transparent; border-collapse: collapse; color: rgb(34, 34, 34); font-family: Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: line-through; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; width: auto; word-spacing: 0px;"></strike><strike></strike>[/TD]
[TD]<strike></strike>
Rep3
<strike></strike>[/TD]
[TD]<strike></strike>
[/TD]
[/TR]
[TR]
[TD]852[/TD]
[TD]
warehouse1
<strike style="background-color: transparent; border-collapse: collapse; color: rgb(34, 34, 34); font-family: Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: line-through; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; width: auto; word-spacing: 0px;"></strike><strike></strike>[/TD]
[TD]<strike></strike>
warehouse3
<strike style="background-color: transparent; border-collapse: collapse; color: rgb(34, 34, 34); font-family: Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: line-through; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; width: auto; word-spacing: 0px;"></strike><strike style="background-color: transparent; border-collapse: collapse; color: rgb(34, 34, 34); font-family: Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: line-through; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; width: auto; word-spacing: 0px;"></strike><strike></strike>[/TD]
[TD]<strike></strike>
Rep3
<strike></strike>[/TD]
[TD]<strike></strike>
[/TD]
[/TR]
</tbody>[/TABLE]
Above is a mockup data that I have. I am looking to populate column "# of receivers" with the number of unique representatives for each item. Is this possible with a formula in the "# of receivers" column?