latest feedback

[atuljadhav]

Dear sir

i have file for customer feedback with customer details like
customer name
Invoice pending
invoice date
out standing
remarks

my executive feel up feedback in remarks column only and update daily in this column, my customer list is same for entire month, they just enter today's tele calling of field visit report and send me every date

in this report i just want that comment/feedback which is uploaded today by my executive,

how can i find latest feedback or at least that cell no where they modify the feedback

 

[atuljadhav]

please expert revert

 

[markmzz]

Atuljadhav,

You will generally get much more help (and faster) if you can post your small samples (what you have and what you
want) directly in the forum.

Put borders around a small range of the cells.

Then copy the range and paste them here.

Markmzz

 

[atuljadhav]

<table align="center" border="0" cellpadding="0" cellspacing="0" width="782"><col style="width: 11pt;" width="14"> <col style="width: 152pt;" width="202"> <col style="width: 73pt;" width="97"> <col style="width: 51pt;" width="68"> <col style="width: 62pt;" width="82"> <col style="width: 55pt;" width="73"> <col style="width: 185pt;" width="246"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt; width: 11pt;" width="14" height="17"> </td> <td class="xl29" style="border-left: medium none; width: 152pt;" width="202">A</td> <td class="xl29" style="border-left: medium none; width: 73pt;" width="97">B</td> <td class="xl29" style="border-left: medium none; width: 51pt;" width="68">C</td> <td class="xl29" style="border-left: medium none; width: 62pt;" width="82">D</td> <td class="xl29" style="border-left: medium none; width: 55pt;" width="73">E</td> <td class="xl29" style="border-left: medium none; width: 185pt;" width="246">F</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt; border-top: medium none;" align="right" height="17">1</td> <td class="xl23" style="border-top: medium none; border-left: medium none;">Party's Name</td> <td class="xl23" style="border-top: medium none; border-left: medium none;">Ref. No.</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">Date</td> <td class="xl23" style="border-top: medium none; border-left: medium none;">Grand Total</td> <td class="xl25" style="border-top: medium none; border-left: medium none;">Exe Name</td> <td class="xl25" style="border-top: medium none; border-left: medium none;">REMARKS</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt; border-top: medium none;" align="right" height="17">2</td> <td class="xl22" style="border-top: medium none; border-left: medium none;">A.A. Enginering</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">RETAIL/GJ/674</td> <td class="xl27" style="border-top: medium none; border-left: medium none;" align="right">31-Mar-09</td> <td class="xl28" style="border-top: medium none; border-left: medium none;" align="center">50152</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">Atul Jadhav</td> <td class="xl29" style="border-top: medium none; border-left: medium none;">Payment will done, PTP</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt; border-top: medium none;" align="right" height="17">3</td> <td class="xl22" style="border-top: medium none; border-left: medium none;">Ashta Vinayak Enterprises</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">TAX/MH/0774</td> <td class="xl27" style="border-top: medium none; border-left: medium none;" align="right">06-Oct-08</td> <td class="xl28" style="border-top: medium none; border-left: medium none;" align="center">46710</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">Atul Jadhav</td> <td class="xl29" style="border-top: medium none; border-left: medium none;">Paid on next week, call after some time</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt; border-top: medium none;" align="right" height="17">4</td> <td class="xl22" style="border-top: medium none; border-left: medium none;">Desigho Aluminium Glass House</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">RETAIL/0077</td> <td class="xl27" style="border-top: medium none; border-left: medium none;" align="right">18-May-06</td> <td class="xl28" style="border-top: medium none; border-left: medium none;" align="center">41039</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">Atul Jadhav</td> <td class="xl29" style="border-top: medium none; border-left: medium none;">Payment not revd, paid today</td> </tr> </tbody></table>

​

Here example, in remarks column after coma (,) feedback uploaded today and and i just want that info.
​

 

[Yahya]

May Be like this
<b>Excel 2007</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style=";">Party's Name</td><td style=";">Ref. No.</td><td style=";">Date</td><td style=";">Grand Total</td><td style=";">Exe Name</td><td style=";">REMARKS</td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style=";">A.A. Enginering</td><td style=";">RETAIL/GJ/674</td><td style="text-align: right;;">31-Mar-09</td><td style="text-align: center;;">50152</td><td style=";">Atul Jadhav</td><td style=";">Payment will done, PTP</td><td style=";"> PTP</td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style=";">Ashta Vinayak Enterprises</td><td style=";">TAX/MH/0774</td><td style="text-align: right;;">06-Oct-08</td><td style="text-align: center;;">46710</td><td style=";">Atul Jadhav</td><td style=";">Paid on next week, call after some time</td><td style=";"> call after some time</td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style=";">Desigho Aluminium Glass House</td><td style=";">RETAIL/0077</td><td style="text-align: right;;">18-May-06</td><td style="text-align: center;;">41039</td><td style=";">Atul Jadhav</td><td style=";">Payment not revd, paid today</td><td style=";"> paid today</td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Sheet3</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">G2</th><td style="text-align:left">=MID(<font color="Blue">F2,FIND(<font color="Red">",",F2</font>)+1,LEN(<font color="Red">F2</font>)</font>)</td></tr></tbody></table></td></tr></table><br />

 

[Aladin Akyurek]

<TABLE border=0 cellSpacing=0 cellPadding=0 width=782 align=center><COLGROUP><COL style="WIDTH: 11pt" width=14><COL style="WIDTH: 152pt" width=202><COL style="WIDTH: 73pt" width=97><COL style="WIDTH: 51pt" width=68><COL style="WIDTH: 62pt" width=82><COL style="WIDTH: 55pt" width=73><COL style="WIDTH: 185pt" width=246><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="WIDTH: 11pt; HEIGHT: 12.75pt" class=xl29 height=17 width=14></TD><TD style="BORDER-LEFT: medium none; WIDTH: 152pt" class=xl29 width=202>A</TD><TD style="BORDER-LEFT: medium none; WIDTH: 73pt" class=xl29 width=97>B</TD><TD style="BORDER-LEFT: medium none; WIDTH: 51pt" class=xl29 width=68>C</TD><TD style="BORDER-LEFT: medium none; WIDTH: 62pt" class=xl29 width=82>D</TD><TD style="BORDER-LEFT: medium none; WIDTH: 55pt" class=xl29 width=73>E</TD><TD style="BORDER-LEFT: medium none; WIDTH: 185pt" class=xl29 width=246>F</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="HEIGHT: 12.75pt; BORDER-TOP: medium none" class=xl29 height=17 align=right>1</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl23>Party's Name</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl23>Ref. No.</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl24>Date</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl23>Grand Total</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl25>Exe Name</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl25>REMARKS</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="HEIGHT: 12.75pt; BORDER-TOP: medium none" class=xl29 height=17 align=right>2</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl22>A.A. Enginering</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl26>RETAIL/GJ/674</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl27 align=right>31-Mar-09</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl28 align=center>50152</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl26>Atul Jadhav</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl29>Payment will done, PTP</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="HEIGHT: 12.75pt; BORDER-TOP: medium none" class=xl29 height=17 align=right>3</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl22>Ashta Vinayak Enterprises</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl26>TAX/MH/0774</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl27 align=right>06-Oct-08</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl28 align=center>46710</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl26>Atul Jadhav</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl29>Paid on next week, call after some time</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="HEIGHT: 12.75pt; BORDER-TOP: medium none" class=xl29 height=17 align=right>4</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl22>Desigho Aluminium Glass House</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl26>RETAIL/0077</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl27 align=right>18-May-06</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl28 align=center>41039</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl26>Atul Jadhav</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl29>Payment not revd, paid today</TD></TR></TBODY></TABLE>

Here example, in remarks column after coma (,) feedback uploaded today and and i just want that info.​

Are you looking for:

Payment not revd, paid today

or the whole record at row 4?

 

[atuljadhav]

i want today's updates which is updated today whatever it is devided with coma or else., i know the formula of text to colum but what i do when whole don't have coma.

 

[Aladin Akyurek]

i want today's updates which is updated today whatever it is devided with coma or else., i know the formula of text to colum but what i do when whole don't have coma.

Is it possible that you literally specify what the desired result(s) is/are for the sample you posted?