Range function
 

Dear All

I have a sheet where in 1st row i have dates, eg 10 days to 10 different
clumns

In the rows below i have some values, eg sales. But not in all columns.
Eg in the third column there is a possibility to have sales in only two days
(columns)
in the next column to have sales for 9 days ( columns).

There is any possibilty in one cell to bring the date that i do not have
sales?
EG to make a formula that calculate from the range of the 10 days (Columns)
to check which date i do not have a value and then to bring me the date that
exist in first row.?
For example row 3 i do not have a value in D3. Column D means 10/12/2004
So in Column K, which is the check column for me, to bring me the date
10/12/2004, because D$ do not have a value.

Thanks in advance
Manos

One way, provided there's only 1 empty cell (no sales figure) per row, in
the sales data in row2 down

Put in K2 and array-enter (press CTRL+SHIFT+ENTER):
=INDEX($A$1:$J$1,MATCH(TRUE,(A2:J2=""),0))

Format K2 as date and copy down
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Manos" wrote in message
...
Dear All

I have a sheet where in 1st row i have dates, eg 10 days to 10 different
clumns

In the rows below i have some values, eg sales. But not in all columns.
Eg in the third column there is a possibility to have sales in only two
days
(columns)
in the next column to have sales for 9 days ( columns).

There is any possibilty in one cell to bring the date that i do not have
sales?
EG to make a formula that calculate from the range of the 10 days
(Columns)
to check which date i do not have a value and then to bring me the date
that
exist in first row.?
For example row 3 i do not have a value in D3. Column D means 10/12/2004
So in Column K, which is the check column for me, to bring me the date
10/12/2004, because D$ do not have a value.

Thanks in advance
Manos