Results 1 to 7 of 7

Thread: How to create detail invoice from data rows

  1. #1

    How to create detail invoice from data rows



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

    Hi


    I need help to create detail invoice from data rows below :
    What formula to get data (A1:C5) in cell A9,A10,A11....


    Thanks


    A B C
    1 Invoice No Item No Item Desc
    2 PSI0001 STBX0001 Item Desc 0001
    3 PSI0001 STBX0002 Item Desc 0002
    4 PSI0002 STBX0003 Item Desc 0003
    5 PSI0002 STBX0004 Item Desc 0004
    6 .
    7
    8 Invoice No
    9 PSI0001
    10 STBX0001
    11 STBX0002
    12 PSI0002
    13 STBX0003
    14 STBX0004
    15 .

  2. #2
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    869
    Articles
    0
    Excel Version
    Excel 2013
    Quote Originally Posted by heryx View Post
    What formula to get data (A1:C5) in cell A9,A10,A11....
    Please upload your example files with the data and desired results.
    The faster we help you
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

  3. #3
    Quote Originally Posted by navic View Post
    Please upload your example files with the data and desired results.
    The faster we help you
    Hi Navic,

    Example files below, thank you.
    Detil Invoice Line.xlsx

  4. #4
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    869
    Articles
    0
    Excel Version
    Excel 2013
    Try this ARRAY formula (for all column range)
    Code:
    =IFERROR(INDEX($B$2:$B$18;SMALL(IF($E$1=A2:A18;ROW(B2:B18)-1;"");ROW()-1));"")
    see attach example
    Attached Files Attached Files
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

  5. #5

    Talking

    Quote Originally Posted by navic View Post
    Try this ARRAY formula (for all column range)
    Code:
    =IFERROR(INDEX($B$2:$B$18;SMALL(IF($E$1=A2:A18;ROW(B2:B18)-1;"");ROW()-1));"")
    see attach example
    Hi Navic,

    Thanks for ARRAY formula, actually i need to extract the unique field "Invoice Number" then the "Item No" in the same rows.

    See attach file

    heryx-navic.xlsx

    Thanks again

  6. #6
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    869
    Articles
    0
    Excel Version
    Excel 2013
    Quote Originally Posted by heryx View Post
    ......... in the same rows.
    I guess you think the one column/multiple rows?
    Try to look for a solution using VBA or you wait till you hear from someone else.
    Unfortunately I can not help you for this
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

  7. #7
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    869
    Articles
    0
    Excel Version
    Excel 2013
    heryx, you can try Pivot Table (see attach)
    Attached Files Attached Files
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

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
  •