hello
i have a sheet that looks like below layout with unique identifiers in the columns. Looking for a formula to help tell me how many of each identifier there is. for example results would be ABC=2 BCD=3 EFG= 7
Note some columns could be blank, not sure if that impacts anything..ty
<tbody>
</tbody>
i have a sheet that looks like below layout with unique identifiers in the columns. Looking for a formula to help tell me how many of each identifier there is. for example results would be ABC=2 BCD=3 EFG= 7
Note some columns could be blank, not sure if that impacts anything..ty
A | B | C | D | E | F | G | H | I | J | K | L |
ABC | ABC | BCD | BCD | BCD | EFG | EFG | EFG | EFG | EFG | EFG | EFG |
<tbody>
</tbody>