Forum Discussion
Solved
Need to calculate frequency from distinct values using formulas or functions
Hi! I'm new to excel and have not received any formal training. I'm working on a report but am stuck even before we begin. The report is dynamic and I hope to add data into the Sheet named ...
James_Raju I am not totally sure what some of your columns are for, but I've done what I can in the attached. This uses Office 365 dynamic arrays as much as possible to increase automatic updating. I also converted your data into an Excel Table with Ctrl T so that new rows are automatically included.
James_Raju I am not totally sure what some of your columns are for, but I've done what I can in the attached. This uses Office 365 dynamic arrays as much as possible to increase automatic updating. I also converted your data into an Excel Table with Ctrl T so that new rows are automatically included.