1

I'm trying to find all the UNIQUE numbers of a column, but when i use the Excel function UNIQUE Excel makes a @ infront. I use xlwings, and have used (if, sum, average) function without any problems.

sheet.range('X1').value = ['=UNIQUE(A:A,FALSE,FALSE)']

Then excel writes it as: =@UNIQUE(A:A;FALSE;FALSE)

Munti
  • 23
  • 4
  • 2
    [This](https://stackoverflow.com/a/61138478/9758194) answer is related and will explain why it's happening. However, I would not know the correct syntax for xlwings to add array functionality. I can't imagine `.Value` does any good though. – JvdV Mar 11 '22 at 08:55

0 Answers0