Forum

Hi, The file you attached already has a defined name with the GET.CELL formula in the Refers To field of that name. GET.CELL is used in a define...

Hi Hooi, You can try this macro to disconnect all slicers: Sub DisconnectAllSlicers() Dim SlicersDict As Variant Set SlicersDict = Creat...

Hi TimC, I see that you are already using a defined name with GET.CELL to check if a cell has formula. You can also use GET.CELL to check the row h...

According to this: The_Emergency_Department_Occupancy_Rate_A-Simple_Measure_of_.pdf "The numerator of the EDWIN is the sum of the Emergency Severit...

You're right, that > is the code for > , wordpress is converting them automatically, and this is annoying sometimes. You don't seem to ha...

Great solutions already, I'll contribute with another approach, which may be more flexible, in case there are new conditions to be added: =IFERRO...

Hi Frans, The only way that excel will translate function names is when you open an excel file that was created in another language. All you have to d...

Hi Frans, welcome to our forum 🙂 Sorry I puzzled you. I admit I wrote the first one just for fun 🙂 First, make sure you are using Excel 2010+,...

Hi Rathanak, You can try one of these: =AGGREGATE(15,3,ROW($A$10000:$A$60000)/((ROW($A$10000:$A$60000)>=A1)*(WEEKDAY(ROW($A$10000:$A$60000))=...

You're welcome 🙂

Hi, A pivot table is not editable unfortunately, it will only take data from source, it will never send data to source. Catalin

You have to add a conditional formatting rule, with the color you want, for range =$E$6:$G$9, with this formula: =E$5=$H6 The $ sign is esential...

Hi Julie, You have to start learning pivot tables, it will save you a lot of time. See the attached file for a sample pivot table report. I adde...

Hi Tony, Can you please upload a sample file, so we can see your data structure? Dates can be in many unexpected formats, a functional solution ...

Hi Brenda, You have no attachment, not even an image. Press the Start Upload button after you Add a file, only then the file will be uploaded. I...