Please assist

[Guest]

I am trying to count the number of times a value appears in a row of multiple
values, then return the value and the number of times it appears, then count
and return all the rest of the values in the row as well.

 

[Richard Buttrey]

I am trying to count the number of times a value appears in a row of multiple
values, then return the value and the number of times it appears, then count
and return all the rest of the values in the row as well.

Copy the row say A1:F1 and thenEdit Paste it somewhere else say A4:A9
using the Transpose option.

Now use Advanced Filter to extract a unique list of values from A4:A9
into say B4.

Now in C4 type
=COUNTIF($A$1:$F$1,B4)

and copy it down column C.

HTH


__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________