timber

  1. P

    Getting excel to ignore blank cells

    I have a spreadsheet where i am typing text into cells as follows cell A1 i am typing "timber", into cell A2 "metal", into cell A3 "stone" and other materials into cells below If i start to type into A4 "timber" the cell will autofill from cell A1 when i type the letter t, it fills in the word...
  2. P

    Ignore blank cells

    I have a spreadsheet where i am typing into A1 "timber", into A2 "metal", into A3 "marble" etc. If i start to type into A4 "timber" the cell will autofill from cell A1 however if i leave cell A4 blank then start to type "timber" into A5 it will not autofill How do i get excel to ignore the...
  3. P

    SUMIFS Criteria

    Hello everyone, I have the following formula which calculates volumes of materials based on a product, the final part of the formula which needs to equal the word 'timber' also needs to calculate if the value is 'wood'. So it needs to have either 'Timber' OR 'Wood'...

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