The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.
One of a set of tools we're offering as a way of saying thank you for being a part of the community.
add a column for the max and enter this formula
=MAX(IF($A$2:$A$4=A2;$B$2:
(you might need to replace ; with , depending on your regional settings)
hit CTRL+Shift+enter to turn it into a formula array, then copy down
{=MAX(IF($A$2:$A$4=A2;$B$2