Return Unique Sequence of Data

Hi
I have a sequence of data in Range A2:A25 and its Sales in B2:B25
I want to write a formula that return unique sequences like example and then return related average
using temp cells is forbidden but using name manager is allowed.
Thanks

This is clearly a much simplified example and probably doesn't represent the size of your actual data. We often find that when we give an answer to what is a trivial non representative example when the solution is used with the real world data it doesn't work because of factors like string length and other stuff which is important but hasn't been mentioned.

Therefore upload your real workbook (or at least a cut down copy), and manually add the results you expect to see.

That said the sequential values you show in column A are NOT unique. By disallowing helper cells I can't see any simple way in which Excel can identify the different sequences containing the same value. Your brain knows, but your brain is a mass of helper cells :-)

I find it hard to believe that this is NOT coursework, given the similarity of this post:

https://www.excelforum.com/excel-for...nce-value.html

In I2, copied down:
=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW($A$2:$A$25)/(T(IF($A$2:$A$25<>$A$1:$A$25,$A$2:$A$25))<>""),ROWS(I$2:I2))),"")

in J2,copied down:
=IFERROR(AVERAGE(INDEX($B:$B,AGGREGATE(15,6,ROW($A$2:$A$25)/(T(IF($A$2:$A$25<>$A$1:$A$25,$A$2:$A$25))<>""),ROWS(J$2:J2))):INDEX($B:$B,AGGREGATE(15,6,ROW($A$2:$A$25)/(T(IF($A$2:$A$25<>$A$3:$A$26,$A$2:$A$25))<>""),ROWS(J$2:J2)))),"")