Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi.
Without VBA code, I need to fill in B10 the last cell present in the range A1:A10 (but not always the cell on the left in range A are fill, so I cannot use index based on "full cells" minus "empty cells"). I mean that in B10 must be the first fill cell startng from right of the range A1:A10 ex. a) If I put in A3 = 445, in A5 = 99 the B10 must have 99 b) If I put in A6 = 45, in A9 = 9 the B10 must have 9 c) If I put in A2 = 45, in A4 = 444, in A9 = 9 the B10 must have d) If I put in A2 = 45, in A4 = 444, in A9 = 333 the B10 must have 333 Thanks in advance M. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
If cell not empty, then display from range | Excel Discussion (Misc queries) | |||
find last cell in range with data, display cell address | Excel Worksheet Functions | |||
Want to add value from a range and display result in a cell. | Excel Worksheet Functions | |||
Display cell value in a range | Excel Discussion (Misc queries) | |||
Comparing a cell value to a range value and display a matched value | Excel Programming |