| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Picking up the latest text value in a column
I'm currently working on a Ship Ticket template that should populate in
certain fields of the form the latest text information found in a worksheet. This would allow me print a Ship Ticket for my latest entry in that column. I was able to use the following formula from previous posts, which helped me grab the latest number value in that column: =INDEX(A:A,MATCH(9.99999999999999E+307,A:A,A2)) However, for fields containing names and dates, I would like to find a formula that would pull those into the specific fields in my template. In advance, many thanks for your help!!! Mag |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Picking up the latest text value in a column
Hi there,
For the last textual value in a column you could use ... =INDEX(A:A,MATCH(REPT("z",255),A:A,A2)) For getting the last value in a column regardless of textual or numeric (which includes dates as well) you could use ... =INDEX(A:A,MAX(MATCH({"ZZZZZZZZZZZZZZZZZZZZ",9.999 99999999999E+307},A:A)),A2) For more information take a look at Bob Phillips website... http://xldynamic.com/source/xld.LastValue.html HTH -- Zack Barresse "djmagcruznyc" wrote in message ... I'm currently working on a Ship Ticket template that should populate in certain fields of the form the latest text information found in a worksheet. This would allow me print a Ship Ticket for my latest entry in that column. I was able to use the following formula from previous posts, which helped me grab the latest number value in that column: =INDEX(A:A,MATCH(9.99999999999999E+307,A:A,A2)) However, for fields containing names and dates, I would like to find a formula that would pull those into the specific fields in my template. In advance, many thanks for your help!!! Mag |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Picking up the latest text value in a column
You can also use this shorter formula to get the last value in a column
regardless if it is text or numeric... =LOOKUP(2,1/(A1:A65535<""),A:A) Rick "Zack Barresse" wrote in message ... Hi there, For the last textual value in a column you could use ... =INDEX(A:A,MATCH(REPT("z",255),A:A,A2)) For getting the last value in a column regardless of textual or numeric (which includes dates as well) you could use ... =INDEX(A:A,MAX(MATCH({"ZZZZZZZZZZZZZZZZZZZZ",9.999 99999999999E+307},A:A)),A2) For more information take a look at Bob Phillips website... http://xldynamic.com/source/xld.LastValue.html HTH -- Zack Barresse "djmagcruznyc" wrote in message ... I'm currently working on a Ship Ticket template that should populate in certain fields of the form the latest text information found in a worksheet. This would allow me print a Ship Ticket for my latest entry in that column. I was able to use the following formula from previous posts, which helped me grab the latest number value in that column: =INDEX(A:A,MATCH(9.99999999999999E+307,A:A,A2)) However, for fields containing names and dates, I would like to find a formula that would pull those into the specific fields in my template. In advance, many thanks for your help!!! Mag |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Picking up the latest text value in a column
That and other solutions are found in the link I posted. Many options Bob
has compiled. The best (IMHO) out there. -- Zack Barresse "Rick Rothstein (MVP - VB)" wrote in message ... You can also use this shorter formula to get the last value in a column regardless if it is text or numeric... =LOOKUP(2,1/(A1:A65535<""),A:A) Rick "Zack Barresse" wrote in message ... Hi there, For the last textual value in a column you could use ... =INDEX(A:A,MATCH(REPT("z",255),A:A,A2)) For getting the last value in a column regardless of textual or numeric (which includes dates as well) you could use ... =INDEX(A:A,MAX(MATCH({"ZZZZZZZZZZZZZZZZZZZZ",9.999 99999999999E+307},A:A)),A2) For more information take a look at Bob Phillips website... http://xldynamic.com/source/xld.LastValue.html HTH -- Zack Barresse "djmagcruznyc" wrote in message ... I'm currently working on a Ship Ticket template that should populate in certain fields of the form the latest text information found in a worksheet. This would allow me print a Ship Ticket for my latest entry in that column. I was able to use the following formula from previous posts, which helped me grab the latest number value in that column: =INDEX(A:A,MATCH(9.99999999999999E+307,A:A,A2)) However, for fields containing names and dates, I would like to find a formula that would pull those into the specific fields in my template. In advance, many thanks for your help!!! Mag |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Picking up the latest text value in a column
Can't thank you guys enough for your help on this!!! I finally got my
template to do what it needed to do. Many thanks for also responding so quickly...this will save me lots of time and headaches. Happy trails guys, and best wishes Mag ;) "Zack Barresse" wrote: Hi there, For the last textual value in a column you could use ... =INDEX(A:A,MATCH(REPT("z",255),A:A,A2)) For getting the last value in a column regardless of textual or numeric (which includes dates as well) you could use ... =INDEX(A:A,MAX(MATCH({"ZZZZZZZZZZZZZZZZZZZZ",9.999 99999999999E+307},A:A)),A2) For more information take a look at Bob Phillips website... http://xldynamic.com/source/xld.LastValue.html HTH -- Zack Barresse "djmagcruznyc" wrote in message ... I'm currently working on a Ship Ticket template that should populate in certain fields of the form the latest text information found in a worksheet. This would allow me print a Ship Ticket for my latest entry in that column. I was able to use the following formula from previous posts, which helped me grab the latest number value in that column: =INDEX(A:A,MATCH(9.99999999999999E+307,A:A,A2)) However, for fields containing names and dates, I would like to find a formula that would pull those into the specific fields in my template. In advance, many thanks for your help!!! Mag |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Picking up the latest text value in a column
Can't thank you guys enough for your help on this!!! I finally got my
template to do what it needed to do. Many thanks for also responding so quickly...this will save me lots of time and headaches. Happy trails guys, and best wishes Mag ;) "Rick Rothstein (MVP - VB)" wrote: You can also use this shorter formula to get the last value in a column regardless if it is text or numeric... =LOOKUP(2,1/(A1:A65535<""),A:A) Rick "Zack Barresse" wrote in message ... Hi there, For the last textual value in a column you could use ... =INDEX(A:A,MATCH(REPT("z",255),A:A,A2)) For getting the last value in a column regardless of textual or numeric (which includes dates as well) you could use ... =INDEX(A:A,MAX(MATCH({"ZZZZZZZZZZZZZZZZZZZZ",9.999 99999999999E+307},A:A)),A2) For more information take a look at Bob Phillips website... http://xldynamic.com/source/xld.LastValue.html HTH -- Zack Barresse "djmagcruznyc" wrote in message ... I'm currently working on a Ship Ticket template that should populate in certain fields of the form the latest text information found in a worksheet. This would allow me print a Ship Ticket for my latest entry in that column. I was able to use the following formula from previous posts, which helped me grab the latest number value in that column: =INDEX(A:A,MATCH(9.99999999999999E+307,A:A,A2)) However, for fields containing names and dates, I would like to find a formula that would pull those into the specific fields in my template. In advance, many thanks for your help!!! Mag |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Picking up last value in column in Excel | Excel Worksheet Functions | |||
| Looking for the earliest/latest date in a column | Excel Worksheet Functions | |||
| Picking out column in named range | Excel Worksheet Functions | |||
| Picking one column of info | Excel Worksheet Functions | |||
| Display latest date in a column | Excel Worksheet Functions | |||
Linear Mode
