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
    169

    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
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    40,531

    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!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

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