If you can get ADDRESS to work please let me know how.
The Japanese characters have been mutilated, and it's SLOWWW. Still on my first day with Numbers and regretting it already! It (absolute cell ref.) seems to work for cells in a spreadsheet that I imported from AW6 which simply use =$A$1, but not for those which use the $A$1 in a formula such as =COUNTIF(H26:T26,'=$A$1')
Similar function (in Numbers '08) called 'ADDRESS' but.
