1. tamrob23

    SUM or IF formula for replacement?

    I'm stuck in my own head - hopefully you can get me out: I have a budget of $1.6 million dollars, but the state is doing a $2 million dollar budget. Can you please help me with a formula that will show the $1.6M replaced with $2M? Thank you so much in advance and if I need to provide you with...
  2. J

    Download over 1 million rows from

    I am trying to download data from the file contains more than 1.2 million rows, used power query download web option but get error message all the time. Below is the link, I am using excel 2013. Can someone help me...
  3. M

    Which histogram formula is correct?

    Poking around on the web I find various formulas for creating histograms. I'm getting different results for each formula and I want to know which one is accurate. I have a table of purchase orders and I want to get the distribution of how many POs are in various dollar ranges (e.g. how many...
  4. rhino4eva

    Email help.... probably asked before

    Sub Email() Application.Dialogs(xlDialogSendMail).Show End Sub so I have found the emal icon and put it on the ribbon.Even managed to record it in a macro. The Million dollar question can I get the TO option to fill from Cell A on SHEET1(which is email address)
  5. R

    Stacked Bar Chart Comparison

    Sorry, not sure how to word exactly what I'm looking for, and Google has not returned what I need. I have a data set with results from 3 divisions (A,B,C). I'd like to create a bar chart the stacks quarterly results from A and B and displays them next to C. i.e. in Quarter 1 A had $40 million...
  6. R

    Double Spacing

    Hi there, i have a relatively simple question. I would like a set of data to be double-spaced. There are two columns of data. Here is what the data looks like now: 1 2 3 4 5 6 7 8 etc. And here is what i want it to look like: 1 . 2 3 . 4 5 . 6 7 . 8 (I had to put a "." to...
  7. B

    Revenue Share - Excel Question

    Hi - I am trying to create a formula to determine revenue share for a company I work with. The initial revenue share percentage is 5%. On a yearly basis, Company X will receive 5% of Company Y's revenue until a $12 million cumulative number is hit. Once $12 million is hit, the revenue share %...
  8. northwolves

    Coordinates of two endpoints of a line segment

    Any one knows how to use VBA to get the coordinates of two endpoints of a line segment in a worksheet? Million thanks.
  9. J

    Excel million rows; can't delete with delete+save method

    Hello guys, As I said in the title, I have a spreadsheet with a million unneeded rows and I cannot delete them with the select rows, delete rows, save spreadsheet method. What other methods are there?
  10. A

    Formula that calculates a tiered bonus

    I am looking for help figuring out a formula that will calculate the following: <tbody> Range Bonus (per million) $7 Million - $16 Million $5,000 $17 Million - $27 Million $2,500 $28 Million + $1,000 </tbody> Thank you!
  11. L

    custom formatting million

    Hi What is the code to format number like 1532000 to 1.53M I have been trying different once but no success. Thank you very much
  12. Z

    Way over my head -- is this possible?

    I'm trying to figure out a way to do the following, and forgive me if I'm posting something entirely too complicated. Sorry for any time wasted. But if you want to help.... Lets assume I have a potential pool of 500 employees. Each employee has a productivity score, and a salary. The total...
  13. countryfan_nt

    Running SQL and Excel faster into Pivot/Sheet (from multiple sheets).

    Hello friends, hope all is well! I learned a very cool trick! Now I can use PowerPivot to have mutli sheets/files with Identical Structure in one sheet/pivot (more than 5 million rows). the problem is that the code is too slow...
  14. C

    Text function for billions

    Hi all! I'm using =TEXT(S146,"0.0,,") & " million" to convert <tbody> £ 354,691,359 to 354.7 million but what do I use to change it to billions? Thank you Confuddled </tbody>
  15. J

    how can i eliminate blank rows that exist beyond the last non-bank row?

    my spreadsheet has more than a million blank rows after the last non-blank row. how can i eliminate those blank rows?
  16. P

    How to handle data with more than 4 million lines in excel

    Hello, Can somebody help me that what is the best way to handle data with more than 4 million lines in excel other than keeping separate multiple worksheets ? Thanks, Punjabixlvba
  17. L

    List of Shortcuts

    Does Microsoft Excel offer a list for all shortcuts? I know there has to be about a million of them.:laugh:
  18. M


    Hi Mr. Excel. How can i use SpellNumber without Dollar. example i write 1600000-One Million, Six Hundred Thousand,Only
  19. M

    Any Way to have a Faster Calculating formulae then this one?

    I have the following array formulae repeated about 2.2 million times. Any other way to have it written to increase calculation time? =IF(E5:BB5="","",RANK(E5:BB5,$E5:$BB5,1)+COUNTIFS($E5:$BB5,$E5:$BB5,$BD$3:$DA$3,"<"&$BD$3:$DA$3)) Thank you!
  20. J

    pull numbers from text string. trim text

    My cell a96 contains "$82 Million Cash Value $51.4 Million" I need b96 to show 82000000 which I can do using =VALUE(TRIM(LEFT(A69,LEN(A69)-33)))*1000000 I also need c96 to show 51400000 But feel that may present problem if if cash value is less than 33 characters The numbers can change -...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...