Hi everyone,
I have limited working knowledge of excel and I hope someone will be able to help me with my problem.
What I need if to compare the digit number, if both numbers match the unique digit with containing ‘9’, ‘9’ it will return from the top 1st left number.
This formula based plus (+) and equal (=) and any random calculation number from 1 to 9 only.
For example, if we type any top ‘4’ digit number suddenly it appears matching number ‘9’ & ‘9’ like this:
.
2 – 7 – 1 - 8
‘9’ ‘9’
9
9 9
9
What I want the results become like this:
.
2 – 7 – 1 - 8
‘2‘ 9
2
2 4
6
How do I swap (change) ‘9’ to digit ‘2’ (only left digit)? Also what type of formula should I manipulate and which column should I put in the formula?
Before this, I have tried to use vlookup, match, index, and lookup at random formula but still didn’t work.
Please see my attachment.
Thank you for showing interest.
Any help is still appreciated.
Bookmarks