Remove duplicates in Excel for IPad

[ChetShannon]

I am trying to see if there is a workaround for getting a list of unique values in Excel for iPad? I see there are no pivot tables nor is there a ‘remove duplicates’ function in Excel for iPad.
Thanks!

 

[Fluff]

You could use the Unique Function. UNIQUE function

 

[ChetShannon]

You could use the Unique Function. UNIQUE function

Thank you MUCH. I wasn’t aware of that function. Is there a trick to copying the output range of the Unique function. I tried the usual method Select range, copy but the paste into the new range did not work and nothing was pasted. Thank you again.

 

[Fluff]

I know nothing about ipads, so cannot help with that.