Hello,

I have the following in sheet1

------- Sales --------------
Date Loc1 Loc2 Loc3 Loc 4
1/1/06 0 0 100 200
2/1/06 0 0 150 250
3/1/06 0 0 100 100
........

25/1/06 0 100 200 300

At the beginning some of the locations have no sales. but at a later
stage they get sales figures, since these are new locations.

I making chart on these location based on dates.
How I can determine for a certain date whether there is data available
for a location or not?

Like if I slect 1-3 location 1 and 2 do not have data and location 3
and 4 do have data.

Thanks