+ Reply to Thread
Results 1 to 3 of 3

Count same digit numbers from each row

  1. #1
    Forum Contributor
    Join Date
    07-17-2020
    Location
    Uzbek
    MS-Off Ver
    Office 365, V 2212
    Posts
    198

    Count same digit numbers from each row

    Dear Excel Forum Team,

    I have some data and would like to count same numbers from another data from each rows using Access.

    I have ready template with formula in Excel but is working extremely slow with a huge data. The attachment is for your perusal plz.

    So appreciate if someone could provide me same as attached excel calculation in Microsoft Access please.

    Thanks in advance
    Attached Files Attached Files

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Count same digit numbers from each row

    We're talking Excel here not Access
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,873

    Re: Count same digit numbers from each row

    Instead of me trying to reverse engineer your formula, please explain in explicit detail what you are trying to do. Once we understand your needs, then perhaps we can give you a solution. Remember, not all Access gurus are Excel gurus. Is it safe to assume that Data Tab represents your Source table? I am assuming that you will need to build a query.

    As an aside, you have marked this as solved. Is it? or is that an error.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Count same digit numbers from cell
    By Gulya in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-12-2020, 01:10 AM
  2. [SOLVED] Count same last digit numbers and neighbouring numbers
    By Gulya in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-20-2020, 05:47 PM
  3. [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
  4. [SOLVED] Formula for getting the digit count between two numbers?
    By mix_mash in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-01-2017, 06:11 PM
  5. [SOLVED] Need to count only 6 digit numbers
    By Sekars in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 06-02-2017, 10:47 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