Forum Discussion

thenewguy87's avatar
thenewguy87
Copper Contributor
Jun 04, 2024

Is it possible to count how man wins at a venue in two collums?

So I have a spreadsheet and in collum "C" I have 9 venues that I compete at and in collum "D" I have my ranking. I was wondering if it was possible to have a list of the venues and a counter next to it counting how many times I have won at ea

 

Venue 1 - 0

Venue 2 - 1

Venue 3 - 0

Venue 4 - 3

Venue 5 - 5

Venue 6 - 0

Venue 7 - 1

Venue 8 - 1

Venue 9 - 2

  • mathetes's avatar
    mathetes
    Silver Contributor

    thenewguy87 

     

    I was wondering if it was possible to have a list of the venues and a counter next to it counting how many times I have won at ea

     

    Of course it's possible, but what we'd need to know, in order to give some ideas as to HOW it's possible, is how your raw data regarding your competitive record is organized. Those numbers won't just magically appear, so where will they come from? Do you track each match, the date, the venue, the result? If not...then, no, it's not possible.

    • thenewguy87's avatar
      thenewguy87
      Copper Contributor

      mathetes 

      My apologies for not giving enough info.

       

      The way the data is currently entered is just into the collums so then there will be a blank row between dates. I have attached an image as an example to try an show what it looks like.

       

      So I guess what I am trying to do is have it so if the vaule in collum D is 1 then it counts the venue?

       

      I am sorry, in my head it is clear but I struggle to get my thoughts written down.

       

      Date - Game - Venue - Placement - Score

       

      • mathetes's avatar
        mathetes
        Silver Contributor

        thenewguy87 

         

        Here's a solution that works. It requires that you make use of some tools that probably will be new to you. Arrange your raw data as a table, first of all. Once you've done that, you'll be able to add new events at will and have them counted. Creating a table will mean eliminating those blank rows--helpful for human eyes but an interference to Excel; let Excel work at its best by learning to separate the raw (Input) data from the output end of things.

         

        The formula uses the FILTER function, which does require Excel 2021 or newer, so I hope you have that.

         

        I've also used Data Validation to make sure that you enter the Pitch (venue) data consistently.

         

        All of those hyperlinks above will take you to a resource that explains the method or tool.

Resources