Pivot Table Query
 

I'm trying to work out how to calculate the number of consecutive days
that a positive value is shown in a row. My data is summarised in
descending date order in a pivot table. Any ideas?

:confused:


--
sgriff
------------------------------------------------------------------------
sgriff's Profile: http://www.excelforum.com/member.php...o&userid=36461
View this thread: http://www.excelforum.com/showthread...hreadid=563579