number

  1. ibmy

    SUM/COUNT of value 1 at the end of set

    Hi, Data contain just 2 value which are 1 and 0. AB1DataResult20311405061718139010111121201301411150160170 Thanks advance.
  2. S

    Formula to make queue with text

    Question is there a formula for the below example? From this: Queue Name Order No. Jack N01 Jenny N02 Jenny N03 Kimmy N04 To this: Queue Name Order No. N01Q01 Jack N01 N02Q02 Jenny N02 N03Q03 Jenny N03 N01Q02 Kimmy N04 1. So A2 gets the value of C2 and add...
  3. A

    Turn numbers written as words into digits (two - 2, three - 3...)

    Hello, I would like to find a formula to turn the right column into the left column. Is there a way to turn the word twenty four into 24? This would significantly speed up my work so I would appreciate your help! Thanks in advance.
  4. S

    How to split numbers separated by semicolons in a cell?

    I have a number string in cell A1 that looks something like this: 12; 34; 56; 78; 90 I would like to extract each number into cells A2, A3, A4, A5, and A6, respectively. After extracting, cell A2 should contain 12, A3 34, and so on. Thank you very much for your help.
  5. A

    SUM BASE ON FIRST NUMBER OF NUMBER WITH IGNORING BLANK CELLS IN RANGE

    Hi, Can anybody help me, i am trying to sum numbers base on their first numbers, i find a formula in the forum and when tried it, it gave value error because of blank cell but i tried to modified but couldn't overcome, any help will appreciated.
  6. ibmy

    Identify Number Pattern of Positive(+) -> Zero(0) -> Negative(-)

    Dear Smartest Excelers, Some of sample from my 90k row data: ABCD1DiffResult2030.440.552.36070809-3.91B5(+) -> B6:B8(0) -> B9(-)10-0.1Rule 4: Start new find110120.4No count : B10(-) -> B11 (0) -> B12 (+)13014-0.51B12(+) -> B13(0) -> B14(-)150Rule 4: Start new...
  7. M

    Count when number moves to next full number

    10 years + Excel experience and consider myself to be 'advanced' but can't crack this one for the life of me! All help is greatly appreciated. See attached spreadsheet.... I have a cumulative tracker of 'packages sold' in row 54 and 55 (in green) In row 71 and 72 (in yellow), I would like to...
  8. J

    Pyramid sum of six digit in single cell

    Respected members, I have six digit number in column A and need pyramid result corresponding cell. For example below - In A1 if record is 123123 then pyramid calculation result 4 need to be shown in B2 123123 4 468477 6 245112 9 Pyramid calculation below 123123 35435 8978...
  9. H

    Total to be the same

    Hi I have a sheet "sheet1" that is on about 12 rows that all have the same amount in it 0,000213434 So If I change any one of these number in any row, i want all of the others to change to the new number also if I change 0,00012345 to 0,01234546 all of the 0,000123456 must change to...
  10. B

    Autofill Numbers In Merged Cells

    I know there are some topics about autofill in merged cells, but I couldn't find what I need. I don't even know if it's possible. Is there a way to autofill numbers in this kind of table? (see image bellow). There are cells merged in rows and columns. Numbers with 2 or 3 digits, depending on...
  11. ibmy

    Count if the value is positive and negative 'itself'

    Hi, Column A // Column B -0.1 // 1 0.1 // 2 -0.1 // 3 0.3 0.7 0.2 // 1 -0.2 // 2 -0.2 // 1 0.2 // 2 0.7 // -0.5 // 1 0.5 // 2 -0.5 // 3 0.5 // 4 0.5 // 0.3 // Rule: 1. The starting value can be negative or postive 2. Reset the count if :- i- value is...
  12. B

    Format decimal as number of months

    Hey everyone, I want to format a decimal/fraction as a number of months. For example, I'd like to enter "=1/12" into a cell and have it show "1 month," or enter "=1.5/12" and have it show "1.5 months." Is this possible? Thanks!
  13. K

    Convert Time into number for Payroll calculations in PowerQuery [Office 2013]

    Hey guys. I am doing my first Power Query project using and have successfully transformed data are I wanted that I could not do in PowerPivot. However I need to convert the hours worked by each employees into Number so that I can take that number and use it in the payroll software to calculate...
  14. R

    Hide data labels with zero values WITHOUT changing number format

    Hi, How to hide data labels with zero value? I did a bit search but all solutions suggested are by changing number format. As I already have a defined number format in the chart, changing format is not an option. Also, VBA is not an option.
  15. R

    Error on number formatting on VBA - Very Strange...

    1) I have an excel sheet with values (Numbers) that represent dollar amounts. 2) I have a Userform that has labels that update the values according to the amounts on the Excel Sheet... Everything was running smoothly until I opened the excel worksheet with a PC (I work on MAC Excel 2011) in...
  16. G

    Data best fit?

    Hi all, If I have a range of numbers to 2 decimal places in column A, for example from -2.52 to 3.84 with intervals that are not the same -2.52, -2.49, -2.48, -2,42, -2.42, -2.41, -2.38....... 3.65, 3.69, 3.70, 3.80. In column B the number in the cell adjacent to -2.52 is 20 The number is the...
  17. J

    A loop counter

    Hello. I am working on a workbook that uses random numbers that loops until a certain condition is met; a specific number. I am wanting to be able to count how many times the loop has to cycle until the number is calculated correctly. Essentially a counter of the cycles. Any help is appreciated.
  18. P

    Formula - rank numbers high to low

    I have a listing of values and I need to place a number 1-10 for the top 10 highest numbers. For example, out of these 16 numbers I need a 1 next to the highest number, a 2 next to the second highest number, etc. <colgroup><col width="72" style="width: 54pt; mso-width-source: userset...
  19. J

    Getting an exact match in a search

    Hello, new to VBA, so forgive my ignorance. I created a spreadsheet which I am adding data and assigning a number to the data. I have a search setup to make sure the number I am assigning is not already used. It works great except it cannot differentiate between say 75 and 175 or 1075, which...
  20. K

    range error

    I'm new to VBA so be gentle. This just started happening today. Whenever I select a preexisting command button to a macro, I get an error window listing the range as "Wrong number of arguments or invalid property assignment" What can I do now? Sub clearswitchboard()...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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
Top