June 3, 2013 at 10:22 pm
Comments posted to this topic are about the item Excel Function Returns Cell Address
June 4, 2013 at 6:49 am
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."
June 4, 2013 at 7:22 am
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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply