**Question description:**

*This user has given permission to use the problem statement for this blog.*

I am using if and large function to sequentially arrange the values. If I change the value of one item then the entire sequence is changing. I just want to replace the changed value without changing the sequence.

Solved by D. J. in 20 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
06/08/2018 - 03:08

hello..

Excelchat Expert
06/08/2018 - 03:09

how can i help you today..?

Excelchat Expert
06/08/2018 - 03:14

you are using if & large function to arrange the data

Excelchat Expert
06/08/2018 - 03:16

it arranged by sequence..

Excelchat Expert
06/08/2018 - 03:16

so if you change one of the value..entire sequence will affect..

Excelchat Expert
06/08/2018 - 03:17

if you want to keep the sequence even you changed the value, you have to use other formula to achieve that..

Excelchat Expert
06/08/2018 - 03:19

What I think you have a few options to do that..

Excelchat Expert
06/08/2018 - 03:20

first you need write completely new formula..

Excelchat Expert
06/08/2018 - 03:20

second, use supporting column to fix sequence..

Excelchat Expert
06/08/2018 - 03:22

third, turn formula to value ..

Excelchat Expert
06/08/2018 - 03:22

I think second option will be most promising..

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*