Jun 02 2022 09:16 AM
Hello Contributors!
I am having a hard time dealing with my file I hope someone can lend me a hand. I need to do cell referencing but the column should remain the same while there should be a +1 change to the row being referenced. The thing is, they are columns apart even though they lie on the same row. I cannot provide a screencap as of the moment but it's something like I will reference A1 in K12, then A2 in R12. I still tried using =$A1+1 knowing that it will not work since Column A contains characters.
Jun 02 2022 09:36 AM
Jun 02 2022 09:40 PM