I assume that you have headings in Row 1 so I'll assume the data starts at Row 2.
In E2 enter the formula
and press Enter.
Hover the cursor over the bottom right of cell E2 until the cursor turns into a +
Press and hold the left mouse button and drag down to copy the formula down the page as far as you wish.
In B3 enter the formula
then copy down the page as before.