I have seven different columns with data that I want the =UNIQUE formula to draw from. So far no combination of formulas or other manipulations that I've tried have allowed me to compile unique values from more than one range. In my "plan B" that I'm currently using, I have seven =UNIQUE formulas in one hidden column, and my final column draws from that hidden column, but I would much rather do it directly in one formula if it's possible. Thanks in advance!