| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Displaying Last Number that is in a cell
I saw that someone replied but it didn't work.
I have a document that Looks like this: 1 2 3 4 5 a 1/1/07 53 b 1/2/07 64 c 1/3/07 42 d 1/4/07 102 e 1/5/07 f 1/6/07 g (to show D3) I want G3 to show the last number that was inputted (which in this case would be D3). Is there any way of doing this? Thank you again for all your help guys! -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200701/1 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Displaying Last Number that is in a cell
=LOOKUP(100^10,B:B)
Will return the last numeric value entered in column B. Biff "instereo911 via OfficeKB.com" <u27979@uwe wrote in message news:6c8798082a557@uwe... I saw that someone replied but it didn't work. I have a document that Looks like this: 1 2 3 4 5 a 1/1/07 53 b 1/2/07 64 c 1/3/07 42 d 1/4/07 102 e 1/5/07 f 1/6/07 g (to show D3) I want G3 to show the last number that was inputted (which in this case would be D3). Is there any way of doing this? Thank you again for all your help guys! -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200701/1 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Displaying Last Number that is in a cell
Try =LOOKUP(99^99,C:C)
Where C:C is the column you are entering the numbers, 3 in your example. HTH Regards, Howard "instereo911 via OfficeKB.com" <u27979@uwe wrote in message news:6c8798082a557@uwe... I saw that someone replied but it didn't work. I have a document that Looks like this: 1 2 3 4 5 a 1/1/07 53 b 1/2/07 64 c 1/3/07 42 d 1/4/07 102 e 1/5/07 f 1/6/07 g (to show D3) I want G3 to show the last number that was inputted (which in this case would be D3). Is there any way of doing this? Thank you again for all your help guys! -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200701/1 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Displaying Last Number that is in a cell
Worked like a charm. Thank you so much Howard
L. Howard Kittle wrote: Try =LOOKUP(99^99,C:C) Where C:C is the column you are entering the numbers, 3 in your example. HTH Regards, Howard I saw that someone replied but it didn't work. [quoted text clipped - 15 lines] Thank you again for all your help guys! -- Message posted via http://www.officekb.com |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Displaying Last Number that is in a cell
You are welcome, and Bob Phillips offers an interesting solution.
"instereo911 via OfficeKB.com" <u27979@uwe wrote in message news:6c87ceafb3414@uwe... Worked like a charm. Thank you so much Howard L. Howard Kittle wrote: Try =LOOKUP(99^99,C:C) Where C:C is the column you are entering the numbers, 3 in your example. HTH Regards, Howard I saw that someone replied but it didn't work. [quoted text clipped - 15 lines] Thank you again for all your help guys! -- Message posted via http://www.officekb.com |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Displaying Last Number that is in a cell
=LOOKUP(2,1/(D:D<""),D:D)
-- --- HTH Bob (change the xxxx to gmail if mailing direct) "instereo911 via OfficeKB.com" <u27979@uwe wrote in message news:6c8798082a557@uwe... I saw that someone replied but it didn't work. I have a document that Looks like this: 1 2 3 4 5 a 1/1/07 53 b 1/2/07 64 c 1/3/07 42 d 1/4/07 102 e 1/5/07 f 1/6/07 g (to show D3) I want G3 to show the last number that was inputted (which in this case would be D3). Is there any way of doing this? Thank you again for all your help guys! -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200701/1 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Displaying Last Number that is in a cell
Do you mean you want the last number in column D?
If so try =LOOKUP(9.99999999999999E+307,D:D) "instereo911 via OfficeKB.com" wrote: I saw that someone replied but it didn't work. I have a document that Looks like this: 1 2 3 4 5 a 1/1/07 53 b 1/2/07 64 c 1/3/07 42 d 1/4/07 102 e 1/5/07 f 1/6/07 g (to show D3) I want G3 to show the last number that was inputted (which in this case would be D3). Is there any way of doing this? Thank you again for all your help guys! -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200701/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct issues | Excel Worksheet Functions | |||
| Sending a raw number to a cell from a calculated cell | Excel Worksheet Functions | |||
| Significant number rounding based on key cell | Excel Worksheet Functions | |||
| Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
Hybrid Mode
