Results 1 to 3 of 3

Match Function for Split Numbers

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-07-2015
    Location
    Tehran - Iran
    MS-Off Ver
    2013
    Posts
    111

    Match Function for Split Numbers

    I have couple of numbers into a cell (Column "A") and I have separated them in columns "B" and "C". My problem is: When I use from MATCH function (F2), there is the error on cell (Please see attached excel file). But if I use copy and paste of data, I can reach to true answer. How can I remove the error?
    Thanks in advance for your help.
    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. Using the Split function to return column numbers
    By mitchbvi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-16-2019, 05:06 PM
  2. How to split numbers to specific name and total and split
    By ashokavarthanan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-13-2015, 09:12 AM
  3. [SOLVED] Function to split numbers from cell in ascending order
    By Karnik in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-26-2015, 01:00 AM
  4. Can excels Split() function split a string up at multiple spots?
    By 111StepsAhead in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-14-2011, 02:36 PM
  5. function or vba to Split numbers from one cell
    By flebber in forum Excel General
    Replies: 6
    Last Post: 07-28-2010, 07:33 AM
  6. [SOLVED] match numbers function!
    By stewart08 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-05-2008, 10:42 AM
  7. [SOLVED] rounding numbers for match function
    By erc_blair in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-14-2006, 11:15 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