| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Showing Last Value in a column
Hi - is there any way that if I have a column with numbers in each cell, to
be able to put in a formula (without using a vlookup) that will give me the last value in that column please? (e.g the column numbers range from 1 to 20 and I want a cell to bring through the value of 20) thanks in advance |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Showing Last Value in a column
Hi,
This does it for column B =INDEX(B:B,MATCH(6.022*10^23,B:B)) Mike "Cadders" wrote: Hi - is there any way that if I have a column with numbers in each cell, to be able to put in a formula (without using a vlookup) that will give me the last value in that column please? (e.g the column numbers range from 1 to 20 and I want a cell to bring through the value of 20) thanks in advance |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Showing Last Value in a column
You are a star Mike - thanks for your help
"Mike H" wrote: Hi, This does it for column B =INDEX(B:B,MATCH(6.022*10^23,B:B)) Mike "Cadders" wrote: Hi - is there any way that if I have a column with numbers in each cell, to be able to put in a formula (without using a vlookup) that will give me the last value in that column please? (e.g the column numbers range from 1 to 20 and I want a cell to bring through the value of 20) thanks in advance |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Showing Last Value in a column
If the numbers are in ascending order then the last value in the range
should be the max value: =MAX(A1:A100) If the numbers are in random order: =LOOKUP(1E100,A1:A100) -- Biff Microsoft Excel MVP "Cadders" wrote in message ... Hi - is there any way that if I have a column with numbers in each cell, to be able to put in a formula (without using a vlookup) that will give me the last value in that column please? (e.g the column numbers range from 1 to 20 and I want a cell to bring through the value of 20) thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Column to repeat not showing on every page | Excel Discussion (Misc queries) | |||
| How do I keep column headings from showing on a list? | Excel Worksheet Functions | |||
| Column Labels (A, B) are showing us as numbers (1,2). Please Help | Excel Worksheet Functions | |||
| Showing the column of current day | Excel Worksheet Functions | |||
| In Excel - how do I keep the column titles showing when I go to t. | Excel Worksheet Functions | |||
Hybrid Mode
