Excel Function Returns Cell Address

  • sqlsmokey

    Old Hand

    Points: 375

    Comments posted to this topic are about the item Excel Function Returns Cell Address

  • jcrawf02

    SSC-Insane

    Points: 24198

    I may just be lazier than you, but I wouldn't do it that way, I'd create a template Excel file with the header rows and formulas in place already. I'd also use some variant of =LOOKUP(2,1/(B:B<>""),B:B) to find the last cell in the range with data, so I didn't have to change my cell references all the time. reference: http://www.excelforum.com/excel-general/562685-need-formula-to-retrieve-last-non-blank-cell-in-range.html

    Then when I wanted to pull in the new perfmon file, just delete your previous data (leaving the headers in place), go to the Data menu, Get External Data --> From Text, find your csv file and drop it onto row 6.

    Voila, problem solved without having to do anything but delete old, import new.

    Laziness is the mother of invention. 😉

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • Robert.Sterbal

    SSCrazy

    Points: 2855

    Every time I have tabular data for excel I'll post it to its own sheet. The cell reference =MAX(A:A) will then work on the column without calculation of the rows

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply