Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculate Total Sales from a Database | Excel Worksheet Functions | |||
Database Query | Excel Discussion (Misc queries) | |||
Database functions should use criteria in formula, as 1-2-3 does | Excel Worksheet Functions | |||
Links to External Database | Excel Discussion (Misc queries) | |||
Pulling data out of a large database | Excel Discussion (Misc queries) |