reasons

  1. P

    Question mark in pivot table

    Instead of a number returned as expected the field has a '?'. Typical reasons why? Thanks in advance, Pikeboy
  2. D

    Hide Sheet Is not Available

    Why and how to resolve. A spreadsheet sent to us by a colleague will not allow a tab/sheet to be hidden. Remedies and reason(s)? Could it have to do with it being a macro enabled sheet?
  3. J

    Paste only last four characters of a string

    I have some folks who need to consolidate information spread across 1000 of spreadsheets into one master sheet. I could write a vba solution for some of the workbooks but they are all in different formats and have different information. Therefore, they are copying and pasting the information...
  4. A

    sumifs - criteria is blank/empty

    folks, when the number of invoices rejected each month, i generate a report that states the total number of rejections, and the count of each of the possible rejection reasons split out by week. Most reasons are pretty obvious: Cust ID not found, Cust under suspension, etc. to do this, I use a...
  5. H

    calculate % of total based on value in cell

    Hi there, I have a sheet with claims. There are different claim reasons and costs. Here is what I'm working with: In another sheet, I have the total of $ amount and the different reasons. Here's what that looks like: I'm trying to find the % each contributes to the total amount. Is...
  6. S

    referencing to a cell

    Hi all when using something like this msgbox(cells(1,1)) can that only work on the active sheet?? lets say on sheet1 in a1 = have "hello" but im on sheet 2 when i run the code. can i have it display the word hello with msgbox(cells(1,1)) i know i can use range(blar balr), i have other...
  7. J

    Create Pivot Table When duplicate data is in two columns

    I have spent a lot of time researching this topic and am coming here as a last resort. Thank you for reading. A table is for loans and the reasons they were denied. The columns are as follows: <colgroup><col span="2"><col><col></colgroup><tbody> Loan# Narrative ReasonForDenial1...

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