Jan 23 2019 04:46 AM
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 :)
Jan 23 2019 06:12 AM
Jan 23 2019 07:16 AM
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.
Jan 23 2019 07:35 AM
Jan 23 2019 07:55 AM - edited Jan 23 2019 08:02 AM
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 :)