Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting Latest Invoice from a Group of Invoices
I have a list of part numbers in one list and a list of part sales invoices
in another. Need to select, for each part number, the latest invoice. How can I do that? Thanks very much. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting Latest Invoice from a Group of Invoices
If you had a list of invoices in Column A and corresponding part numbers in
column B, and you also had an example part number in C1, the following formula in D1 would give you what you want: =MAX(IF($B$1:$B$100=C1,$A1:$A100,0)) But make sure you enter it using Ctrl + Shift + Enter as it's an array formula. This also assumes your invoices are numbered sequentially. Sam "bhud@fac" wrote: I have a list of part numbers in one list and a list of part sales invoices in another. Need to select, for each part number, the latest invoice. How can I do that? Thanks very much. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting the latest record for transactions | Excel Discussion (Misc queries) | |||
On Excel Invoices it gives an invoice number-can be seq #'d??? | Excel Discussion (Misc queries) | |||
Separating invoices by invoice date then summing by quarter | Excel Worksheet Functions | |||
Can I group overdue Invoices by date from an Excel worksheet? | Excel Worksheet Functions | |||
How do I set up invoices to automatically change invoice numbers? | Excel Discussion (Misc queries) |