Results 1 to 2 of 2

Thread: Auto numbering the matched items in excel

  1. #1

    Auto numbering the matched items in excel



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,

    I have to reconcile an external stock rec every month, i match the units using vlookup or match function, but the match number i input it manually.

    My question is, is it possible to do it with any function or formula.
    Click image for larger version. 

Name:	12345.JPG 
Views:	9 
Size:	22.4 KB 
ID:	2628

  2. #2
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    767
    Articles
    0
    Excel Version
    2010
    If the match number is simply incremented by 1 for each pair, can't you just add one to the previous one if the stock code has changed?

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •