Formel zu WorksheetFunction
20.02.2013 16:21:43
Maximilian
{=MAX(($A$1:$D$20="test")*ZEILE(1:20))}
{=MAX(($A$1:$D$20="test")*MTRANS(ZEILE(1:4)))}
Application.WorksheetFunction.Max(Application.WorksheetFunction.Match(Range("A1:D20"), "test") * _
Rows("1:20"))
Application.WorksheetFunction.Max(Application.WorksheetFunction.Match(Range("A1:D20"), "test") * _
_
Application.WorksheetFunction.Transpose(Rows("1:20")))