I have a data of some binary numbers in few range of cells, from A2 to A8, B2 to B8, and so on, till G column. Now, I want to check the largest binary number from the above Rows and paste it to the cell, two row below the last used range. (i.e., Largest binary number from Row A to be paste in A10, and so on). I am not finding any function which can find the value of binary numbers, and the code which I ran finds out the max number considering those as natural numbers. Your help will be appreciated. Thank You!
What I have tried:
I couldn't find any appropriate code for that.