Hi,
please help,
How to extract unique values from A column to G column and group by month only using formulae(array)?
I have A1 which is DATE, B1 is DRIVER, C1 Quantity.
Let's say in A2:A10 are random dates between October to December 2023(there may be blank cells), in G2:G4 i want results Oct.23,Nov.23 and Dec.23, this formula isn't working:I'm from EU, ; separator and still using Office2013.![]()
Please Login or Register to view this content.
Thanks in advance as always, God Bless
Bookmarks