Welcome Guest.

2Answers

How does Excel make different duplicate data show different colors and statistics

Asked by: Louis Powell 9 views IT September 22, 2022

As shown in the figure below, how to set the duplicate data cells to fill different colors, and the number of groups that are repeated, repeat the number of two groups, the number of 3 groups, the number of 4 groups

2 Answers

  1. +4Votes  

    Setting conditions format

    = if (($ a $ 2: $ p $ 2, a2)> 1)*$ A $ 2: A2, A2) = 1), A2, “”)

    Answer: Statistics formula
    = Count (A5: P5)
    = Countif ($ a $ 6: $ p $ 6, colorn (b1))
    = Countif ($ A $ 2: $ P $ 2, A5)

    Linda Ellis- September 22, 2022 |

  2. +1Votes  

    1, first enter the data in the excel table to mark different colors.”Filter”, and then select one set of the same data in the cell.Click the “Positioning Conditions” option in the toolbar, select “Visible Ceremony” in the open positioning dialog box, and click OK.
    3, click the color button to fill the color, select the color you want.
    4, repeat the above operation, you can mark different colors of each group of the same data

    Michael Thomas- September 22, 2022 |

Answer Question