1. staticfluids

    Distribute Number into Several Part (Increment) Based on Other Data (Dynamic Array)

    Hi all, I hope you're doing well. First of all, sorry for bad explanation as my main language is not English. I'm currently using Excel 2021 and trying to experiment with Dynamic Array formula. It's quite helping with my daily Excel use. 2 of my latest question was asking about Dynamic Array...
  2. J

    How to correctly calculate the percentage of productivity

    In PowerBI I am calculating the percentage of productivity of each of the technicians who attend tickets, to calculate the productivity of each one I am using the formula "Tickets attended * 100 / Total tickets", to calculate productivity I am creating a new measure where I am executing the...
  3. P

    Formula or code to split stock from warehouse to 2 selling points

    Good evening, I would really appreciate a help on this problem Suppose i have a 50 pieces of an item in my warehouse and i want to send it to 2 selling points. The one selling point has already 10 pieces and the other 20 pieces. What formula do i need to give me the solution of having equal...
  4. L

    Dividing the sums of two columns after selection of certain cells

    Hello everybody, I have learned PowerBi so far from tutorials and youtube videos and this is the first time I am posting. There is an issue which I seem not to find a workaround. I import my raw data in power query and then edit it such that I can subtract various tables for my purposes. One...
  5. M

    cell value mapping to another cell from sheet in VBA

    Names Output Arul CS Mala CS Shan CS Selv SW Mani SW Muthu SW I need to find the count of Column A .Examples Column A have count of 6 in worksheet. I need to divide the count of column A and assisgn the work between two names based on the another sheet Assisgn CS SW...
  6. N

    How to separate duplicates into different files?

    I have a list of 2500 contacts with their respective email, I have duplicate contacts but the different email, I need to separate the duplicates in different excel files to not generate spam when I export it. What should I do?
  7. D

    Dividing by a value in a cell that moves

    Hello all, So my question is how can I use a value that is calculated in a cell to be a denominator in a formula into other cells? The problem I am having is the cell that is the denominator could move to a different cell the next time this macro is ran. The value will always be in column D...
  8. H

    Value Divide and set in cell

    Hey is this possibel in VBA code if i have a Empty cell ("F16") then Value from ("F15") is Divide with "2" But if value in ("F15") is Odd then Add +1 to value in ("F15") and then Divide with 2 and then Value is Put into Cell("F16") is that Possibel i have look and search around Google but didn...
  9. D

    Combining formulas to get a percentage

    I am attempting to combine 2 countifs formulas and then divide them by another countif and am getting 240% and I cant figure out what I am doing wrong. Below are the countifs that I am trying to combine and the third is the one I am trying to divide by. For reference the first set of formulas...
  10. A

    over flow error

    I have this code that encounters an error as a result of trying to divide by zero. How can I avoid this error? Range("P2") / WorksheetFunction.Subtotal(9, Range("U18:U18" & Range("U" & Rows.Count).End(xlUp).Row))
  11. A

    Divide but keep minimum value

    Hello, I am dividing a cell by a set value in excel, but I would like to return 1 if the results are 0 or <1. I'm having trouble writing the formula correctly. This seems pretty simple, but I am goofing. I have tried If functions. Thank You for your time.
  12. K

    Multiple If depending on date

    How do i get a cell to look at a cell and depending on the date divide another cell by a certain number? for example: In cell H44 I want it to look at H6 and if that date is within the dates of the first quarter then divide whats in H35 by 520, if the dates are with second quarter it divided...
  13. B

    Simple SUM

    Hi Team, I'm having a (what I think) very simple SUM issue, but it's a Monday and I can't work it out! Effectively, I am trying to do a COUNTIF and SUM in one. My COUNTIF is as follows (and works, no issues there): =SUM(COUNTIF(INDEX(Data!$F:$AO,,A2),"Strongly...
  14. I

    divide by zero error help

    HI guys i have set the below formula ( with some help from mrexcel members !) below to pull some numbers but i get the #DIV/0! error sometimes do to the 0 or no data. below is the formula...
  15. X

    Divide Total price by number of duplicates

    https://imgur.com/bh9WKg1 Hi, In Column D i am counting all duplicates In column AN i have the Cost Column AP i am counting duplicate numbers from column D What i would like to do is Calculate the Total cost by each occurrence in column D, and then divide the total cost by the count from...
  16. X

    Divide if value is 0

    https://imgur.com/gYDlsNh Hi, I have a big excel list with over 2000 lines I would like that whenever a line's value is zero ("Final Cost column") to divide the number from above that is not zero by the number of duplicates ("Extra line count in my case").
  17. mayday1

    Simple Formula error

    I've been staring at this too long and can't figure it out. When C2 is greater than 0, it gives me the value of E3*F3 plus E50*F50 (always above 0 if C2 is above 0). Why doesn't this formula divide by the value in cell C2? That value should be divided by C2, shouldn't it? =IF(C2>0,(('[UDR...
  18. R

    Divide result by 5

    I have this formula: =IFERROR(VLOOKUP($A8,[BannerAvails4.19.xlsx]Q2!$A$3:$FC$156,4,FALSE),"0") which produces the result I need. Now I need to modify it so that the resulting number will be divided by 5. Nothing I've tried seems to work. Any suggestions? Thank you in advance
  19. M

    How do I do a formula or whatever to process a list of random numbers?

    I need to process a column of random numbers, and do certain things with them, depending on their size. It is for some writing I am doing. Here is an example : 0.592437095 0.986644999 0.698993662 0.299869473 0.175831087 0.081866617 0.840500143 0.31014318 0.989504965 0.169993951 I want to...
  20. wsnyder

    Divide Month Into Four Equal Parts

    Hi all, Using Excel 2016. How can I divide any given months into 4 equal parts so I can determine if a task was complete in part1, part2, part3 or part4? I tried dividing 3/31/2019 into 4 equal parts of 7.75 hours each, but I don't like the way this is heading. There has to be an easier way...

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