I would like to have a formula that would sort through the Location & Date data, and for every unique date as it applies to a location, return to a new sheet a single location value; For Ex: for Paris, it shows 3 dates (2/1), I'd like for the formula to return one Paris even though are 3 corresponding dates (just want one instance of the location per unique date, even if multiple dates).
I was thinking v-lookup, but having no luck.
Thanks for any help.
<tbody>
</tbody><colgroup><col><col></colgroup>
I was thinking v-lookup, but having no luck.
Thanks for any help.
Location | Date |
Paris | 02/01/2013 |
Paris | 02/01/2013 |
Paris | 02/01/2013 |
Germany | 02/01/2013 |
Germany | 02/01/2013 |
Germany | 02/01/2013 |
Germany | 02/02/2013 |
Germany | 02/03/2013 |
Germany | 02/03/2013 |
Texas | 02/05/2013 |
Texas | 02/06/2013 |
<tbody>
</tbody><colgroup><col><col></colgroup>