I have a similar question but I really need a precise answer cause I'm not really introduced to Excel yet. I have joined the document I am working on, so please look at it while I explain my problem.
Currently I have written down in col B and col D some numbers which are added together for each row and that gives out the total on col E. I have also sorted col E from the smallest number to the biggest, along with the rest of the row. (except for the first row which is the menu/title of the columns)
What I mean by that is that say row #2 will always stick with the informations on that row, even if it moves down; not only E2 will move down if the number is bigger, but the whole row too.
What I want now is to have the col E sorted everytime I change/add a value in a cell in the col B or col D, and for every row to follow like I explained earlier.
Also, note that in the document I have prepared a longer table than needed right now. If possible, if I chose to add some informations on the next rows later, I would like that it would apply to those rows too. (up to row 26) Otherwise, if it can't work with blank cells, I would like if you could tell me how to change the values whenever I need to expand my table.
I need to know how my entries would look like, cause if I have a number in a cell and you're telling me to write a formula in that same cell, I wouldn't know how to write both together.
I hope I've been clear ._.
I would like to learn how to do it so please don't just edit my file and attach it in your post.
Thank you in advance for your help ^^
Bookmarks