find the correct sum
HI EXPERTS,
i hope you and excel can do this. i have a master data with so many rows. i.e A B C D No Name City Values 1 Tony Tokyo 100 2 Bob Singapore 3081 - 5000 John India 6 total values more than 1,000,000 now my boss ask me to find values with total sum i.e 258,918 from data above. i can do this manually, but made me dizzy :) i hope excel can do this by code, (using loping), after excel find 258,918, copy it to next column or give a color in that cells. can excel do this, or should create program using vb? can anybody help me? hope you understand with what i want to achieve. many thanks regards, reza |
find the correct sum
See:
http://www.tushar-mehta.com/excel/te...ues/index.html -- Gary''s Student - gsnu201003 "reza" wrote: HI EXPERTS, i hope you and excel can do this. i have a master data with so many rows. i.e A B C D No Name City Values 1 Tony Tokyo 100 2 Bob Singapore 3081 - 5000 John India 6 total values more than 1,000,000 now my boss ask me to find values with total sum i.e 258,918 from data above. i can do this manually, but made me dizzy :) i hope excel can do this by code, (using loping), after excel find 258,918, copy it to next column or give a color in that cells. can excel do this, or should create program using vb? can anybody help me? hope you understand with what i want to achieve. many thanks regards, reza |
All times are GMT +1. The time now is 01:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com