Frank Kabel

M

Micos3

Hello!

I have a doubt that no one can take it off and i'm around and around the
problem and because of a part i can't solve it.
This is the problem:
A B C D
Prod. Stock In Out
Wine 10 3 6
Fish 13 2 1

What i want to do is to identify the product that has move quantity in or
out such as quantity that has been moved, once i solve this problem i think i
can do the rest of problem.
Can you help me???
Thank you very much!!!
 
F

Frank Kabel

Hi
not really sure what you mean by 'move quantity'. In your example what
would be your expected result and how would you identify it?
 
J

JulieD

Hi Micos

if i understand you correctly you want to be able to identify which column
has been changed last - C or D
for each product. If so, this can not be done with a formula you will need
to use code.

if this is the case, please post back with confirmation and an idea how
you'ld like this to be identified - an entry in column E or the last value
changed to change colour or

Cheers
JulieD
 
M

Micos3

Thank u two and sorry to put ur name in topic but i'm.....
Julie u undearstand me in one part, i'll try explain better.
With example i gave i'll continue from there ok? Let's supose that in the
two examples the product has IN first.
A B C D
Prod. Stock In Out
Wine 10 3 6 (apply this formula on stock B=B+C-D)
Fish 13 2 1
Click to expand...

i had 13 pieces of wine in stock put more 3(C) then take 6(D).
What i wanted was to get in a cell in a row:
G H I
WINE 3 IN (preferencialy in other sheet these 3 col.)
WINE 6 OUT
The problem is that with many products we have another 'X', because can
appear ex. WINE or FISH and so in row i show as G we can see what product is.

Can anyone undearstand me? :)

Cause like this with a NOW(DATE) and with a filter i can have a historical
register with more than 65000 lines.
I guess is more clear now and the purpous too.
Is tangable?

Thanks

"JulieD" escreveu:
 
Top