Re: $$Excel-Macros$$ Formula to Display Latest PO number Using date and emp ID

2015-07-22 Thread Eugene Bernard
Hi Van, Excellent sample, Thanks. Eugene On Wed, Jul 22, 2015 at 12:47 AM, Bé Trần Văn wrote: > B3 selected in the drop down list, View Results. > > 2015-07-21 19:08 GMT+07:00 Paul Schreiner : > >> First: >> Your EMP ID field is mixed with "text" and "numbers". >> Probably because this list wa

Re: $$Excel-Macros$$ Formula to Display Latest PO number Using date and emp ID

2015-07-21 Thread Bé Trần Văn
B3 selected in the drop down list, View Results. 2015-07-21 19:08 GMT+07:00 Paul Schreiner : > First: > Your EMP ID field is mixed with "text" and "numbers". > Probably because this list was imported from another source. > (generated a report as a text file and opened it in Excel?) > > then, if y

Re: $$Excel-Macros$$ Formula to Display Latest PO number Using date and emp ID

2015-07-21 Thread Paul Schreiner
First:Your EMP ID field is mixed with "text" and "numbers".Probably because this list was imported from another source.(generated a report as a text file and opened it in Excel?) then, if you click in one of the cells, or remove spaces, or interact with the cell in several other ways, Excel rein