plot the first and last entry values for the given input texts

[Sekars]

Hello Friends

I need to plot the first and last entry values for the given texts.

The values need to be plot in the light yellow cells.

thanks in advance

[Pete_UK]

Put this in E2:

=IFERROR(VLOOKUP(D2,$A$1:$B$63,2,0),"")

and this array* formula in F2:

=INDEX($B$1:$B$63,MAX(IF($A$1:$A$63=D2,ROW($B$1:$B$63))))

*Note that an array formula needs to be committed using the key combination of Ctrl-Shift-Enter (CSE), rather than the usual < Enter >.

Copy the formulae down, as required.

Hope this helps.

Pete

[Czeslaw]

Use the AGGREGATE function.
the first value

Please Login or Register  to view this content.

the last value

Please Login or Register  to view this content.

[Sekars]

Hello Pete and Hello Czeslaw

Thanks to both you for your formulas.

thanks again