I use this formula to find highest value in column A of other sheet, and then add 1 to it to get new unique number for a record ID, and I use...
with this formula in cell underneath to get a sequential record number for the rest of the cells.
It's used on a sheet where the amount of values in column B shouldn't reach more than 80-100 values, so I have 100 IF statements in column A.
How do I turn these two formula's into an array? Or is what I am trying to achieve possible?