Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill a cell based on last entry
I have a worksheet that I need to pull a number from Column b, but the row
number is based on the last entry of a cell, is this possible? For example: A B C 1 25% 12500 2 40% 1500 3 75% 1400 4 100% 5 In A5, I'd like the number from B3 to go, since the last entry inc olumn C is in C3. Does this make sense? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill a cell based on last entry
In A5:
=OFFSET($B$1,MATCH(9.99999999999999E+307,C:C)-1,0) basically, go down from B1 as far as there is data in column C -- Gary''s Student - gsnu200790 "Amanda" wrote: I have a worksheet that I need to pull a number from Column b, but the row number is based on the last entry of a cell, is this possible? For example: A B C 1 25% 12500 2 40% 1500 3 75% 1400 4 100% 5 In A5, I'd like the number from B3 to go, since the last entry inc olumn C is in C3. Does this make sense? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill a cell based on last entry
Wonderful....it worked! Thanks
"Gary''s Student" wrote: In A5: =OFFSET($B$1,MATCH(9.99999999999999E+307,C:C)-1,0) basically, go down from B1 as far as there is data in column C -- Gary''s Student - gsnu200790 "Amanda" wrote: I have a worksheet that I need to pull a number from Column b, but the row number is based on the last entry of a cell, is this possible? For example: A B C 1 25% 12500 2 40% 1500 3 75% 1400 4 100% 5 In A5, I'd like the number from B3 to go, since the last entry inc olumn C is in C3. Does this make sense? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill a cell based on last entry
Another one:
=LOOKUP(1E100,C:C,B:B) -- Biff Microsoft Excel MVP "Amanda" wrote in message ... I have a worksheet that I need to pull a number from Column b, but the row number is based on the last entry of a cell, is this possible? For example: A B C 1 25% 12500 2 40% 1500 3 75% 1400 4 100% 5 In A5, I'd like the number from B3 to go, since the last entry inc olumn C is in C3. Does this make sense? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell value based on combo box entry | Excel Worksheet Functions | |||
fill all cells in row with one cell entry | New Users to Excel | |||
Formula to fill a cell based on an entry in one of two worksheets | Excel Worksheet Functions | |||
Auto fill cell entry | Excel Discussion (Misc queries) | |||
Formula based on a cell entry | Excel Discussion (Misc queries) |