Find first data in a row

[nadirshahbaz]

Hi.

I need to find first and last day number of each category.

For Example: in 1st row if I choose Pear, i want to return me last day Day15 and first day in a row Day12 NOT Day3.

in 2nd row if I choose Dog, i want to return me last day Day9 and first day in a row Day6 NOT Day2.

File I have attached.


I highly appreciate your help.

Thanks in advance

[benishiryo]

welcome to the forum. try:
=LOOKUP(2,1/(C3:Q3="Pear"),$C$2:$Q$2)

or if pear is in a cell like A6 for eg:
=LOOKUP(2,1/(C3:Q3=A6),$C$2:$Q$2)

[nadirshahbaz]

Thanks.

But formula shows only latest date. But I need first date of row.

[Tsjallie]

See attached workbook.
Type a categorie in column R.

[kvsrinivasamurthy]

Try this simple formulas
For First day

Please Login or Register  to view this content.

For Last Day

Please Login or Register  to view this content.

[nadirshahbaz]

Thank you so much.

Formula is super.

[nadirshahbaz]

Thank you. Awesome