Quote Originally Posted by Keerthi@21 View Post
1) I have an sheet named "Pivot" which contains item details along with its amount related to sales data. What i exactly need is - Excel formula to be updated for the logic-> Wherever negative sign is available in the Units Cost column, mapping key need to be changed accordingly. (example – mapping key for account number "4016000" should be updated as“40” and "607412" should be “50"
Where does the mapping key find account number "4016000" or "607412"? In fact where does this reside given that you have provided a snapshot rather meaningless data?