Prev: Excel - not everything is printing out?
Next: how to drag the cell to assign numbers by skipping one row each ti
From: reza on 21 May 2010 02:01
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

From: Gary''s Student on 21 May 2010 06:52
See:

http://www.tushar-mehta.com/excel/templates/match_values/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
>
 | 
Pages: 1
Prev: Excel - not everything is printing out?
Next: how to drag the cell to assign numbers by skipping one row each ti