One way.
=LOOKUP(2,1/(1:1<""),1:1)

Jaydubs wrote:

Dear Excel(lent) users,

I have a query concering the following.

In an excel sheet I have a number of columns, which contains teamnames (team
1...Team N)

I am using Columns A through J to indicate which team is working on an
issue. Now I want to know which is the actual current team working on the
issue.

For instance:
Issue 1 has been worked on by three teams (1,2 and 3) in the following order:
A1 = Team 1
B1 = Team 3
C1 = Team 2
In this instance Team 2 is the current team working on the issue

Another example:
A1 = Team 1
B1 = Team 5
C1 = Team 7
D1 = Team 2
E1 = Team 1
F1 = Team 3
In this instance Team 3 is the current team working on the issue

So what I am looking for is the last entry in the (horizontal) sequence.

Hope this makes sense.

--
** Fool on the hill **

--

Dave Peterson