Help with Room Utilization Grid

debmullin

New Member
Joined
May 3, 2019
Messages
3
Hi - I have data that represents classes assigned to a room. Some classes are two days a week, some classes are 1 day a week. I would like to have a visual of the room utilization and open slots. I tried a pivot table with class start and stop time as a row and Class Day as a column. That doesn't seem to do it. Anyone have an idea for a grid. Here is a sample of one of the rooms with fake instructor names:

[TABLE="width: 551"]
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Start Time[/TD]
[TD]End Time[/TD]
[TD]Class Day[/TD]
[TD]CATALOG #[/TD]
[TD]CLASS SECTION[/TD]
[TD]Room[/TD]
[TD]Instructor [/TD]
[/TR]
[TR]
[TD="align: right"]10:30 AM[/TD]
[TD="align: right"]11:45 AM[/TD]
[TD]M[/TD]
[TD="align: right"]2[/TD]
[TD]10[/TD]
[TD]BBC121[/TD]
[TD]Kenya Kim[/TD]
[/TR]
[TR]
[TD="align: right"]12:00 PM[/TD]
[TD="align: right"]1:15 PM[/TD]
[TD]M[/TD]
[TD="align: right"]2[/TD]
[TD]13[/TD]
[TD]BBC121[/TD]
[TD]Kenya Kim[/TD]
[/TR]
[TR]
[TD="align: right"]3:00 PM[/TD]
[TD="align: right"]4:15 PM[/TD]
[TD]M[/TD]
[TD="align: right"]2[/TD]
[TD]21[/TD]
[TD]BBC121[/TD]
[TD]Kenya Kim[/TD]
[/TR]
[TR]
[TD="align: right"]4:30 PM[/TD]
[TD="align: right"]5:45 PM[/TD]
[TD]M[/TD]
[TD="align: right"]2[/TD]
[TD]24[/TD]
[TD]BBC121[/TD]
[TD]Kenya Kim[/TD]
[/TR]
[TR]
[TD="align: right"]1:30 PM[/TD]
[TD="align: right"]2:45 PM[/TD]
[TD]M[/TD]
[TD] 1A[/TD]
[TD]49[/TD]
[TD]BBC121[/TD]
[TD]Raleigh Roth[/TD]
[/TR]
[TR]
[TD="align: right"]9:00 AM[/TD]
[TD="align: right"]10:15 AM[/TD]
[TD]M[/TD]
[TD] 1A[/TD]
[TD]69[/TD]
[TD]BBC121[/TD]
[TD]Raleigh Roth[/TD]
[/TR]
[TR]
[TD="align: right"]9:00 AM[/TD]
[TD="align: right"]10:15 AM[/TD]
[TD]T[/TD]
[TD] 1AF[/TD]
[TD]06[/TD]
[TD]BBC121[/TD]
[TD]Abe Hampton[/TD]
[/TR]
[TR]
[TD="align: right"]10:30 AM[/TD]
[TD="align: right"]11:45 AM[/TD]
[TD]T[/TD]
[TD] 1A[/TD]
[TD]26[/TD]
[TD]BBC121[/TD]
[TD]Claudia Holmes[/TD]
[/TR]
[TR]
[TD="align: right"]12:00 PM[/TD]
[TD="align: right"]1:15 PM[/TD]
[TD]T[/TD]
[TD] 1A[/TD]
[TD]42[/TD]
[TD]BBC121[/TD]
[TD]Claudia Holmes[/TD]
[/TR]
[TR]
[TD="align: right"]10:30 AM[/TD]
[TD="align: right"]11:45 AM[/TD]
[TD]W[/TD]
[TD="align: right"]2[/TD]
[TD]10[/TD]
[TD]BBC121[/TD]
[TD]Kenya Kim[/TD]
[/TR]
[TR]
[TD="align: right"]12:00 PM[/TD]
[TD="align: right"]1:15 PM[/TD]
[TD]W[/TD]
[TD="align: right"]2[/TD]
[TD]13[/TD]
[TD]BBC121[/TD]
[TD]Kenya Kim[/TD]
[/TR]
[TR]
[TD="align: right"]3:00 PM[/TD]
[TD="align: right"]4:15 PM[/TD]
[TD]W[/TD]
[TD="align: right"]2[/TD]
[TD]21[/TD]
[TD]BBC121[/TD]
[TD]Kenya Kim[/TD]
[/TR]
[TR]
[TD="align: right"]4:30 PM[/TD]
[TD="align: right"]5:45 PM[/TD]
[TD]W[/TD]
[TD="align: right"]2[/TD]
[TD]24[/TD]
[TD]BBC121[/TD]
[TD]Kenya Kim[/TD]
[/TR]
[TR]
[TD="align: right"]1:30 PM[/TD]
[TD="align: right"]2:45 PM[/TD]
[TD]W[/TD]
[TD] 1A[/TD]
[TD]49[/TD]
[TD]BBC121[/TD]
[TD]Raleigh Roth[/TD]
[/TR]
[TR]
[TD="align: right"]9:00 AM[/TD]
[TD="align: right"]10:15 AM[/TD]
[TD]W[/TD]
[TD] 1A[/TD]
[TD]69[/TD]
[TD]BBC121[/TD]
[TD]Raleigh Roth[/TD]
[/TR]
[TR]
[TD="align: right"]9:00 AM[/TD]
[TD="align: right"]10:15 AM[/TD]
[TD]R[/TD]
[TD] 1AF[/TD]
[TD]06[/TD]
[TD]BBC121[/TD]
[TD]Abe Hampton[/TD]
[/TR]
[TR]
[TD="align: right"]10:30 AM[/TD]
[TD="align: right"]11:45 AM[/TD]
[TD]R[/TD]
[TD] 1A[/TD]
[TD]26[/TD]
[TD]BBC121[/TD]
[TD]Claudia Holmes[/TD]
[/TR]
[TR]
[TD="align: right"]12:00 PM[/TD]
[TD="align: right"]1:15 PM[/TD]
[TD]R[/TD]
[TD] 1A[/TD]
[TD]42[/TD]
[TD]BBC121[/TD]
[TD]Claudia Holmes[/TD]
[/TR]
[TR]
[TD="align: right"]9:30 AM[/TD]
[TD="align: right"]12:15 PM[/TD]
[TD]F[/TD]
[TD] 1A[/TD]
[TD]78[/TD]
[TD]BBC121[/TD]
[TD]Ana Romero[/TD]
[/TR]
</tbody>[/TABLE]

And this is what I want it to look like:

[TABLE="width: 655"]
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD][TABLE="width: 656"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]M
[/TD]
[TD]T
[/TD]
[TD]W
[/TD]
[TD]R
[/TD]
[TD]F
[/TD]
[/TR]
[TR]
[TD]9:00 AM-10:15AM
[/TD]
[TD]
[/TD]
[TD]Roth 1A-69
[/TD]
[TD]Hampton 1AF-06
[/TD]
[TD]Roth 1A-69
[/TD]
[TD]Hampton 1AF-06
[/TD]
[TD]Holmes 1A-78 9:30 - 12:15
[/TD]
[/TR]
[TR]
[TD]10:30 AM - 11:45 AM
[/TD]
[TD]
[/TD]
[TD]Kim 2-13
[/TD]
[TD]Holmes 1A-26
[/TD]
[TD]Kim 2-13
[/TD]
[TD]Holmes 1A-26
[/TD]
[/TR]
[TR]
[TD]12:00 PM - 1:15PM
[/TD]
[TD]
[/TD]
[TD]Kim 12-1:15
[/TD]
[TD]Holmes 1A-42
[/TD]
[TD]Kim 12-1:15
[/TD]
[TD]Holmes 1A-42
[/TD]
[/TR]
[TR]
[TD]1:30 PM - 2:45 PM
[/TD]
[TD]
[/TD]
[TD]Roth 1A-49
[/TD]
[TD]
[/TD]
[TD]Roth 1A-49
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]3:00 PM - 4:15PM
[/TD]
[TD]
[/TD]
[TD]Kim 2-21
[/TD]
[TD]
[/TD]
[TD]Kim 2-21
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]4:30 PM - 5:45 PM
[/TD]
[TD]
[/TD]
[TD]Kim 2-24
[/TD]
[TD]
[/TD]
[TD]Kim 2-24
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
</tbody>[/TABLE]

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]


Thanks for any advice![/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
is that what you want ?

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td=bgcolor:#FFFF00]Source[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td=bgcolor:#FFFF00]Result[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#5B9BD5]Start Time[/td][td=bgcolor:#5B9BD5]End Time[/td][td=bgcolor:#5B9BD5]Class Day[/td][td=bgcolor:#5B9BD5]CATALOG #[/td][td=bgcolor:#5B9BD5]CLASS SECTION[/td][td=bgcolor:#5B9BD5]Room[/td][td=bgcolor:#5B9BD5]Instructor[/td][td][/td][td=bgcolor:#70AD47]Time[/td][td=bgcolor:#70AD47]M[/td][td=bgcolor:#70AD47]T[/td][td=bgcolor:#70AD47]W[/td][td=bgcolor:#70AD47]R[/td][td=bgcolor:#70AD47]F[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]
10:30 AM​
[/td][td=bgcolor:#DDEBF7]
11:45 AM​
[/td][td=bgcolor:#DDEBF7]M[/td][td=bgcolor:#DDEBF7]
2​
[/td][td=bgcolor:#DDEBF7]
10​
[/td][td=bgcolor:#DDEBF7]BBC121[/td][td=bgcolor:#DDEBF7]Kenya Kim[/td][td][/td][td=bgcolor:#E2EFDA]09:00 - 10:15[/td][td=bgcolor:#E2EFDA]Roth 1A-69[/td][td=bgcolor:#E2EFDA]Hampton 1AF-6[/td][td=bgcolor:#E2EFDA]Roth 1A-69[/td][td=bgcolor:#E2EFDA]Hampton 1AF-6[/td][td=bgcolor:#E2EFDA][/td][/tr]

[tr=bgcolor:#FFFFFF][td]
12:00 PM​
[/td][td]
1:15 PM​
[/td][td]M[/td][td]
2​
[/td][td]
13​
[/td][td]BBC121[/td][td]Kenya Kim[/td][td][/td][td]09:30 - 12:15[/td][td][/td][td][/td][td][/td][td][/td][td]Romero 1A-78[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]
3:00 PM​
[/td][td=bgcolor:#DDEBF7]
4:15 PM​
[/td][td=bgcolor:#DDEBF7]M[/td][td=bgcolor:#DDEBF7]
2​
[/td][td=bgcolor:#DDEBF7]
21​
[/td][td=bgcolor:#DDEBF7]BBC121[/td][td=bgcolor:#DDEBF7]Kenya Kim[/td][td][/td][td=bgcolor:#E2EFDA]10:30 - 11:45[/td][td=bgcolor:#E2EFDA]Kim 2-10[/td][td=bgcolor:#E2EFDA]Holmes 1A-26[/td][td=bgcolor:#E2EFDA]Kim 2-10[/td][td=bgcolor:#E2EFDA]Holmes 1A-26[/td][td=bgcolor:#E2EFDA][/td][/tr]

[tr=bgcolor:#FFFFFF][td]
4:30 PM​
[/td][td]
5:45 PM​
[/td][td]M[/td][td]
2​
[/td][td]
24​
[/td][td]BBC121[/td][td]Kenya Kim[/td][td][/td][td]12:00 - 13:15[/td][td]Kim 2-13[/td][td]Holmes 1A-42[/td][td]Kim 2-13[/td][td]Holmes 1A-42[/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]
1:30 PM​
[/td][td=bgcolor:#DDEBF7]
2:45 PM​
[/td][td=bgcolor:#DDEBF7]M[/td][td=bgcolor:#DDEBF7]1A[/td][td=bgcolor:#DDEBF7]
49​
[/td][td=bgcolor:#DDEBF7]BBC121[/td][td=bgcolor:#DDEBF7]Raleigh Roth[/td][td][/td][td=bgcolor:#E2EFDA]13:30 - 14:45[/td][td=bgcolor:#E2EFDA]Roth 1A-49[/td][td=bgcolor:#E2EFDA][/td][td=bgcolor:#E2EFDA]Roth 1A-49[/td][td=bgcolor:#E2EFDA][/td][td=bgcolor:#E2EFDA][/td][/tr]

[tr=bgcolor:#FFFFFF][td]
9:00 AM​
[/td][td]
10:15 AM​
[/td][td]M[/td][td]1A[/td][td]
69​
[/td][td]BBC121[/td][td]Raleigh Roth[/td][td][/td][td]15:00 - 16:15[/td][td]Kim 2-21[/td][td][/td][td]Kim 2-21[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]
9:00 AM​
[/td][td=bgcolor:#DDEBF7]
10:15 AM​
[/td][td=bgcolor:#DDEBF7]T[/td][td=bgcolor:#DDEBF7]1AF[/td][td=bgcolor:#DDEBF7]
6​
[/td][td=bgcolor:#DDEBF7]BBC121[/td][td=bgcolor:#DDEBF7]Abe Hampton[/td][td][/td][td=bgcolor:#E2EFDA]16:30 - 17:45[/td][td=bgcolor:#E2EFDA]Kim 2-24[/td][td=bgcolor:#E2EFDA][/td][td=bgcolor:#E2EFDA]Kim 2-24[/td][td=bgcolor:#E2EFDA][/td][td=bgcolor:#E2EFDA][/td][/tr]

[tr=bgcolor:#FFFFFF][td]
10:30 AM​
[/td][td]
11:45 AM​
[/td][td]T[/td][td]1A[/td][td]
26​
[/td][td]BBC121[/td][td]Claudia Holmes[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]
12:00 PM​
[/td][td=bgcolor:#DDEBF7]
1:15 PM​
[/td][td=bgcolor:#DDEBF7]T[/td][td=bgcolor:#DDEBF7]1A[/td][td=bgcolor:#DDEBF7]
42​
[/td][td=bgcolor:#DDEBF7]BBC121[/td][td=bgcolor:#DDEBF7]Claudia Holmes[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td]
10:30 AM​
[/td][td]
11:45 AM​
[/td][td]W[/td][td]
2​
[/td][td]
10​
[/td][td]BBC121[/td][td]Kenya Kim[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]
12:00 PM​
[/td][td=bgcolor:#DDEBF7]
1:15 PM​
[/td][td=bgcolor:#DDEBF7]W[/td][td=bgcolor:#DDEBF7]
2​
[/td][td=bgcolor:#DDEBF7]
13​
[/td][td=bgcolor:#DDEBF7]BBC121[/td][td=bgcolor:#DDEBF7]Kenya Kim[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td]
3:00 PM​
[/td][td]
4:15 PM​
[/td][td]W[/td][td]
2​
[/td][td]
21​
[/td][td]BBC121[/td][td]Kenya Kim[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]
4:30 PM​
[/td][td=bgcolor:#DDEBF7]
5:45 PM​
[/td][td=bgcolor:#DDEBF7]W[/td][td=bgcolor:#DDEBF7]
2​
[/td][td=bgcolor:#DDEBF7]
24​
[/td][td=bgcolor:#DDEBF7]BBC121[/td][td=bgcolor:#DDEBF7]Kenya Kim[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td]
1:30 PM​
[/td][td]
2:45 PM​
[/td][td]W[/td][td]1A[/td][td]
49​
[/td][td]BBC121[/td][td]Raleigh Roth[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]
9:00 AM​
[/td][td=bgcolor:#DDEBF7]
10:15 AM​
[/td][td=bgcolor:#DDEBF7]W[/td][td=bgcolor:#DDEBF7]1A[/td][td=bgcolor:#DDEBF7]
69​
[/td][td=bgcolor:#DDEBF7]BBC121[/td][td=bgcolor:#DDEBF7]Raleigh Roth[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td]
9:00 AM​
[/td][td]
10:15 AM​
[/td][td]R[/td][td]1AF[/td][td]
6​
[/td][td]BBC121[/td][td]Abe Hampton[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]
10:30 AM​
[/td][td=bgcolor:#DDEBF7]
11:45 AM​
[/td][td=bgcolor:#DDEBF7]R[/td][td=bgcolor:#DDEBF7]1A[/td][td=bgcolor:#DDEBF7]
26​
[/td][td=bgcolor:#DDEBF7]BBC121[/td][td=bgcolor:#DDEBF7]Claudia Holmes[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td]
12:00 PM​
[/td][td]
1:15 PM​
[/td][td]R[/td][td]1A[/td][td]
42​
[/td][td]BBC121[/td][td]Claudia Holmes[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]
9:30 AM​
[/td][td=bgcolor:#DDEBF7]
12:15 PM​
[/td][td=bgcolor:#DDEBF7]F[/td][td=bgcolor:#DDEBF7]1A[/td][td=bgcolor:#DDEBF7]
78​
[/td][td=bgcolor:#DDEBF7]BBC121[/td][td=bgcolor:#DDEBF7]Ana Romero[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]
[/table]
 
Upvote 0
with M-code (PowerQuery)

Code:
[SIZE=1]let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Type = Table.TransformColumnTypes(Source,{{"Start Time", type time}, {"End Time", type time}, {"Class Day", type text}, {"CATALOG #", type any}, {"CLASS SECTION", Int64.Type}, {"Room", type text}, {"Instructor", type text}}),
    MergeCatClass = Table.CombineColumns(Table.TransformColumnTypes(Type, {{"CATALOG #", type text}, {"CLASS SECTION", type text}}, "en-GB"),{"CATALOG #", "CLASS SECTION"},Combiner.CombineTextByDelimiter("-", QuoteStyle.None),"Merged"),
    Split = Table.SplitColumn(MergeCatClass, "Instructor", Splitter.SplitTextByDelimiter(" ", QuoteStyle.Csv), {"Instructor.1", "Instructor.2"}),
    MergeInstrCatClass = Table.CombineColumns(Split,{"Instructor.2", "Merged"},Combiner.CombineTextByDelimiter(" ", QuoteStyle.None),"Merged.1"),
    Pivot = Table.Pivot(MergeInstrCatClass, List.Distinct(MergeInstrCatClass[#"Class Day"]), "Class Day", "Merged.1"),
    MergeTime = Table.CombineColumns(Table.TransformColumnTypes(Pivot, {{"Start Time", type text}, {"End Time", type text}}, "en-GB"),{"Start Time", "End Time"},Combiner.CombineTextByDelimiter(" - ", QuoteStyle.None),"Time"),
    GrpTime = Table.Group(MergeTime, {"Time"}, {{"Count", each _, type table}}),
    ExtractM = Table.TransformColumns(Table.AddColumn(GrpTime, "M", each List.Distinct(Table.Column([Count],"M"))), {"M", each Text.Combine(List.Transform(_, Text.From)), type text}),
    ExtractT = Table.TransformColumns(Table.AddColumn(ExtractM, "T", each List.Distinct(Table.Column([Count],"T"))), {"T", each Text.Combine(List.Transform(_, Text.From)), type text}),
    ExtractW = Table.TransformColumns(Table.AddColumn(ExtractT, "W", each List.Distinct(Table.Column([Count],"W"))), {"W", each Text.Combine(List.Transform(_, Text.From)), type text}),
    ExtractR = Table.TransformColumns(Table.AddColumn(ExtractW, "R", each List.Distinct(Table.Column([Count],"R"))), {"R", each Text.Combine(List.Transform(_, Text.From)), type text}),
    ExtractF = Table.TransformColumns(Table.AddColumn(ExtractR, "F", each List.Distinct(Table.Column([Count],"F"))), {"F", each Text.Combine(List.Transform(_, Text.From)), type text})
in
    ExtractF[/SIZE]
 
Upvote 0
Another Power Query solution. Different approach, same results.

Code:
let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Start Time", type time}, {"End Time", type time}, {"Class Day", type text}, {"CATALOG #", type text}, {"CLASS SECTION", type text}, {"Room", type text}, {"Instructor", type text}}),
    #"Split Column by Delimiter" = Table.SplitColumn(#"Changed Type", "Instructor", Splitter.SplitTextByDelimiter(" ", QuoteStyle.Csv), {"Instructor.1", "Instructor.2"}),
    #"Added Custom" = Table.AddColumn(#"Split Column by Delimiter", "Custom", each [Instructor.2] & " " & [#"CATALOG #"] & "-" & [CLASS SECTION]),
    #"Removed Columns" = Table.RemoveColumns(#"Added Custom",{"CATALOG #", "CLASS SECTION", "Room", "Instructor.1", "Instructor.2"}),
    #"Pivoted Column" = Table.Pivot(#"Removed Columns", List.Distinct(#"Removed Columns"[#"Class Day"]), "Class Day", "Custom"),
    #"Replaced Value" = Table.ReplaceValue(#"Pivoted Column",null,"",Replacer.ReplaceValue,{"M", "T", "W", "R", "F"}),
    #"Merged Columns" = Table.CombineColumns(Table.TransformColumnTypes(#"Replaced Value", {{"Start Time", type text}, {"End Time", type text}}, "en-US"),{"Start Time", "End Time"},Combiner.CombineTextByDelimiter(" to ", QuoteStyle.None),"Time")
in
    #"Merged Columns"
 
Upvote 0

Forum statistics

Threads
1,223,893
Messages
6,175,244
Members
452,622
Latest member
Laura_PinksBTHFT

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