I have column (A) that contains data which are numbers and a cell (H2) which has a formula to get the maximum number in column (A), i want to divide that number in (H2) by all cells in column (A) and put the result in column (B), knowing that no. of cells in column (A) is variable each time.
Copyright © 2024 Q2A.ES - All rights reserved.
Answers & Comments
Verified answer
In B1 enter
=IFERROR($H$2/A1,"")
and copy it down as many rows as you need.
In B1 enter
=IF(ISNUMBER(A1),$H$2/A1,"")
copy down as many rows as you might ever need.