Forum Discussion
specky_girl_88
Jan 23, 2019Copper Contributor
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 (An...
Eva Vogel
Jan 23, 2019Iron Contributor
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_88Jan 23, 2019Copper ContributorHi, 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 VogelJan 23, 2019Iron Contributor
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 :)