+ Reply to Thread
Results 1 to 4 of 4
  1. 05-07-2009, 11:12 AM #1
    avk
    avk is offline
    Forum Contributor
    Join Date
    07-12-2007
    Posts
    170

    How to first digit ignore & only start from 2nd digit

    refer attach file.

    I want to how to write formula in B3 (FIRST CHARACTER DONOT CALCULATE i.e. R
    I WANT START CALCULATE FROM 2ND CHARACTER ONWORD i.e. 1040.
    how to write formula in : B3 position.)

    is it possible.
    Attached Files Attached Files
    Reply With Quote Reply With Quote
  2. 05-07-2009, 11:21 AM #2
    oldchippy
    oldchippy is offline
    "Eagle Eyed" Forum Moderator oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Work) and 2007 (Home)
    Posts
    7,130

    Re: How to first digit ignore & only start from 2nd digit

    Hi,

    Not quite sure what you require but may be one of these?

    =SUMPRODUCT(--(Sheet1!$B$2:$B$6),--(Sheet1!$C$2:$C$6=Sheet2!A2))

    or

    =COUNTIF(Sheet1!$C$2:$C$6,Sheet2!A2)

    copy both downwards
    oldchippy
    -------------


    If you are happy with the help you have received, please click the blue scales icon in the blue bar of the post.

    Click here >>> Top Excel links for beginners to Experts

    Forum Rules >>>Please don't forget to read these
    Reply With Quote Reply With Quote
  3. 05-07-2009, 11:24 AM #3
    Mr. Questions
    Mr. Questions is offline
    Registered User
    Join Date
    09-19-2008
    Location
    Wisconsin
    Posts
    7

    Re: How to first digit ignore & only start from 2nd digit

    Try pasting the following formula into B3:

    =VALUE(MID(A3,2,LEN(A3)-1))
    Reply With Quote Reply With Quote
  4. 05-07-2009, 11:37 AM #4
    avk
    avk is offline
    Forum Contributor
    Join Date
    07-12-2007
    Posts
    170

    Re: How to first digit ignore & only start from 2nd digit

    Quote Originally Posted by Mr. Questions View Post
    Try pasting the following formula into B3:

    =VALUE(MID(A3,2,LEN(A3)-1))
    thanks. solved.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.2.0