Mikee_likes_excel
New Member
We are looking to create a formula that will find the total of each group in a table in order to extract a percent completed per row. Grouping consist of 4 or 5 columns of data. Please refer to attached excel file. File includes a small amount of sample data - table may have up to 30- 50k rows of data. Once we have the percent per row we will create a pivot table that will summarize the data with slicers based on various columns.
Thank you in advance for your expertise and helpfulness.
Please find attached excel sample file
Thank you in advance for your expertise and helpfulness.
Please find attached excel sample file