Consolidating last item

  • Thread starter Thread starter Sheldon
  • Start date Start date
S

Sheldon

Hey There,
I have a number of worksheets and I'm trying to consolidated all the
information on one sheet. I'm having no problem with numbers data, but
one of the lists in the work sheet is "last action completed" which has a text
input.

What I want to do is take what ever the last text input is in that column and
display it on the first consolidated sheet. So if the range of my list is G12 to
G25 and I have filled out rows G12 to say G16, on my consolidated sheet it
would show me G16's data.

Any help would be much appreciated.
Sheldon
 
Sheldon

=LOOKUP(REPT("z",255),MySheet!G12:G25)

Will find the last non-numeric data in Column G in that range.

In your case, G16's data.

Why limit yourself to a small range?

You could also write it as G12:G65536

Gord Dibben Excel MVP
 
Hey Gord,

I'm sure I'm doing something wrong so maybe a little
clarification is in order. When I enter the function excel
gives me an error and highlights the ("z",255) section. I
used the function exactly as you have it below only
changing the name of the sheet from "MySheet"
to "Project01", and extending the range a bit. The rest I
left as is. Was there something else I should have
adjusted or am I missing something.

Here they both are to compare:
=LOOKUP(REPT("z",255),MySheet!G12:G25)
=LOOKUP(REPT("z",255),MySheet!G12:G46)
-----Original Message-----
Sheldon

=LOOKUP(REPT("z",255),MySheet!G12:G25)

Will find the last non-numeric data in Column G in that range.

In your case, G16's data.

Why limit yourself to a small range?

You could also write it as G12:G65536

Gord Dibben Excel MVP
Click to expand...
 
Sheldon

I can't see why the formula as written does not work.

I copy both of them to Sheet1 A1 and B1 on a test workbook with data in Column
G of MySheet and get correct results.

What Language setting do you use?

Mayhaps a semi-colon instead of a comma would work if using some kind of
European setting?

Send me your file if not private and I'll have a look.

Change the AT and DOT to get my email address.

Gord

Hey Gord,

I'm sure I'm doing something wrong so maybe a little
clarification is in order. When I enter the function excel
gives me an error and highlights the ("z",255) section. I
used the function exactly as you have it below only
changing the name of the sheet from "MySheet"
to "Project01", and extending the range a bit. The rest I
left as is. Was there something else I should have
adjusted or am I missing something.

Here they both are to compare:
=LOOKUP(REPT("z",255),MySheet!G12:G25)
=LOOKUP(REPT("z",255),MySheet!G12:G46)
Click to expand...
 
Back
Top