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
I have this database and the first column its the subjects #
The original data goes something like this:
Id like to turn it into something like this:
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...
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...
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...
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!
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...
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.
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...
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.
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...
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...
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...
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...
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:
I have a specified range selected.
Range(ActiveCell.Offset(0, -9), ActiveCell.Offset(0, -3)).EntireColumn.Select
Now, I have to replace all numbers with zero in the above range, except formulas.
Can anyone help me?
I currently have 2 sheets of serial numbers sheet 1 has all of the new serial numbers on it and sheet 2 has both old and new serial numbers on. I am currently trying to bring all of the old serial numbers into the sheet 1 but due to the nature of index match and vlookup I am only able to pull in...
ok, i'll explain as best I can
in d2:s2 I have week numbers
in a3:a100 I have part numbers
what I am looking to achieve is if I populate (as an example) h15
a formula in c15 will populate with the relevant week number from row 2