roll up

  1. S

    Gantt Chart Help

    I have a gantt chart that I like and understand how to update the information. What I am looking for is how to roll up all the sub task conditional formatting to the mask task line. Example Gantt: <tbody> Start End Main Task Y Y - - - Y Y Y - - - Y Y Y SubTask 1...
  2. B

    How to concatenate values in column with same primary key?

    Essentially, I have a worksheet that looks like this: <tbody> Record ID Candidate ID First Name Last Name FirstNameLastName Skill Record ID Skill Name 7064096 1204825 Jamie Burkholder Jamie Burkholder 550001252 Operations 7064097 1204825 Jamie Burkholder Jamie Burkholder 550002280...
  3. L

    Creating a Master Data sheet (Alpha Information)

    So I have been looking around to find a way to have information roll up to a master sheet from multiple worksheets. This includes data that aren't numerical (Names of companies, etc) Ideally, I would like to have Certain information contained in 3 different sheets to be rolled up to one...
  4. A

    Roll up string/sum from multiple roll when criteria match

    Hi, Anyone could help me to roll up the data when there's only one key of ID and distribute to many (One to many) One ID no. has only one title, but has many CCC, R, C,T as below table The data I extract from the server becomes like this <tbody> ID no Title CCC R C T SAQ1234 AAA H22 0.51...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top