Merge tables following Group by (Max) values change error?

jilbobagins

Member
Joined
Apr 11, 2019
Messages
80
Reaction score
0
Points
6
Excel Version(s)
2016
Hi,

strange one! Following a tables grouping (by item) and including the Max Value (against a decimal value qty in this case) I then merge to another table with matching items and the Max value from the first table changes !!??

very odd and has got me a little confused

any ideas ?
 
As a workaround you have to insert an index before the merge, or enclose the merge in a Table.Buffer. This will cause the data to be reloaded internally.
 
I will give that a go! Many thanks for responding so quickly ��

Great experts on this site !
 
Back
Top