compare recurring item between month

hi guys,

need a huge favor here, i have some item in each month, the item is just same item with selling quantity different each month.

the different is sometimes we received those item and sometimes we didnt received.

when i put all item in table then do the pivot table chart.. we can easily see the increase or decreasing there but then if someone asking can we compare same item we received last month with this month.. then i have a problem

right now i'm do it manually by add 1 cell then find(vlookup( but all i want is if we can find some automatic way to compare which month vs which month with based only for same item that we received in those both month

attached is the file, you can click slicers recurring and non recurring then you can find comparison same item last on feb & march..i cannot do that manually every time if someone ask : can we compare jan to feb? (then i have to do manual vlookup again )

compare recurring item.xlsx

Hi
I have created the required list in sheet2 using sumproduct

Please Login or Register  to view this content.

This formula requires that the value of sale should be greater than 0 to perform correctly or you can use extra column with '1' in each cell and use instead of $G$3:$G$500.

Regards

Hi
I am not as good in VBA
In sheet2 if you change the month you will get the yes and no according to that item received or not in both months.

May be someone else can help you.

Regards

maybe a silly question, but how can i download your file.

maybe you can upload your file here.

I noticed you uploaded it there, but how can i download it?

You want to achieve the differance in total per month?

See the attached file (see the yellow cells).