Forum Discussion
How work with a DATA of more de 70.000 rows?
I'm working on an Excel from a csv file with over 70,000 lines. But when I use the formulas of x.lookup, Sum.ifs or unique... Excel doesn't show all the details because Excel has more than 10,000 ...
OliverScheurich,
So my excel is weird, because i got this message:
"This column contains over 10,000 unique items. Only the first 10,000 unique items are displayed."
So my excel is weird, because i got this message:
"This column contains over 10,000 unique items. Only the first 10,000 unique items are displayed."
I guess this message when you use filtering, not with formula
Not all items are displayed in the AutoFilter/PivotTable list (microsoft.com)