X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Calculate Groups, Office 2013    
post Nov 18 2019, 04:14 PM

Posts: 126
Joined: 4-June 02

I have a spreadsheet that contains over 1,000 rows of medical expenses. I want to be able to have a macro that will group the providers (could be as many as 50 different ones) and then add a row that will show the totals of each of the numerical columns. I have attached a partial spreadsheet as an example.
Attached File(s)
Attached File  medical_example.zip ( 7.74K )Number of downloads: 7

always learning....<img src="/forums/images/graemlins/laugh.gif" alt="" />
Go to the top of the page
Start new topic
post Jan 3 2020, 07:26 PM

Posts: 3,550
Joined: 27-February 09

You can do this with DAX... kind of depends on what you're trying to do with the data, though. useful if you're doing data analysis, but otherwise, probably overkill.
Go to the top of the page

Posts in this topic

Custom Search

RSSSearch   Top   Lo-Fi    28th March 2020 - 03:14 AM