Thanks for help in advance, this forum is the best
I will add an attachment of what I would like to achieve.
Im lost with what to do with this formula.
I have learned a little about Index Function, but not sure which functions to use with my numbers
Can someone help with this?
I have a column of random 3 digit numbers from 000 to 999. Examples: 326, 459, 846, 342, 267, etc.
I want to return Yes or No in 3 different columns beside the column with the 3 digit numbers.
the complicated part is:
The first column I want the formula to look at the last number in column of 3 digit numbers and see if one of its 3 digit matches the cell right above it.
Example would be the Last 3 digit number is 580, the number right before it is 256, so the formula would return a "Yes" because one of the 3 digit numbers (580) match the other 3 digits in cell right above it (256) the matching digit is 5. It doesn't matter if two or all three numbers match, it would still return "Yes"
Also this would continue for future numbers, always looking at number right above the last 3 digit number for a matching digit and return "Yes" or "No"
The second column formula would be same as first except it would look at the 4th cell above it for a matching number.
Example would be last number in column of 3 digit numbers is 580, the 4th number above it is 432, so the formula would return "No" in the 2nd column
The same for the last column which is looking at the 7th number above the last 3 digit numbers column.
See attachment for examples
Bookmarks