Forum Discussion

PharmD's avatar
PharmD
Copper Contributor
Aug 27, 2019

Grouping columns

Hello! I have a report that I generate at work that lists medications entered by various providers at our hospital. It will have a column for the medication name, a column for the dose, and a column f...
excel
nabilmourad's avatar
nabilmourad
MVP
Aug 29, 2019

PharmD 

I agree with all what was mentioned in the thread

The beauty of Excel is the availability of multiple techniques that achieve the same goal.
IngeborgHawighorst  I love Pivot tables but I did not mention that as you had already covered it perfectly. On the other hand the function has an advantage over Pivot Tables (If the list of names is unchanged) which is automatically updating (specially if I use it with a Table or a defined name for an expandable range) while the PT requires Refreshing manually (unless you write a small code in VBA) or the maximum you can set the option to refresh on Opening the file.

I also agree with PeterBartholomew1  on how practical Dynamic Arrays are but, among thousands of students I teach still very few have access to them... I made that survey just yesterday when I was introducing the new giant function XLOOKUP...
The moral of this post is... This is a wonderful community we all help each other.

have a great day everyone

Nabil Mourad