Forum Discussion

specky_girl_88's avatar
specky_girl_88
Copper Contributor
Jan 23, 2019

Need help to build excel formulas

Hello everyone,

 

I need help with to process some data.

 

Problem 1: As per mentioned below, Can you please show me formula used so that i can have result for example, "3" in I7 column (Andrea, Thomas and Nicky counted as "3" even they appear multiple times)

 

Problem 2: What formula used to show that on each day, a certain number of name hit either 4 Flags, 3 Flags etc

 

 

Here I attached the data in Excel file too.

Thank you in advance :)

 

 

office 365

4 Replies

  • Eva Vogel's avatar
    Eva Vogel
    Iron Contributor
    Jan 23, 2019

    Hi specky_girl_88! If you only want to show the formular view in a worksheet, just go to "Formula" Tab in the ribbon - then click on that button to show, see my screenshot attached here. By the way: Your workbook was not be able to open. Excel said to me, it is kind of damaged, something is wrong with the saved filetype, although it is xlsx. Can you see your formula now? Greets, Eva.

    • specky_girl_88's avatar
      specky_girl_88
      Copper Contributor
      Jan 23, 2019
      Hi, thank you for your reply.

      I'm sorry if my question came out wrongly. English is not my first language :)

      What I would like to ask is what formula can be used in order to show result as per requirement in I4-I11. For example, on 3/12/18, only 3 unique names appear. So I need 3 to be shown on I6.

      And for the file I attached earlier, I didn't encounter same error as yours. I was able to download the file even from different device.



      • Eva Vogel's avatar
        Eva Vogel
        Iron Contributor
        Jan 23, 2019

        Hello again :) OK, now I understand - hopefully. Your formula in I4-I11 has to be something with countif and I attached you another example, because my Excel is kind of preppy today... never mind.

         

        Hope that screenshot helps :)

Resources