Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Dave Peterson
 
Posts: n/a
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculate Total Sales from a Database John Excel Worksheet Functions 0 November 3rd 05 12:26 PM
Database Query Neville Excel Discussion (Misc queries) 0 October 21st 05 05:54 AM
Database functions should use criteria in formula, as 1-2-3 does 123user Excel Worksheet Functions 8 September 29th 05 08:57 PM
Links to External Database Rubble Excel Discussion (Misc queries) 0 July 20th 05 10:44 PM
Pulling data out of a large database Dave Excel Discussion (Misc queries) 4 January 20th 05 03:49 AM


All times are GMT +1. The time now is 07:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"