1. B

    Count Unique Alphanumeric numbers in a column with a date range criteria (not using array)

    I'm wanting to count unique alphanumeric value from column 'user ID', but I'm wanting to include a criteria of date range where column 'Date' is between 12/12/2019 - 18/12/2019. I've tried numerous array formula's but they're all too slow so i'm wanting to know if it's possible to do it without...
  2. Y

    Lookup between alphanumeric range?

    Hello, Probably being thick here and the obvious answer is alluding me but I need a formula to return a value based on where something is between a range of alphanumeric characters. At a basic level something like the below: <tbody> Start Location End Location Who A001 A100 MT A101 A200...
  3. A

    VBA - get alphanumeric code using date in column header

    Hi again, i am trying to copy a alphanumeric "name" from column A to my source workbook. These names are the usernames of people responsible for particular shifts. <tbody> #FFFFFF[/URL] , align: center"] #FFFFFF[/URL] , align: center"] #FFFFFF[/URL] , align: center"] #FFFFFF[/URL] , align...
  4. Q

    Sumifs returns 0 value for alphanumeric sumrange

    Hello All, So my data from where i want to pull the sum range contains alphanumeric values in like "GS08, GS09, GS10" The criteria1 range is the range for unique client reference nos. in cells A2:A2688. Criteria1 is to pull each inidividual client reference no. for eg. 64852345. Criteria...
  5. P

    Formula to get data with specific logic from a string

    I have below data in column A, in this string suffixed with data like "(12345/A76D7YF)". I need numeric and alphanumeric character in two different columns. Please note that customer names before above section may also contain (, ) and /. Uniqueness of column A is that after the last open...
  6. M

    Extract numbers from alphanumeric strings

    Hi all, how can I extract (by VBA) this numbers: 149575 191368 191369 with prefix "DUD" and suffix "/nn" from alphanumeric strings with so DB: DUD 149575/18 DUD 191368/17 Ton 39.00, DUD 191369/18 Ton 9.04 Tia. Maurizio
  7. D

    Vlookup alphanumeric cells in a range

    Hello. I am trying to look up alphanumeric values against an alphanumeric range. I can do this against an all-number range, but can't figure out the alphanumeric equivalent. The challenge is that, because it is alphanumeric, I can't define a clear range for Excel. In my numeric lookup, if the...
  8. P

    Allow only certain alphanumeric data in a range

    Hey guys, I need a small help. In my sheet "PRODUCT" range "A1:A150" I want it to only only certain alphanumeric data. I want it to allow only "AK1, AK2, AK3, AK4, AK5 ....... AK100" and "OR1, OR2, OR3, OR4, OR5 ..... OR100" If a user enters anything other than this, then I dont want excel to...
  9. B

    Extracting alphanumeric data

    Excel Guru and Excel expertise I like to ask that I am having alphanumeric data so I want to extract alphabets in one row and numeric in another group example abf145tf=abftf 145 ghj75kl=ghjkl 75 Please hoping answers from excel gurus
  10. P

    How to sum cell with any non numeric characters

  11. R

    Restrict textbox input to alphanumeric AND dash and underscore?

    Hello, I currently have a userform with a textbox that limits the user input to accept only alphanumeric. I had found that code in an older thread on this board here. The code works great but now I've decided that the user should also be allowed to include "-" and/or "_" along with...
  12. B


    I have a program that runs off of the data ID (which is for different employees) within Access that makes a barcode. Is there a way to make the data ID alphanumeric? so I want the data ID to be "BAY001 (Bill Brittain), BAY002 (Erick Vaughn), BAY003 (Johan Collins)" and so forth for each...
  13. machopicho

    Alphanumeric string in a cell

    Hi there, i have this problem to solve. In cells i have variable alphanumeric strig as: A1 vbnxm1234 A2 ehfk567 A3 tugfoejrti1597536 and so on. I must extrac string of numbers with a formula if possible... Who is help me??? :-) Thanks to all!
  14. C

    Extracting multiple values from alphanumeric text based on set criteria

    Hello there, I have a set of data which contains part numbers in text fields. Every part number starts "288" and has 10 digits. Because the part number can appear in several columns (but not explicitly) I have concatenated the relevant columns into one alphanumeric column. What I want to do...
  15. L

    Uppercase letters in alphanumeric entry

    Thanks to anyone who may be able to help. I have two columns in a worksheet that require alphanumeric entries. The columns in which the alphanumeric data are entered are column A and column B. Would it be possible to write a VBA code that would change the lowercase alpha characters to...
  16. A

    How to extract any character / or alphanumeric among out of 20 alphanumeric character in excel sheet.

    Dear All, How to extract any character / or alphanumeric among out of 20 alphanumeric character in excel sheet. For e.g. out of 20 alphanumeric i want to extract character no 10 , 11 , 12. Any Assistance, Rgds, aligahk06
  17. M

    Alphanumeric lookup

    Hi, I need to lookup a values in columns in two spreadsheets - the codes I'm looking for are alphanumeric e.g M2971, if the code is present in a column then I would like it to return the word "yes". I've tried Vlookup and changing the format of the cells to TEXT but this doesn't seem to work -...
  18. A

    Automatically generate alphanumeric user id when userform open in excel

    hii friends, I'm new in excel vba,i just want to make a student database in excel userform, and there is a column student id, which is the alphanumeric serial like "ICE/ANG/1001".every time when i open the userform to enter a new student database the id text box goes to auto fillup or generate...
  19. Smokeyham

    Sorting Alpha-Numeric Data

    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
  20. A

    VB Help

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

Watch MrExcel Video

This Week's Hot Topics

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