oak

  1. S

    COUNTIFS or better way there?

    I have a small data that of matches played between two teams. The data looks similar to this. <tbody> Matches data1 data2 data3 Yellow Oak vs Blue Stone Yellow Oak vs Green Grass Oak Blue Stone vs Green Grass Oak </tbody> <tbody> Teams Match Played Yellow Oak Blue Stone...
  2. S

    CONSOLIDATING A LIST and adding values

    Morning I have a list of names in column A lets say wood types I have a lenght in column B I have a quantity in column C in column A a wood type could appear mulltiple instances. like below. oak 2000 1 beech 2000 3 oak 1000 2 pine 3000 6 oak 50...
  3. MFish

    Unique IDs to change conditional format

    Hi, I'd like to setup a conditional format that will change accordingly to certain Unique ID's. <tbody> OAK 1 OAK 1 OAK 2 OAK 3 OAK 3 OAK 4 OAK 5 OAK 5 </tbody> The conditional format I'd like to run will highlight the cell range A1:D1 when the unique ID is found...
  4. K

    Filter data by multiple independent drop-downs for multiple columns

    Hi All, I received a really good response from here before and I am hoping someone can help me again. I browsed for an answer but it does not exist so far. I'll explain what I am trying to do and also what I have so far. I have a large table with a lot of data. I have some dropdowns in B2:B9...
  5. J

    Auto-Populate Cells Based on Input

    Hello Everyone! I'm a landscape architect and part of my job is working on Tree Preservation Plans. Basically what I'd like to do is input the Species, DBH, & ACTION (In Yellow) and have it populate the cell (In Green) based on the category in F3:N3 (Significant Trees, Heritage Trees, Etc..)...
  6. S

    vba to consolidate and sum duplicate row items

    Hello, I have a parts list, and it shows cut lengths and pieces needed to build a unit. I need some help condensing all duplicates into one line items with total length needed. the formula would be: Column B x Column E, and then sum and condense all unique items in column D into one line...

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