Mar 07 2019 06:24 AM
this is probably a stupid question & is something i should know how to do.
i have a grid that looke something like this
24 25 26 27
1 2 3 4
4 4 4 4
5 6 7 8
8 8 8 8
9 10 11 12
13 14 15 16
how do i get it to find a certain number in the grid & return the number at the top?
i can set the row number from a formula in a different cell but the numbers in the grid are "fluid" & wont always be in the same place
Mar 07 2019 07:35 AM
Mar 07 2019 07:38 AM
the extra 4s can easily be removed or set to different numbers if needs be
Mar 07 2019 07:40 AM
Mar 07 2019 09:10 AM
yeah thats easy enough i know which i need, its just a case of me deleting the 1s i dont need
Mar 07 2019 09:17 AM