Excel 2007 : Rank using multiple columns

Hi,

is it possible to rank using multiple columns? Here's my problem:

Column A
1997.0002
2027.0000
2028.0000
1999.0002

Column C
1934.0002
1936.0002
1959.0002

Column E
2006.0000
2008.0000
2013.0000

Column G
1836.0000
1889.0000
1892.0000

In column B, D, F, and H I would the rank for each number. My rank reference should Column A, C, E, and G... I tried =rank(A2,and(Column A, Column C, Column E, Column G),1), but it didn't work...

Any ideas??

Thank you! Much appreciated!