Consolidating last item

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

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

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


On Sat, 3 Jul 2004 00:55:15 -0700, "Sheldon" wrote:

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

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 compa
=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


On Sat, 3 Jul 2004 00:55:15 -0700, "Sheldon"
wrote:

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

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

On Tue, 6 Jul 2004 04:39:02 -0700, "Sheldon" wrote:

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 compa
=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


On Sat, 3 Jul 2004 00:55:15 -0700, "Sheldon"
wrote:

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

.