Priority in excel formula

cloud2828

New Member
Joined
Jul 16, 2019
Messages
43
I have a table on "Sheet2" where you input a letter and state where it goes in "Sheet1"; A1, A2, A3 etc. in the first column and the letter goes in the second column. This table accepts duplicates and would look like this:

A1Z
A2Z
A3X
A1X
A2X

<tbody>
</tbody>

I would like this to display:
X
X
X

In column A. What I initially did was make a macro to sort the data where the highest priority is at the top and would replace it once it's sorted but this is inefficient since macros take a bit of time to run. The problem is that the formula to display the letter in A1, A2 and A3 is in those same cells, therefore trying to create a condition results in a circular reference. I hope I'm clear on what I'm asking for.
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Watch MrExcel Video

Forum statistics

Threads
1,102,449
Messages
5,486,966
Members
407,575
Latest member
calc

This Week's Hot Topics

Top