Forum Discussion
Solved
Lookup function with specific cells
Hello, I want to have the last value entered for each column A B C D but I don't know how to do it. It's not working when I select only the cells I want it to take into account for the formula f...
Thank you it worked !
Would you mind explaining what does the 2, 1/ stand for though ? I think I've understood how the rest of the formula works, but not this part... Thanks !
Would you mind explaining what does the 2, 1/ stand for though ? I think I've understood how the rest of the formula works, but not this part... Thanks !
As a comment to Lorenzo comment, instead of 2 as first parameter you may use any number greater than 1, for example PI().