feel

  1. S

    Excel Spreadsheet running slow

    Does anyone know how to speed up an excel file? I have a lot of data that is running with several formulas, but I don't feel it should be this slow. I have other documents with more info that doesn't run this slow...
  2. G

    Calculate total hours for week based on total time of each day

    I have the following table I use to keep track of my work hours: I calculated the Total Time column with the following formula (example row 3) which takes the lunch time (D3-C3) and subtracts it from the total In-Out time (E3-B3): =TEXT((E3-B3)-(D3-C3), "h.mm") This works fine, but I also...
  3. M

    Copying and Pasting Format Issue in Gmail

    Hello, I never had this happen before, can't figure out what I am doing wrong. I have a excel sheet that looks like this...(note the blank columns) But when I paste into an email, it looks like this...(note the spaces are no longer separated) DateTypeDebit"CheckNumber"...
  4. Roar

    I feel üüber dumb right now for this formula Let me explain

    I want to say If Cell 11 is >14 and <26, then return a 0% in cell P11 It seems so easy, but either my googling has fallen to crap or .... I am dumb. Please help me, I will buy coffee.
  5. rjbinney

    Pull Data from Multiple Worksheets

    I feel like I knew how to do this once, but I'll be ****ed if I can find a worksheet where I pulled it off. Essentially, I have a workbook where expenses are logged in monthly tabs (so May 2017 has a sheet listing each category and expense, June has its own, etc. etc.). Now I'd like to write a...
  6. C

    This should be an easy one, I guess

    Hi all I am looking for an easy -and working- formula to tell me when A1, B1 and C1 values are the same, after a search for help on the Internet I feel very confused, thanks in advance for your help. ColdGeorge
  7. E

    If Offset Index Match Returns Non-Numeric Value, Return Second Index Match

    Need help with the last part of this formula please. The original formula worked great until I realized that the imported data had a duplicate value in a row that I'm wanting to ignore. Correct values have a numeric value in column 1 of the data range, so if the formula encounters a...
  8. J

    VBA Code to Select Pen/Draw or inkpicture

    Have been playing with signature boxes, etc. Would like to use the inkpicture feature but don't like the active x turned on. If you feel this is the better option and I can turn the active x message off with code when workbook opens, then feel free to share. I'd at least like VBA code to select...
  9. T

    Autofill Indirect across columsn

    I have the below formula. =SUMPRODUCT(SUMIF(INDIRECT("'"&Sheet1!$A$2:$A$4&"'!$B$3:$B$100"),$B3,INDIRECT("'"&Sheet1!$A$2:$A$4&"'!d$3:d$100")))/SUMPRODUCT(SUMIF(INDIRECT("'"&Sheet1!$A$2:$A$4&"'!$B$3:$B$100"),$B3,INDIRECT("'"&Sheet1!$A$2:$A$4&"'!$p$3:$p$100"))) I need to autofill across columns...

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