I took Daffy333's suggestion and it getting me closer. It returns the MIN in the whole array, but not the MIN of each unique client. I've updated the spreadsheet:
https://docs.google.com/spreadsheet/ccc?key=0AizfNmXXHvYrdHVaaDJTd0FlZVRyYXRhU2duaVUwU3c&hl=en_US
Luke, does this clarify the my...
Good afternoon.
I have a list of clients, with multiple users within each company. I have a column that tells me the number of days since any one user has purchased a product. I need to add 2 columns that will ultimately be used in a pivot table to:
1) Identify unique clients, not unique...