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]

Do you usually use commas between the different arguments(parts) of a function, or do you use semi-colons?

 

[CD1981]

Am I able to send you the file so you can see exactly what we're dealing with?

 

[Fluff]

You can upload it to a share site such as OneDrive, mark for sharing & post the link here.

 

[CD1981]

Do you usually use commas between the different arguments(parts) of a function, or do you use semi-colons?

I don't know! I don't usually use Excel in such a complicated fashion.

 

[CD1981]

TEST

TEST 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19 1,V,H,V,V,V,H,V,V,V,V,H,H,V,H,V,V,V,V,V 2,H,H,H,H,H,V,H,H,H,H,H,V,V,H,V,V,V,V,V 3,H,H,H,H,H,H,H,H,H,H,H,H,H,H,H,H,H,H,H 4,H,V,H,V,V,H,H,V,H,H,V,H,V,H,V,V,H,V,V 5,V,H,H,V,V,H,V,H,V,V,V,H,V,H,H,H,H,V,V 6,V,H,V,H,H,H,H,H,H,H,H,H,V,H,H,V,H,V,H 7,V...

docs.google.com

 

[CD1981]

You can upload it to a share site such as OneDrive, mark for sharing & post the link here.

TEST

TEST 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19 1,V,H,V,V,V,H,V,V,V,V,H,H,V,H,V,V,V,V,V 2,H,H,H,H,H,V,H,H,H,H,H,V,V,H,V,V,V,V,V 3,H,H,H,H,H,H,H,H,H,H,H,H,H,H,H,H,H,H,H 4,H,V,H,V,V,H,H,V,H,H,V,H,V,H,V,V,H,V,V 5,V,H,H,V,V,H,V,H,V,V,V,H,V,H,H,H,H,V,V 6,V,H,V,H,H,H,H,H,H,H,H,H,V,H,H,V,H,V,H 7,V...

docs.google.com

 

[Fluff]

Are you actually doing this in Excel or Sheets?

 

[CD1981]

Are you actually doing this in Excel or Sheets?

Oh both, I switch between the two. If it's easier I will just stick with one. Is the formula not working because it's Sheets? I thought they were the same.

 

[Fluff]

Is the formula not working because it's Sheets?

Probably, because the error you report is not an Excel error.

I thought they were the same.

Nowhere near the same, there are some similarities but a lot more differences.

 

[CD1981]

Oh ok sorry, are you able to help with Sheets or should I be making sure I'm in Excel when I do this?