true value

  1. D

    COUNTIFS Not Returning True on Blank Cells

    I'm using =IF(COUNTIFS(Vendors[Supplier Name],[@Vendor],Vendors[PO Type],[@[PO Type]]),"Yes","No") and it works great but only when both areas have text in them. I need it to still return a true value when both results match even when those cells are blank. Could anyone help? The PO type is...
  2. C

    INDEX MATCH multiple criteria with true value for blank cell condition

    Hi there, please someone help me to solve this problem. I am really confused. I have a reference table like this. <tbody> Category condition 1 condition 2 condition 3 condition 4 A -150 to 140 0 to 15 B 0 to 50 C -150 to 140 0 to 1000 0 to 50000 4.5 to 14 D -150 to...
  3. S

    Need to to see true value result of a Concatenated cell

    I have 4 cells (A1-A4) that concatenate into a fifth cell (A5). How can I have the result in A5 show in the formula window of A6 as the actual result instead of the concatenate formula as it does in A5?
  4. A

    Using Case statement with True and False keywords

    I have an Excel 'database' that I need to update some records on but ubfortunately the Select Case statement is not working as I expected it to. This the code that I have: Select Case cbVI2 Case = True And cbHI2 = True Range("U" & Count).Value = "DUAL" Case = True And cbHI2 = False Range("U"...
  5. J

    Automating Importing IQY Files

    I am writing VBA macro in Excel 2003 that includes opening an IQY file. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> When I open an IQY file manually, I get a Import Data dialog box that asks<o:p></o:p> <o:p></o:p> "Where do you want to put...

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