Merging data from 7 worksheets

[axerri]

Good afternoon all,

I have a bit of an excel issue that I hope that someone can help me with.

I have data which I need to merge within one worksheet from 7 worksheets located within the same workbook.

The way that the data will be merged will be through obtaining the least common value across the 7 equal cells across the other 7 worksheets (e.g. cell A1 from sheet1, cell A1 from sheet2, cell A1 from sheet3 etc.) Whichever value is least re-occurring will be the new value in the new sheet.

I know that if the data is all in a row, I can use {=INDEX(A1:G1,MATCH(MIN(COUNTIF<wbr style="color: rgb(33, 33, 33); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; line-height: 19.7999992370605px;">(A1:G1,A1:G1)),COUNTIF(A1:G1,<wbr style="color: rgb(33, 33, 33); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; line-height: 19.7999992370605px;">A1:G1),0))}, however as the data is not in a row, I'm struggling to get around it.

Putting the data all in one sheet is difficult as there are over 600 columns and over 1500 rows.

Thank you in advance for all your help, and if there is some additional information that I can provide, please let me know.

Aidan

 

[onlyadrafter]

Hello,

are you saying that you want to look at every cell (with data) in the seven worksheets, and if cell A1 in the seven sheets contains, 1, 1, 1, 2, 3, 3, 3 you want the new sheet to have 2.

What happens if there isn't a least recurring value, i.e. if A1 contains 1, 2, 3, 4, 5, 6, 7. What result would you expect?

Also what if one of the sheets has no date i.e. empty?