rose

  1. A

    conditional formatting based on a 2nd table value

    Hello, I am having two tables, 1 and 2. Advance orders are noted in table 2 and payment is made from the Allotment fed (for each firm, each item and item color) in table 1. The Allotment reduces on giving advance orders (Table 2) and on payments (Table 1) made. If the...
  2. T

    Remove blank cells in a given range (remove gaps between cells)

    Guys, is there a way to via vba move all of the names so there are no gaps so example 1 looks like example 2. The data is currerntly in range c22 to E40 in sheet called 'Allocate' EXAMPLE 1 <colgroup><col span="2"><col></colgroup><tbody> Name1 Name2 Name3 Angela Rose Bethan Mason...
  3. S

    League spreadsheet

    Hi a friend need help with his darts league spreadsheet that is beyond my capabilities There are 10 that have play every week for 18 weeks. There are 6 legs in each match each team are awarded the nmber of legs won <colgroup><col width="151" style="width: 113pt; mso-width-source: userset...
  4. B

    Many Columns Many Criteria Help

    Hello! I have a sheet that has many columns with many criteria per column to reference. Then I am rolling the data up to a topside page to subtotal all of the criteria required. My issues is I could not think of a quick way or nested formula way to accomplish this. Instead I am using a...

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