1. S

    SUM numbers in row with leading string character

    I want to SUM the numbers in a row which represent the worked hours in a month. The numbers in the cells have a leading string character like V8 or S8 or H7,2. How can I do that. See the mini sheet below for layout and desired results. Thank you very much...
  2. A

    Count consecutive numbers in Array

    Good day Experts..please help me with this I have 3 Columns with single digit numbers, I need to know how many times each digit repit consecutively.ex 345 367 410 123 012 306 here we can see 0 repit 1 times (rows 5, 6), 1 = 2(rows 3, 4 and 4, 5), 3 1 times (rows 1 and 2) please help with the...
  3. P

    Assign the Same Sequential Numbers to Duplicates

    I'm using Excel 2007. I'm trying to reacreate the pattern shown in the sequence column. Could someone please give me a pointer as to how I could do this?
  4. ibmy

    Sum of Negative or Positive, Exclude 0 or Include 0

    Hi Excel Experts ? Sample of 20k row data I face weekday : BCDEF1Sum of Negative Sum of Positive2ValueExclude 0Include 0Exclude 0Include...
  5. W

    How to extract number is a string of text?

    Greetings, This is my string; LANTUS 24 Units in the Morning, 18 Units + HUMLOG at Dinner Time. I need to extract the numbers, 24 and 18. I've seen all kinds of answers, including VBA, which isn't for me. W. Kirk Crawford Tularosa, New Mexico
  6. T

    How to transform a sequence of numbers w/out logical order

    Hi. I have this database and the first column its the subjects # The original data goes something like this: 1 1 2 2 2 3 3 3 4 4 Id like to turn it into something like this: 1a 1b 2a 2b 2c 3a 3b 3c 4a 4b Any tips?
  7. E

    Count unique numbers

    Hi, I am trying to count the numbers from the first column (ItemCode). Some of those numbers are duplicated so the duplicated ones that are the same need to have the same number in the column "Numbers". Meaning for exapmle 31112802 which is duplicated, has a number of 2 and the next 31112802...
  8. B

    Assigning colors to repetitive numbers and more

    Dear Forum Users, I would like to kindly ask for help regarding creating a formula or formulas. As you can see in the file there are a over a dozen tables with 5 numbers in each row in them (the numbers are identical in each of the 14 tables). You can also spot cells designated R1, R2…, R14...
  9. 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...
  10. G

    Data Validation

    Hello all, Trying to add multiple data validations for a cell and having hard time getting conditions to work. Restrictions are numbers between 0 and 100 or just the text value of x. Any suggestions would be great! thanks!
  11. L

    Automatically rank list based on numbers from highest to lowest

    Hi all, I was wondering if it's possible in Excel to automatically rank numbers from highest to lowest? So in this example, you see that the numbers go from 5 to -1, but if I were to change the -1 to 6, Excel would automatically change the list so that cake is first, candy second and chocolate...
  12. E

    How to check this database for duplicates?

    Hi all. I prepared a small example database but it seems that I'm not allowed to post an attachment so I'll try and explain my dilemma by using one of the above tables. <tbody> A B C D E F G etc etc etc etc 39 6 23 34 2 7 26 8 3 35 18 22 7 23 2 39 6...
  13. A

    Not even sure how to explain this in a subject request

    Hi Sorry for the terrible header but i'm not sure how to explain this correctly. On one sheet I have 1 column of numbers. Each number is on a row with further data. Some columns have no data. Some numbers are duplicated in the first column. On a second sheet i have the same list of numbers...
  14. M

    Split string into numbers in Excel VBA

    The string can be like "abc123(456 k789)". It is to be splitted in array like array[0]=123, array[1]=456, array[2]= 789. So the problem is to split array based on numbers.
  15. M

    Ranking using VBA

    I'm trying to rank a list of values using VBA rather than a formula as the numbers will be continually changing. I'm basically trying to run the code at a set point to rank the lowest 3 numbers on the sheet and leave them set rather than recalculating with a formula. Thanks
  16. S

    Search Sheet1 and copy to sheet 2

    I have been tasked with a extracting some data from a spreadsheet not being that good i would like some help with VBA all the data is on sheet 1 and there is duplicated through out. the way it is layed out is where ever there is a part number there is a serial number in the right hand cell...
  17. T

    Maybe a loop?

    Hi everyone, I was wondering if there was a way that i would be able to add up some numbers based on whether or not there was a letter in the cell below the cell i want to include. Currently i have a range of numbers but i need to be able to mark them in some way if they are above or below the...
  18. N

    Search multiple criteria for item

    I'm not sure how to word it, but here goes... I have two spreadsheets (1 old & 1 new) I need to compare specific criteria. I need to search the old CSV of parts and compare to the new CSV of parts and tell me if we have old parts that match the dimensions of the new parts. The CSV headers in...
  19. A

    Vlookup Only The First Lookup Value

    Hello, I think I have a fairly simple problem (but one I can't fix). Column A of sheet "Model" has hundreds of thousands of account numbers, many of which are duplicates. I need to vlookup based on those account numbers to return data from Column B of sheet "Cost", but I only want to return data...
  20. A

    look up across multiple sheets

    Hi everyone, I have an excel workbook with many tabs/worksheets. Each worksheet is in pretty much the same format. The thing im trying to do will work much easier by an automated VBA macro. Something that a little beyond me but I'm getting there. What I want to do manulally is this: In my...

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
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 "".
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