Remove {} Added automatically in Unique formula

[UmeirOmar]

Hello,

How do I remove the braces generated automatically on the formula after saving the document?


Thanks,
Umeir Omar

 

[Special-K99]

What's the formula look like, exactly?
Why do you want to remove the braces, they're usually there for a good reason?

 

[Joe4]

Welcome to the Board!

Those curly brackets usually let you know that it was an array formula that was entered with CTRL+SHIFT+ENTER.
See: Excel Array formula | Exceljet

 

[UmeirOmar]

Hi thanks for the reply,

Just moments ago I actually managed to fix the issue, I've saved the file in a different format (xls to .xlsx)

I wanted to remove the braces because the table I was extracting the Unique values from is constantly updating. Meaning that once I save the file by the end of the day, the next day if I changed the table the Unique formula would be protected by {}, and it wasn't extracting the updated values as it should. Therefore I would have to redo the formula every time I closed the excel.
But now it's automated, the formula is kept "Open" and it always updates accordingly.

Thanks again.
UO