based on index

  1. F

    Find smallest date based on the condition of another cell

    I have a table with customer orders which are dated and index by customer id: customer1, 1/1/2002, etc... customer2, 1/1/2003, etc... customer2, 1/1/2004, etc... customer1, 1/1/2005, etc... I want to find the date of the first and last order a customer made with me. The end report I want is...

Some videos you may like

This Week's Hot Topics