Duplicates in Excel

[CD1981]

Hello,

I have a file that has rows of data that are only defined by H or V in each cell, I need to see if there are any duplicates within a selected number of cells to another selected number of cells throughout the spreadsheet. So I need to see if cells B2:B14 if the data is H, H, V, V, V, H, H, V, H, V, V, H, H; if that same data is in that identical same order anywhere else on the sheet. What is the quickest way to go about this or is it even possible?
Thanks,

Cathy

 

[Fluff]

You could try adding a 1 as the 1st argument in the Sequence function.

 

[CD1981]

You could try adding a 1 as the 1st argument in the Sequence function.

Ok, where in the formula would I place that? Maybe I should just switch to Excel.

 

[Fluff]

Just before the 1st comma inside Sequence