Forum Discussion
Solved
Excel
I need a formula that enters a value in one cell based on another. The entered value can be any one of five numbers i.e. If I enter 3 in cell A1, the adjacent cell A2 should display 3 or if I enter 4...
=IF(A1=3,3,IF(A1=4,2,IF(A1=5,1,IF(A1=1,5,IF(A1=2,4,"")))))=CHOOSE(A1,5,4,3,2,1)In cell A2 you can try any of these formulas.
Hi, I have another!! In this, I have a list of names in one column and associated number in the next column. I've filtered the the numbers and associated names in order of highest number to the lowest but I want this order to change automatically if one or more of the numbers changes!
Can anyone add some light..... Please?
I'm happy to see so much activity. I believe the original question was answered, so won't you please consider making another thread for your new question? That helps keep things simple and organized and is good stewardship of the community platform.