+ Reply to Thread
Results 1 to 8 of 8

Create formulas to find number follow same number invoice but difference supliers

  1. 09-17-2017, 10:09 PM #1
    ninhmoon
    ninhmoon is offline
    Registered User
    Join Date
    04-07-2015
    Location
    Vietnam
    MS-Off Ver
    Office 2013
    Posts
    89

    Create formulas to find number follow same number invoice but difference supliers

    Hi
    I have a file
    I want to find a formulas for that file
    I attach my request in file
    Please help me.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-18-2017, 01:18 AM #2
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Create formulas to find number follow same number invoice but difference supliers

    Try this in cell W11 and fill down.
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Dave
    Reply With QuoteRegister To Reply
  3. 09-18-2017, 02:24 AM #3
    ninhmoon
    ninhmoon is offline
    Registered User
    Join Date
    04-07-2015
    Location
    Vietnam
    MS-Off Ver
    Office 2013
    Posts
    89

    Re: Create formulas to find number follow same number invoice but difference supliers

    Quote Originally Posted by FlameRetired View Post
    Try this in cell W11 and fill down.
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Dear!
    Thank for helping me
    I done it.THank you very much.
    I vote you a star.
    Reply With QuoteRegister To Reply
  4. 09-18-2017, 02:31 AM #4
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Create formulas to find number follow same number invoice but difference supliers

    You are welcome. Thank you for the feedback and added rep. If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    Reply With QuoteRegister To Reply
  5. 09-22-2017, 01:53 AM #5
    ninhmoon
    ninhmoon is offline
    Registered User
    Join Date
    04-07-2015
    Location
    Vietnam
    MS-Off Ver
    Office 2013
    Posts
    89

    Re: Create formulas to find number follow same number invoice but difference supliers

    Quote Originally Posted by FlameRetired View Post
    You are welcome. Thank you for the feedback and added rep. If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    Are you still there, Mr FlameRetired?
    I applied your formulas, but the file was applied which is very slowly.
    Can you create again your formulas for me?
    Thanks!
    Reply With QuoteRegister To Reply
  6. 09-22-2017, 06:24 PM #6
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Create formulas to find number follow same number invoice but difference supliers

    I'll do my best. I need more information.

    Are you applying that formula over tens of thousands of cells?

    If so try this formula
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Last edited by FlameRetired; 09-22-2017 at 06:41 PM. Reason: on afterthought decided to post a formula
    Reply With QuoteRegister To Reply
  7. 09-22-2017, 09:14 PM #7
    ninhmoon
    ninhmoon is offline
    Registered User
    Join Date
    04-07-2015
    Location
    Vietnam
    MS-Off Ver
    Office 2013
    Posts
    89

    Re: Create formulas to find number follow same number invoice but difference supliers

    Quote Originally Posted by FlameRetired View Post
    I'll do my best. I need more information.

    Are you applying that formula over tens of thousands of cells?

    If so try this formula
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    THanks!
    Your formulas, it is ok
    I am using other formulas: =IF(COUNTIFS($E$11:E12,E12,$K$11:K12,K12)=1,"MH"&TEXT(RIGHT(W11,4)+1,"0000"),W11)
    Reply With QuoteRegister To Reply
  8. 09-23-2017, 10:57 AM #8
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Create formulas to find number follow same number invoice but difference supliers

    I thought that formula was performing too slowly. I am confused. Can you clarify?
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Create Unique Sequence Number in Cell for invoice
    By ioannisg in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-14-2015, 10:08 PM
  2. Find number difference 0 instead of number 1
    By ninhmoon in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 06-27-2015, 12:30 AM
  3. Need a way to find typo's in an invoice number
    By salestemp in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-12-2015, 04:02 PM
  4. I need a macro that will create a new sheet, generate invoice number
    By Daotor in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-05-2013, 09:20 AM
  5. [SOLVED] How to add letters and numbers together to create a string for an invoice number
    By muddbog in forum Excel General
    Replies: 4
    Last Post: 03-25-2012, 03:09 AM
  6. Create an Invoice number?
    By DHCS in forum Excel General
    Replies: 1
    Last Post: 01-18-2007, 12:49 PM
  7. [SOLVED] Can I create an invoice that will number itsself?
    By llpc2004 in forum Excel General
    Replies: 2
    Last Post: 08-02-2005, 05:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1