Hi,
Hopefully you guys can help me out!
I have a list of hundreds of invoices for many customers. I am looking for a formula to tell me 1) What is the date of the first invoice for each customer (the first time we ever billed them), and 2) What is the invoice number of the first invoice we ever billed them. The non highlighted sections in my attachment are the type of data I have (just many more lines), and the highlighted cells are what the formula I'm looking for should bring back. Please help me write this formula! Thank you!
Bookmarks