Finutia
  • Home
  • Blogutia
  • About
  • Contact

Getting MAX value from a column in an Excel named range

10/8/2014

0 Comments

 
An application I work on has a reporting engine that uses Excel for report templates. When a report is generated, the code adds a "Data" worksheet to the Excel template, and populates it with named ranges of tabular data. User-defined template worksheets can then use formulas such as VLOOKUP and MATCH to reference and display values from the Data worksheet's named ranges.

For a particular template I needed to get the maximum value of a column of numbers in one of the Data worksheet's named ranges. The problem I ran into was that I didn't know at what row the named range would start, and how many rows it would have, because each time the Data worksheet generates, the various named ranges could have a different number of rows.

Read More
0 Comments

    Blogutia

    [blawgooshuh]
    noun
    A collection of information, experiences, observations and commentary, that pays attention to the fine details that matter.

    Archives

    March 2015
    January 2015
    October 2014
    May 2014
    July 2013

    Categories

    All
    Adobe InDesign
    ASP.NET
    Bugs
    C#
    Microsoft Excel
    Multimedia
    Mvc
    Templates
    Tips & Tricks
    Web Development

    RSS Feed


© Copyright 2013 Fīnutia LLC  — All Rights Reserved