Closed Thread
Results 1 to 2 of 2

Matching 2 digit numbers against 3 digit numbers and counting them with left, right middle

  1. #1
    Forum Contributor Brian.Aerojet's Avatar
    Join Date
    03-25-2017
    Location
    TN-USA
    MS-Off Ver
    2016 365
    Posts
    173

    Matching 2 digit numbers against 3 digit numbers and counting them with left, right middle

    Hi Everyone,

    I had a similar question from last week to the one I need this week.

    I have added a Excel sheet to show example of what I'm looking to do.

    In my excel worksheet attachment I have a column with Dates, a Column with 3 Digit Numbers that are ongoing, a Column with 2 digit numbers (26 of them and will always be the same) and then a column for the formulas that will count the last 3 digit numbers of what is in the 2 digit number column. the formula will go in Column C

    I have a formula for Column A, I manually add column B 3 digit number (Only thing I do Manually on my Workbook), Column D was a one time add only (Don't need formula for this), and Column C will be where the new formula Im looking for, It will have formulas continuing beside the 3 digit numbers in column B (Depending on what 2 digit number is in Column D)

    I will need the formula to count how many times the 3 digits matched from column D.

    I have more notes explaining what im looking for in the attachment.

    Thanks,
    Brian
    Attached Files Attached Files
    Brian

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2507 (Windows 11 Home 24H2 64-bit)
    Posts
    91,816

    Re: Matching 2 digit numbers against 3 digit numbers and counting them with left, right mi

    It’s so similar that it does not warrant a new thread. Please continue here: https://www.excelforum.com/excel-for...in-cell-s.html
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Macro to convert WBS single digit numbers to double digit numbers
    By LeanAccountant in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 06-09-2018, 05:25 AM
  2. Bank Recon - How to convert 8 digit formatted check numbers to 6 digit
    By Quisp in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-21-2017, 09:55 PM
  3. [SOLVED] Extract each digit from 3 Digit Numbers and put in other cells?
    By Brian.Aerojet in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 05-21-2017, 08:20 PM
  4. Macro to identify 3-digit and 4-digit numbers as valid dates
    By gojakie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-16-2015, 08:16 AM
  5. Extract 4 digit common numbers from 5 digit numbers
    By ameque in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-24-2013, 01:09 AM
  6. [SOLVED] macro to extract 9 digit numbers as well as alpha numberic 9 digit numbers from txt file
    By Raju Radhakrishnan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-13-2012, 10:15 AM
  7. To count numbers with 4 digit/5 digit with given Range.
    By ebin charles in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-15-2012, 08:49 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1