Excel-lent? I dunno

Having spent much of the last goodness-knows-how-long wrestling with the intricacies of Ruby On Rails On Linux On Oracle (a challenge for a Windows-constrained one such as I) it was a pleasant diversion to be presented by a colleague with an Excel question that I couldn’t immediately answer.

He had some data of this form:

Find the last cell with value C

…and he wanted the value from column B from the row containing the last of a particular value in column A. So for “A”, he wanted 68, “B” would give 95 and “C” 12.

I came up with this (for “C”):


It gets a bit more complicated if the data doesn’t start on row 1, but you should see what’s going on.

I can’t say I like it very much, for all it does what was requested.

One Response to Excel-lent? I dunno

  1. sam says:

    May be you should use a “bug/feature” of the match function

    Match will return the last instance of A

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: