Hi, I'm attempting to copy one specific column (containing string values) from a table and then narrow them down to unique values only and get rid of blanks. I've scoured the internet and am still not sure of a good way to handle this. I have found where I can easily copy an entire table into an array, but I just want one column for now. My ultimate plan is to use those unique values to roll up dollar values in another column in the same table. Basically very similar to what a pivot table would do. But I need to add some more functionality later, so a pivot table won't do. Thanks!