Here is a fun one. I had a column with around 200 entries and there were some duplicates in it. I just wanted to see which were duplicates and remove some of them.

I selected the cells and asked copilot to tell me which ones were duplicated. Copilot had to ask me to copy and paste the cell contents in its chat box. It couldn't even detect which cells were selected and read them

Why even have copilot inside excel when it can't even read a cell? This is what happens when all you care is about KPI metrics or what not