Results 1 to 5 of 5

Formula for airway bill numbers

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-21-2009
    Location
    Kuwait
    MS-Off Ver
    Excel 2019
    Posts
    292

    Lightbulb Formula for airway bill numbers

    Dear all,

    Could someone can help me to explaint that what will be the formula to get this result as below

    Stock

    From 111-4444 4504 to 111-4444 4903 = 40 Airwaybills

    Actulay each bill number contains 13 digits including spaces/dashes (111-4444 4504)
    I have to take only 3 digits from the last but before the last digit. (Example 450 - 490)

    Thanks in advance for any help.
    Last edited by tariqnaz2005; 06-23-2014 at 06:02 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 09-29-2005, 02:05 PM
  2. formula to divide a monthly bill...:each row set up
    By DaveB in forum Excel Formulas & Functions
    Replies: 30
    Last Post: 09-06-2005, 05:05 PM
  3. formula to divide a monthly bill...
    By Kim in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  4. formula to divide a monthly bill...
    By Kim in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-17-2005, 05:05 PM
  5. Numbers of minutes in Verizon Wireless phone bill
    By Fred Holmes in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-27-2005, 01:06 PM

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