I am trying to do is extract the volume size of products in 'ml' from 10k plus products from a description field cell. this description field could also contain the weight of the product in grams so I cannot just do a search for a numeric string , it has to be associated with the milli-litres statement .
is is possible to do a sort of ' *ml ' search and then select and copy to another cell ???
Given 5 rows in column A, I have strings that has the word 'Qty' and some none. For any string that has the word 'Qty', I want the numeric value before it. For string that doesn't have the word 'Qty', I want it to be 1. My question is, how should I added the numeric string without a helper column?
Column A Desired Qty to Take
some string name and ended with (4 Qty) 4
some string name without the word Qty 1
In the above example, I would like to have an answer in say cell B1 to be 15
IDMacro Out Put X11891189 cdecde CONFRCONFR 175175 D0101101
I ahve a sheet having two column one is "ID" and other is "Macro Out Put" as shown above , is that possible with VBA code that it give the same result as i shown above in column "Macro Out Put". for reference i also attch the file
I need to be able to locate a date in a spreadsheet bassed uppon a user input date. I am looking for the week that contains the user's date. However it seems even if I initialize the value as Date, it still reads the user's input as a string.
Is there an easy way make sure the system automaticaly recognizes the user's input as a date, or is there a way to quicly convert the string to a date?
I have created a macro that searches for an existing part in my worksheet and copies the found part to the row above. I would like to increment the value of cells B and H in the new copied row. Both cells contain an alphanumeric string that ends with a numeric value. For example cell B has a string like this "APL-DK0030" and cell H has a string like this "Dell Optiplex GX260 V09"....
Looking to extract a numeric value with two letters attached to it from text strings. The text strings vary. Below are the examples I'm looking to extract .51OZ from the first cell, 12CT from the second, and 30CT from the third.
BEANO AD A-G LIQ RS 0.51OZBEANO AD A-G TAB-CHW RS 12CTBEANO AD A-G TAB-CHW RS 30CT
I have another problem with this damn address file. Column H and I have data in them that is often mixed. As shown below, I have used A and B below, but its normaly in Column H and I. I would be greatul if some could write a macro to split the data into the two columns.
Rows 2-8 is what Im presented with. I would like them to look like 11-17
Note that the number in row 8 does not match, so is left for manual intervention....
I have been looking for code samples using Find to search for values within or outside a given value range. I haven't come across any that are obvious to me so is it possible?
I am using a piece of code that jindon here on Ozgrid has so kindly been helping me with. The code below searches for a certain value and returns that value when found along with other values. I am trying to adapt this same code to work on other searches I perform.
An example I am looking at is finding any values in column "K" which are either less than 700 or greater than 1300. How would I alter this code to perform a search like that?
Option Explicit Sub test7() Dim r As Range, ff As String, txt As String With Sheets("Sheet1") Set r = .Columns("av").Find("D00025", , xlValues, xlWhole) If Not r Is Nothing Then ff = r.Address Do
I am trying to check some data (about 5000 rows worth) and don't want to have to go through each row. What I need to do is check whether the 7th number in a string is below 5, and then to return a text result for above 5 and a different result for below 5. For example:
B4: 88050170088 7th value = 7, therefore return "Male"
I have tried =IF(MID(B4,7,1)>5,"Female","Male") but it is not working and I can't figure out why..could also just be making a rookie mistake....
Is there a function within Excel, that allows you to search for any relevant cells that have a hardcoded amount within a formula, ie. adding, subtracting, dividing or multiplying a harcoded number. eg. cell B2 + cell B3 + 5 and then identifying that cell because it has a +5 (however, being able to identify any hardcoded number anywhere from -9,999,999,999 to 9,999,999,999)
In have a worksheet with about 5,000 rows. In column there is a unique identifier for each row, however the unique identifier can take one of 12 different formats, namely:
L1314LAND00001 through to L1314LAND0XXXX L1314CUST00001 through to L1314CUST0XXXX L1314COMM00001 through to L1314COMM0XXXX
M1314LAND00001 through to M1314LAND0XXXX M1314CUST00001 through to M1314CUST0XXXX M1314COMM00001 through to M1314COMM0XXXX
N1314LAND00001 through to N1314LAND0XXXX N1314CUST00001 through to N1314CUST0XXXX N1314COMM00001 through to N1314COMM0XXXX
S1314LAND00001 through to S1314LAND0XXXX S1314CUST00001 through to S1314CUST0XXXX S1314COMM00001 through to S1314COMM0XXXX
These unique identifiers won't always appear in sequentiual order. In Cells B2 to M2, I want to be able to determine what the next entry for each of the twelve variations will be, so for example, if the current highest value in column A for the 'S1314LAND' range S131400421, in cell K2, I would want it to display S1314LAND00422, and if the current highest value in column A for the 'M1314CUST' range M1314CUST0036, I would want cell C2 to display M1314CUST0037, so anyone at a glance can see the next highest unique reference for the relevant set, rather than having to go through the unique identifiers in column A manually to determine the next entry in the series.
I'm not really sure where to start, when there can be more than one aplhanumeric entries ending in the same number, e.g. S1314CUST00500 and M1314LAND00500.