If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Consolidating last item
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 |
#3
|
|||
|
|||
Consolidating last item
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 . |
#4
|
|||
|
|||
Consolidating last item
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 . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
This item contains active content that cannot be displayed in the preview pane. Open the item to read its contents. | Shadow | General Discussion | 14 | June 16th, 2004 11:22 PM |
Adding "News" item to MS Outlook tool bar | Richard L | Installation & Setup | 3 | May 27th, 2004 03:40 AM |
Matching Item numbers and moving rows | Daniel | Worksheet Functions | 3 | October 13th, 2003 08:32 AM |