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

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

2015-07-21 Thread SridharBL
Dear Friends, I need help in creating the formula in attached file. In attached sheet. I have Sheet9 and Data Sheets. In Sheep 9, If I type the Emp ID in the cell, its should look for data in Data sheet for the Emp ID and Latest Date for in column ""Period To" and get the New PO number that w