alphanumeric

Seems this should be fairly simple, but various things I have tried after Google searches have not worked. I would like to sort the following in Alpha-numeric order, but can't get the number sorting correct. P101 P102 P103 P104 P105 P106 P107 P108 P109 P110 P111 P43 P50 P78 P79

Hi - Im trying to enter an array formula into VB if possible - i know the formula is too big but struggling to get it to work. the formula im using is entered in Cell C180 and looks like this. =SUM(--(FREQUENCY(IF('Raw Data Prev Year'!$B:$B<>"",IF('Raw Data Prev Year'!$D:$D=A171,IF('Raw...

Hello, I am not sure if this can be done with a formula, but if it is, I would appreciate the help. I have a set of data some of which can be repeated several times in the same row. And if the values are repeated, I'd like them to be displayed with alphanumeric symbols. For example, If data...

Hi all, I'm having a problem repeating/adding this formula in the same cell with another condition. =IF(OR(D8="S1", D8="S2", D8="S3"), "PSC-S-"&TEXT(ROWS($1:1),"0000"),"") D8 is a drop down list with different items. I want to plus the above formula with the one below in the same cell...

Hi all, i have the following code which puts a sequential number in column P, which is fine. My question is how do i prefix this with the letters VOMH and then have leading 0's (zeros) in the column, ie VOHM0001, VOMH0002 and so on. Any help appreciated Private Sub CommandButton2_Click() If...

Hi, I have few rows of data <tbody> COL A COL B C1 0.2 C100 0.3 C101 0.4 C2 0.6 C201 0.7 C202 0.8 R3 0.9 R301 1 R302 2 </tbody> Expected Result <tbody> COL A COL B C1 0.2 C2 0.6 C3 0.9 C100 0.3 C101 0.4 C200 0.6 C201 0.7 C202 0.8 R3 0.9 </tbody> Bottom...

Hey guys, how can I use Range.Autofilter to filter out a general alphanumeric code such as "A123" or "X029" (letter followed by three numbers)? I've been Googling and trying everything and I can't get it. The following will show me anything that begins with a letter... but that's as far as I've...

I am writing a macro to return the sum of the amounts in a column C (CHECK_AMT) when the criteria in column B are met. I am having trouble differentiating the column B (FILENO) results: <tbody> FILENO CHECK_AMT 100X2943 175 100X3076 200 100X692 25 11BB47 25 1B1083 150 1B1266 25...

Hi there, I have a list of part descriptions that I need to extract part numbers from. These part numbers may be purely numeric, alphanumeric, or contain hyphens, underscores or special characters: e.g. <tbody> Descriptions Part numbers Handle #09-ir2135ti #09-ir2135ti D90-330-EX...

Hi, I have the following data set where I have three columns: Name, Date and ID. I am trying to identify the latest date against each name and in some cases where the dates are duplicated (as in case of John, 15/05/15) I want to be able to identify the name against latest date and highest ID...

I'm having an alphanumeric sorting issue. Other solutions I have looked at will add a column to resolve the issue but this does not solve for alpha only rows. The link below shows the data as imported into google sheets not excel. I need the data sorted by column A 1, 1a, 2, 2b,..., a to z...

Hi, I am relatively inexperienced Excel user and am trying to create a list of 6 digit alphanumeric serial numbers in Excel. I am looking for help to sequence 2 series of alphanumerics with the following rules Series 1 - 2 letters in any of first 4 positions, 00AA00 until YY0000 Series 2 - 3...

I've been trying to researching the net to try and solve this problem on my own for about a week now- I still have not figured it out yet! Hopefully someone else more experienced than I can tell me what I'm doing wrong! What I've tried so far: Checking for spacing issues (there are none)...

In cell E2 i have the alphanumeric value K940001. In cell E3, i'm supposed to get K940002. So, what formula/ function do i use? It's like for a column named Student IDs so K will be constant and the numbers just keep increase 94003,94004 and so forth.

Hi I am looking to get help with this... I have 2 columns i want to find out which items match in each column and put the matching value in column c. I have tried Vlookup and continue to get an N/A .. I tried countif and I get either an N/A or a value error. I have tried turning the cells into...

How to remove symbols( positive and negative) from alphanumeric numbers?

Hi, I'm trying to find the difference between two alphanumeric cells. For example: <tbody> C K P 1 1AB 2BC 1 2 2AB 4BC+ 2 3 2AB 5BC 3 </tbody> Conditions: - The columns that I am comparing are not next to each other, nor do they start at A1. - The letters in the cell do not need to...

Hi all- I am in the middle of a HUGE dataset and having some trouble calculating the correct units of measure value so I can accurately calculate "net cost". An example is below: Unit Amount: 50 EA/BX 4 BX/CA Unit of Measure: BX Cost per Unit: $9.40 I have a code that I have used to parse...

Hi all, I am trying to parse some alphanumeric data for inventory purposes and am having a hard time pulling out the numbers. Please see below for what I'm working with. The end goal is to see "TOTAL UNITS" ie for the first one 4, 720 (ie 60*12), 6,1, 25, 100 I have seen VBA/etc. for pulling...

Hello Everybody, I got a simple sheet in which I got some columns of data representing certain grid-line i.e. A-25, B-35, C-41 etc and I got another column in which the data is like B-25.5, C-26.5 etc. I want to compare the both columns and know for each item that which item is bigger or...