SherryO
04-03-2007, 09:25 AM
Hi,
I have a PivotTable that has Project Numbers in the rows and Dates by Month in the Columns. I'm trying to determine for any given project the last Month of data in the table. What I would like to do, is find the Project number, say row 377, then find the last data in that row (may be not contiguous) and retrieve the column number that it's in so I can get the date. I don't have the option of looking at the raw data, and I can't post the file. Any help would be greatly appreciated.
Thank you,
SherryO
I have a PivotTable that has Project Numbers in the rows and Dates by Month in the Columns. I'm trying to determine for any given project the last Month of data in the table. What I would like to do, is find the Project number, say row 377, then find the last data in that row (may be not contiguous) and retrieve the column number that it's in so I can get the date. I don't have the option of looking at the raw data, and I can't post the file. Any help would be greatly appreciated.
Thank you,
SherryO