Patrickboy
New Member
- Joined
- Aug 4, 2021
- Messages
- 8
- Office Version
- 365
- Platform
- Windows
Hello,
I have a list of two column A-B I need to check names on column B and if two or more names are same, I need to copy the value of A cell if is "not found".
In this example cell A1 and cell A11 should takes the value of cell A10 because B10 and B1 and B11 are same name. If it's not found, should not take anything.
How to do?
thanks a lot
I have a list of two column A-B I need to check names on column B and if two or more names are same, I need to copy the value of A cell if is "not found".
In this example cell A1 and cell A11 should takes the value of cell A10 because B10 and B1 and B11 are same name. If it's not found, should not take anything.
How to do?
thanks a lot
aum.xlsx | ||||
---|---|---|---|---|
A | B | |||
1 | Not found | NAME1 | ||
2 | Not found | NAME2 | ||
3 | Example1 | NAME3 | ||
4 | Not found | NAME4 | ||
5 | Not found | NAME5 | ||
6 | Not found | NAME6 | ||
7 | Example1 | Name3 | ||
8 | Not found | NAME8 | ||
9 | Not found | NAME9 | ||
10 | Example2 | NAME1 | ||
11 | Not found | NAME1 | ||
Foglio13 |