Sidvicious843
New Member
- Joined
- Jan 31, 2012
- Messages
- 12
I am working with some Time Series data that has one unique ID per row and columns of gift information:
The columns accross the sheet look like this:
ID Gift1 date1 Gift2 Date2 Gift3 Date3 Gift4 Date4 Gift5 Date5... etc
I am looking to take the maximum gift and its corresponding date and pull them into seperate columns. I am using the max() function to pull the max gift but was wondering how I could pull its corresponding date as well.
The columns accross the sheet look like this:
ID Gift1 date1 Gift2 Date2 Gift3 Date3 Gift4 Date4 Gift5 Date5... etc
I am looking to take the maximum gift and its corresponding date and pull them into seperate columns. I am using the max() function to pull the max gift but was wondering how I could pull its corresponding date as well.