arunjoshi123
New Member
- Joined
- Feb 19, 2016
- Messages
- 1
Please see this link: https://drive.google.com/file/d/0B0F5ZCsTvPP2Tm9fRWVWT1pZZzg/view?usp=sharing
Open the sheet - Capex. See the value of quantity (highlighted in yellow) for items Laptops and Mobiles by sorting on Item and Category alternatively. You will see, it shows 10,10 once and 10, 100 some other time. By default, sorting is on Item and one can see that I want the number of mobiles equal to the number of laptops (such is my capital expenditure etc. 10 each). I occasionally need to sort on Category and see how project looks. The number of mobiles was set=H29. After sorting on category the formula has become =H32 which is no more number of laptops. Even if I make it $H$29, same thing happens. What is happening? What is the way out? How come H32? Any alternate way to avoid? The interlinks in my model far more complex within a row and between/among rows. I have taken simplest case. What to do? Please let me know if you need any more clarification.
Open the sheet - Capex. See the value of quantity (highlighted in yellow) for items Laptops and Mobiles by sorting on Item and Category alternatively. You will see, it shows 10,10 once and 10, 100 some other time. By default, sorting is on Item and one can see that I want the number of mobiles equal to the number of laptops (such is my capital expenditure etc. 10 each). I occasionally need to sort on Category and see how project looks. The number of mobiles was set=H29. After sorting on category the formula has become =H32 which is no more number of laptops. Even if I make it $H$29, same thing happens. What is happening? What is the way out? How come H32? Any alternate way to avoid? The interlinks in my model far more complex within a row and between/among rows. I have taken simplest case. What to do? Please let me know if you need any more clarification.