prefix

  1. L

    Countif formula returning the same results for entire data range that start with a prefix of < >

    Hello! I'm building a dashboard and using “COUNTIF” to simply count the number of times a complaint isowned by a particular person or process… The issue I’m having is new ownershave been added to the data and the begin with < or > for example <over font="" old<="" 5years=""></over>...
  2. Dazzawm

    Help & Advice On A VLookup/Match Maybe?

    I don't really know how to explain this!! I have 2 sheets with a massive amount of data. Sheet 1 will have numbers with a 2 letter prefix then 4 or 5 numbers then letters again, and so will sheet 2. I need to match up ignoring the last letters. <b>Excel 2010</b><table cellpadding="2.5px"...
  3. E

    Scrape web page

    Hi, I am looking for code that would be able to scrape a link like this ? https://future.pinnacle.com/en/baseball/mlb/houston-astros-vs-detroit-tigers/987051592/ There would be multiple links that it would have to run through that would have the same structure. The prefix would always be...
  4. L

    Return Full Cell Text based on Prefix Lookup

    Hello Everyone, thanks in advance! On Sheet 1 in cell A1, I have a can type a prefix (e.g. "CZ1-1123TRH-2200-") and there is a table on a Sheet 2 wherein Column A includes hundreds of values with several prefixes and multiple suffixes for each that create several "assets" (e.g...
  5. L

    why I am not to copy cells after blanks by using VBA code

    please see exmple below: when I ran my macro its only copy data up to Transection number and not all way to part number and I want all the columns in my break-up files.. I know I messing somewhere and would appreciate the additional help. Thx a lot for your reply. Set rng = cll.Resize(limit...
  6. JLGWhiz

    multiple users with same user name prefix

    Just wondering if anyone knows the story behind the &#x2605 user name prefix. All of the threads that I have viewed that use that prefix seem to be homework type questions and I am hesitant to respond to them. The latter part of the name varfies from thread to thread but the &#x2605 is always...
  7. J

    finding substring from a string with dashes

    I have parts in the following format: <tbody> ABVD-JtU5d-NR393. Where the prefix, base and suffix can be any length., but there are always two dashes. I need to add a column to show the prefix, base, and first letter only of suffix. So for the above part, i want to extract ABVD-JtU5d-N...
  8. dannyok90

    Sequencial VBA ID Number

    Hi all, im sure theres a simple answer to this but im struggling - as usual :D haha the code below inserts a new row and stamps a unique id in cell b using the date and time with a prefix "GO" Rather than stamping the date/time id like it to stamp A00000 then A00001 and so on. If i add a blank...
  9. B

    Unique List Generator Based on Prefix

    ****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;"> <tbody> A B C D 1 List Prefix List 2 N12111 N1 N12111 3 M14999 N12987 4 N12987 N12555 5 A33001 6 N33444 7 N12555 8 A33888 9 10...
  10. Colin Legg

    _bdm. names in Name Manager

    Does anyone know which add-in creates names with a _bdm. prefix? An example: _bdm.8967E1C0A2914A6EB0F4E56B3B28F0A2.edm
  11. F

    Array formula to expand complex list of numbers with same prefix

    I request help to get a very complex output, so it seems a very complex array formula could be needed. My inputs are 2 numbers that share a common prefix. The first number is the common prefix and the second has a few numbers more and I need to get a list expanded up to the second number. This...
  12. F

    Array formula to get longest common prefix

    I have a list of numbers and I want to get the common prefix between them. I've been able to make this array formula that gives me correct output but comparing only 2 numbers (stored as text). A1=23702000000 B1=23702999999...
  13. C

    How to link a Module to a Userform to automate changing.

    <!--[if !mso]> <style> v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} </style> <![endif]--><!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings>...
  14. D

    VBA set sheet based on sheet Array and Part of Cell Value Array

    Hi, My Code below is so I can get the cell value from the lookup workbook and add it to the Active Workbook if both cells values are the same What I would like to do is match part of a cell value to a sheet name and set that sheet as the look up sheet. Each part of a cell value will vary but...
  15. D

    Programatically add prefix to all named ranges

    In my workbook I have many named ranges. I want to add a prefix "P_" to each name. Is there a way I can do this with VBA to save time? Thanks
  16. X

    Macro adding language codes to the names of packages

    Hello, I need a macro, which would go inside every zip package, remember the name of language folder inside and add that name to the beginning of package's name. Example: I have many packages in location: c:\Desktop\packages\ The packages' actual names look like this...
  17. C

    Longest Prefix Match for Phone Numbers

    Hi all, This is a problem I've been grapping with for a few months on and off and I can't seem to crack it... I have a CSV list of call detail records and a list of long distance rates and I need to be able to match the rate to the phone number based on the longest prefix match. Here is...
  18. P

    Add a prefix to a file name?

    Greetings, I have a macro that creates a new workbook and saves it with the file name composed of a number in cell A09. ActiveWorkbook.SaveAs Filename:=ThisWorkbook.Path & "\TDN Forms\" & Worksheets("Rev #").Range("AO9") & ".xlsx", CreateBackup:=False How can I insert a prefix to the file...
  19. O

    LOOKUP(1E+100, SEARCH.... issue

    Hi, Im having a problem with the spreadsheet I am working on. I thought everything is working perfectly, until I noticed some issues where the formula is not pulling the correct data I was looking for. So I have a database with a column "Destination prefix" and another column for list price...
  20. KBBersch

    Find maximum number pith alpha prefix

    I have a column that contains asset numbers in the form of PDL-xxxx and PTF-xxxx. I need to display the maximum number for each prefix, or better yet the next available number for each prefix. More entries will be added and the cells need to update as that happens. I tried...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top