Last Updates

[atuljadhav]

i have table

<table border="0" cellpadding="0" cellspacing="0" width="607"><col style="width: 92pt;" width="123"> <col style="width: 71pt;" width="94"> <col style="width: 49pt;" width="65" span="6"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl65" id="_x0000_s2049" style="height: 15pt; width: 92pt;" align="center" width="123" height="20">Customer Name</td> <td class="xl65" id="_x0000_s2050" style="border-left: medium none; width: 71pt;" align="center" width="94">Last Update</td> <td class="xl66" id="_x0000_s2051" style="border-left: medium none; width: 49pt;" align="center" width="65">08-Jan-11</td> <td class="xl66" id="_x0000_s2052" style="border-left: medium none; width: 49pt;" align="center" width="65">09-Jan-11</td> <td class="xl66" id="_x0000_s2053" style="border-left: medium none; width: 49pt;" align="center" width="65">10-Jan-11</td> <td class="xl66" id="_x0000_s2054" style="border-left: medium none; width: 49pt;" align="center" width="65">11-Jan-11</td> <td class="xl66" id="_x0000_s2055" style="border-left: medium none; width: 49pt;" align="center" width="65">12-Jan-11</td> <td class="xl66" id="_x0000_s2056" style="border-left: medium none; width: 49pt;" align="center" width="65">13-Jan-11</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; border-top: medium none;" align="center" height="20">Atul</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="center">
</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="center">ABC</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="center">DEF</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="center">
</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="center">GKL</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="center">
</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="center">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; border-top: medium none;" align="center" height="20">Jadhav</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="center">
</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="center">
</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="center">BAC</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="center">KAC</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="center">
</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="center">LKK</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="center">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; border-top: medium none;" align="center" height="20">Bakul</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="center">
</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="center">DCK</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="center">
</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="center">
</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="center">
</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="center">KNKO</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="center">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; border-top: medium none;" align="center" height="20">Nakul</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="center">
</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="center">DNLG</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="center">
</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="center">KNO</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="center">
</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="center">NL</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="center">LM</td> </tr> </tbody></table>
<table border="0" cellpadding="0" cellspacing="0" width="607"><tbody><tr style="height: 15pt;" height="20"><td class="xl65" id="_x0000_s2049" style="height: 15pt; width: 92pt;" width="123" height="20">
</td><td class="xl65" id="_x0000_s2050" style="border-left: medium none; width: 71pt;" width="94">
</td><td class="m" none;="">
</td><td class="xl65" style="border-top: medium none; border-left: medium none;">
</td><td class="xl65" style="border-top: medium none; border-left: medium none;">
</td><td class="xl65" style="border-top: medium none; border-left: medium none;">
</td><td class="xl65" style="border-top: medium none; border-left: medium none;">
</td></tr><tr style="height: 15pt;" height="20"><td class="xl65" style="height: 15pt; border-top: medium none;" height="20">
</td><td class="xl65" style="border-top: medium none; border-left: medium none;">
</td><td class="xl65" style="border-top: medium none; border-left: medium none;">
</td><td class="xl65" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; border-top: medium none;" height="20">
</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">
</td> </tr> </tbody></table>

here A column having customer name and C and onward column having monthly dates 1 to 30, i want last update in this column text in B column

e.g
for first cm the result in B is "GKL"
for second cm the result is "LKK"
for third cm the resul is "KNKO"

i want last cell value in ROW and when i type next cell it automatically change., my row is fixed with date i.e. 1st to 30th.

 

[Aladin Akyurek]

Dear expert
i have table
A B C D E F G
Customer Name Last Update 1/8/11 2/8/11 3/8/11 4/8/11 5/8/11
Atul abc def klm nop
Batul kdjdk iebk kdnnk kd ppp
Natul bbb ccc ddd eee

here A column having customer name and C and onward column having monthly dates 1 to 30, i want last update in this column text in B column

e.g
for first cm the result in B is "nop"
for second cm the result is "ppp"
for third cm the resul is "eee"

i want last cell value in ROW and when i type next cell it automatically change., my row is fixed with date i.e. 1st to 30th.

If there are no formula blanks in a customer record...

B2, copy down:

=LOOKUP(REPT("z",255),C2:Z2,$C$1:$Z$1)

Otherwise:

=LOOKUP(9.99999999999999E+307,SEARCH("?",C2:Z2),$C$1:$Z$1)