Forum Discussion
Using UNIQUE, FILTER, and VSTACK together
Hey everyone, I’m trying to combine data from 12 different sheets on the same workbook and ignore blank cells. If I use: =UNIQUE(VSTACK(‘January 2024’!A3:B65,‘February 2024’!A3:B65,‘March 2024’!A3:B6...
= IF ( UNIQUE(VSTACK(‘January 2024’!A3:B65,‘February 2024’!A3:B65,‘March 2024’!A3:B65,‘April 2024’!A3:B65, ‘May 2024’!A3:B65, ‘June 2024’!A3:B65, ‘July 2024’!A3:B65, ‘August 2024’!A3:B65, ‘September 2024’!A3:B65, ‘October 2024’!A3:B65, ‘November 2024’!A3:B65, ‘December 2024’!A3:B65)) = "" ,
"",
UNIQUE(VSTACK(‘January 2024’!A3:B65,‘February 2024’!A3:B65,‘March 2024’!A3:B65,‘April 2024’!A3:B65, ‘May 2024’!A3:B65, ‘June 2024’!A3:B65, ‘July 2024’!A3:B65, ‘August 2024’!A3:B65, ‘September 2024’!A3:B65, ‘October 2024’!A3:B65, ‘November 2024’!A3:B65, ‘December 2024’!A3:B65))
)
This works accordingly in my small example.