location1

  1. L

    fill diagonal with zero

    Hi I am just curious, if there is a way to fill diagonal with zeros like below? formula, auto fill kind of things etc. Thank you very much <colgroup><col><col span="5"></colgroup><tbody> location1 location2 location3 location4 location5 location1 0 location2 0 location3 0...
  2. R

    Change the format of some data from a table to a list

    Hello everyone, I have a requirement to change the format of some data from a table to a list. The data I have at the moment looks like this: <tbody> 6 Jan 2018 5 Jan 2018 4 Jan 2018 3 Jan 2018 2 Jan 2018 1 Jan 2018 Group1 Group2 Location1 Group3 Location1 Group4...

This Week's Hot Topics

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
Top