If you have to import CSV or RPT(SQL Server) files into Excel and then manipulate it to generate a report, you can have these formulae (R1C1 Style) in your scratch pad, and cut and paste them into appropriate cells without even thinking about editing them.
You may have to turn on support for R1C1 addressing in MS-Excel by checking off
Tools -> Options -> General (tab) -> R1C1 Reference style.
Here is the formula that I used to sum up all the values in a given column from the
top to the cell just above the total.
"=SUM(R1C:R[-1]C)" - note that no numeric value follows C to address current column.
No comments:
Post a Comment