Results 1 to 5 of 5

Locate the "First" Digit of Number from a range of cells (Only from 4 Digits Numbers)

Threaded View

  1. #1
    Registered User
    Join Date
    04-29-2020
    Location
    Kuala Lumpur
    MS-Off Ver
    365
    Posts
    13

    Locate the "First" Digit of Number from a range of cells (Only from 4 Digits Numbers)

    Hi All Experts~

    Good day!

    1. I have a range of cells contains 3 digits and 4 digits of numbers randomly
    2. Each cell numbers are random and can start with any numbers
    3. I need to locate each cell first number (and count it), but only choose from 4 digits selection.
    4. Count result are distributed 1 to 9 respectively

    Ex
    1281 2550 190
    2281 3184 205
    2334 4056 2236
    2377 4707 2274
    2413 6084 2400
    6236 8001 3240
    6270 8312 4613
    8079 8648 4906
    8676 8656 7097

    I managed to get the answer but it only work on all digits (3 & 4)

    Attached herewith the sample workbook

    Thank for the helps in advance
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Listing Range of Numbers, Given "Starting Number + x"
    By your in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-18-2023, 08:27 AM
  2. [SOLVED] Formula to Locate Matching Data in Worksheets and return "1" or "0" to a specified Cell
    By hammer2 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-30-2015, 04:52 AM
  3. Replies: 5
    Last Post: 01-23-2014, 11:02 AM
  4. List Data Validation + option of "INC"+12 digit number"
    By penfolda in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-29-2013, 02:53 AM
  5. Eliminating duplicate "digits" in numbers
    By khank in forum Excel General
    Replies: 5
    Last Post: 03-13-2011, 03:10 PM
  6. Removing digits after decimal in "text" numbers
    By jermsalerms in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-21-2006, 01:52 PM
  7. Replies: 0
    Last Post: 09-06-2005, 02:05 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