formula and text

  1. L

    Countif formula returning the same results for entire data range that start with a prefix of < >

    Hello! I'm building a dashboard and using “COUNTIF” to simply count the number of times a complaint isowned by a particular person or process… The issue I’m having is new ownershave been added to the data and the begin with < or > for example <over font="" old<="" 5years=""></over>...
  2. M

    Can I do INDEX MATCH with 3 MATCHES?

    I am trying to use INDEX MATCH with three MATCHES and it does not seem to be working. It returns the #REF error. I have a table of data with titled rows and columns with 2 titles. The first match I do is for the row, then I do 2 separate ones for the columns. Where the rows and columns match...
  3. G

    How to use Formula in DataValidation List Source

    Hi friends, I need to use a formula in the Source: of my Data Validation to include the Sheetname for my drop down list. The following formula should work if someone can please show me how to properly QUOTE it. I get very confused trying to put quotes within quotes. To be clear, the...
  4. D

    If result from a formula contains a character, then...

    Dear, I have the following issue, and looking for possible assistance. The formula I currently have is broken into three pieces: It looks at cell A4 if empty, otherwise to process the second part... It looks if a separate table column E:E contents, and compare with a concatenation of active...

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