Hello,
Thank You for your time.
I have a sheet with two columns with number values in each. On a separate sheet I have two more columns on it. One column has concatenated values of the rows from the first sheet. Example of format(no parenthesis): (36 & 6) . The second, I would like to count how many times the concatenated value (36 & 6) appears in the range.
Example:
___ A___B_______________Sheet two___A_________B
1__36__6_______________ 1___36 & 6_____ 812 (would like count)
2__18__22_______________2___18 & 22
3__15__32_______________3___15 & 32
4__12__ 2_______________ 4___12 & 2
Sorry about the underscores, system wouldn't let me use spaces.
How could I do this?
Thank You
Thank You for your time.
I have a sheet with two columns with number values in each. On a separate sheet I have two more columns on it. One column has concatenated values of the rows from the first sheet. Example of format(no parenthesis): (36 & 6) . The second, I would like to count how many times the concatenated value (36 & 6) appears in the range.
Example:
___ A___B_______________Sheet two___A_________B
1__36__6_______________ 1___36 & 6_____ 812 (would like count)
2__18__22_______________2___18 & 22
3__15__32_______________3___15 & 32
4__12__ 2_______________ 4___12 & 2
Sorry about the underscores, system wouldn't let me use spaces.
How could I do this?
Thank You
Last edited: