Hi,
I have a list of products all with a current price and a was price.
I have a separate sheet which contains the history of all of the pricing on the products and I want to find out from that list, when the was price I have was live.
The trouble is for some of the products I have 8 or 9 lines worth of history, so I can't do a simple look up to find the date.
Does anyone have any ideas?
<colgroup><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
So I'm trying to pull back the date of when the now was price equals the prod_lst_prc
Thanks
I have a list of products all with a current price and a was price.
I have a separate sheet which contains the history of all of the pricing on the products and I want to find out from that list, when the was price I have was live.
The trouble is for some of the products I have 8 or 9 lines worth of history, so I can't do a simple look up to find the date.
Does anyone have any ideas?
<colgroup><col><col><col><col><col><col><col></colgroup><tbody> </tbody> |
<colgroup><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
So I'm trying to pull back the date of when the now was price equals the prod_lst_prc
Thanks