vbacoder
Active Member
- Joined
- Jul 7, 2007
- Messages
- 354
Hi everyone,
I have a pivot table with a list of items in different rows on the left/y-axis side and years along the top (x-axis side). The table is populated with the frequency of occurrence of each item in the list - e.g. if Item A was found 5 times in the year 2010, there would be a 5 in the row for Item A and column corresponding to the year 2010. If there are no occurrences then the cell will be blank.
What I would like to do is to find the find the year of the first occurrence of each item in the table. Foe e.g. if Item A had no counts in years leading up to 2001, with at least one count in 2001, then the first year of occurrence would be 2001. Just can't think of an efficient way to do this.
Any help would be very much appreciated! Thank you very much in return.
vcoder
I have a pivot table with a list of items in different rows on the left/y-axis side and years along the top (x-axis side). The table is populated with the frequency of occurrence of each item in the list - e.g. if Item A was found 5 times in the year 2010, there would be a 5 in the row for Item A and column corresponding to the year 2010. If there are no occurrences then the cell will be blank.
What I would like to do is to find the find the year of the first occurrence of each item in the table. Foe e.g. if Item A had no counts in years leading up to 2001, with at least one count in 2001, then the first year of occurrence would be 2001. Just can't think of an efficient way to do this.
Any help would be very much appreciated! Thank you very much in return.
vcoder