formula question

  1. S

    =IF(ISERROR(MATCH Question

    I am using the following formula, which gives me one problem. =IF(ISERROR(MATCH(AL1,AK:AK, 0)), "", "ALERT") I need to be able to have some way for the solution to ignore the differences in upper and lower case between the two columns if that's possible. As an example, the entry in AL1 is...
  2. M

    Calculating Number of Unique Values in Column

    Hello, I am preparing a usage report for a school's Learning Management System. I have downloaded the raw data of each login into an Excel file. Each row down the worksheet represents one login. Each column across the page represents some identifying information about the user. These columns...
  3. C

    Formula Question -Dynamic Table Transaction Total column

    I am struggling with a formula in table. Currently, I have transactional data where I select/type one (1) possible value out of five (5) in column A. Value two (2) and value five (5) need to have column B and C multiplied for a total value in column D. (number of pieces * the price per piece...
  4. E

    Running total formula question

    Hi all, I am need of running total formula help. Running total <table style="padding-right: 2pt; padding-left: 2pt; font-size: 11pt; font-family: Calibri,Arial; background-color: rgb(255, 255, 255);" border="1" cellpadding="0" cellspacing="0"> <colgroup> <col style="font-weight: bold; width...

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