complex if statement

  1. A

    Variable numbers of rows, multiple columns (some blank cells): require summation based on values in cells in one column

    In order to simplify this question, I have put column headings in "quotation marks". I am working on geological borehole log data, with "depth" in column C, a set group of "geological units" being repeated down column D, and "sequences" based on specific depositional times and environments...
  2. E

    Use of Array in IF function to return a "store-type" based on a text fragment from "store name."

    I downloaded a credit-card summary statement. Each row represents a purchase (including date, store name and amount). A given row of data might look like this: <tbody> 1/1/12 Publix #246 SR98286659 $128 </tbody> I want to add a fourth column that automatically qualifies a customized...

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