Frank Kabel

[Guest]

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!!!

 

[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?

 

[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

 

[Guest]

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

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: