Forum

Thanks Philip its working fine.

Thanks Hans! its working yes im using 2019 excel

i tried in sumifs but vertically not working ART + Color Total Pairs 7½ 8 8½ 9 9½ 10 10½ 11 11½ 12 12½ 13 13½ 14 15 ...

there is any other option to work in 2016

Thanks Riny van... I got it my answer in your updated file can u help me again for size wise group pairs

Hi... Here is the two files if receipts person changed any qty in E column, its will reflect in Issue column E which is i have updated in Sumif for...

Hi Hans first thanks for your reply, there is two department receipts & Issues so same using two person. i think no need to show issue details...

Thanks a lot Mynda got it my answer.

Hi Mynda there is duplicate item possible to way remove this duplicate data.

Hi Riny van thanks its working fine. Regards/Saliha