0
I need to find the last date an SKU was updated please. There could be blanks or zeroes in the data so I need to exclude them.
Peter Konnecke
Posted 2016-05-19T01:00:26.583
Reputation: 1
2
This will find the last date that is not blank or 0:
=INDEX($B$1:$D$1,AGGREGATE(14,6,(COLUMN($B2:$D2)-1)/(($B2:$D2<>"")*($B2:$D2<>0)),1))
Scott Craner
Reputation: 16 128
Asked: 2016-05-19T01:00:26.583
Viewed: 40 times
Active: 2016-05-19T04:25:28.500