Navigating a large database?
When I'm too lazy to toggle R1C1 reference style, I insert a temporary row and
put this in A1:
=column()
and drag across as far as I need.
Arsenio Oloroso wrote:
I've imported a huge data base into Excel that doesn't have field (column)
headings. The file layout indicates that the info I want is in field 117.
Can anyone suggest a way for me to locate this field quickly. I would
prefer not to have to do it by tapping the right arrow and counting off the
numbers until I get there.
Thanks for any advice.
--
Dave Peterson
|