Forum Discussion
Change the absolute reference into new one whenever copy to new location
Hello, Is there any way to change the absolute reference value into a new one automatically whenever copy into a new location. e.g. There is a series of number from A1:A5 and I want to find out hig...
Use mixed reference like this in B1, copied down to B5:
=(MAX(A$1:A$5)=A1)*A1
=(MAX(A$1:A$5)=A1)*A1
- Ya that one i got but if i copy that formula then the row is going to be fixed and it won't change the to other cell like A$10:A$15 automatically.
I hope I get help with that if possible- That’s just a sample structure of the formula I suggest you to use. For specifics, you need to attach your sample file. Remember, no one could possibly imagine the structure of your actual data, without a sample file. You need not think twice to believe me!
Twifoo Sorry this is the first time in community so I didn't had an idea about the procedure to solve the method. I have explained my problem in excel file itself. Please do check and help to solve the problem.
Thank you
