E
EM
Hi,
Are there any known problems with Excel's list functionality?
For example I have a number of columns displaying data. Typically the list
lets me filter it by any unique value within the column. Example:
ID
=
1
2
3
4
The list functionality shows me various options in a dropdown, including
filtering by 1, 2, 3 or 4.
This all works great. The problem I'm having is that sometimes not every
unique value is listed. I've only noticed this problem when I have a _lot_ of
unique data in the column... I'm thinking this might be a problem with a
limitation on the drop-down box and the number of options it can show.
Is anyone aware of such a limitation?
Thanks,
Edward
Are there any known problems with Excel's list functionality?
For example I have a number of columns displaying data. Typically the list
lets me filter it by any unique value within the column. Example:
ID
=
1
2
3
4
The list functionality shows me various options in a dropdown, including
filtering by 1, 2, 3 or 4.
This all works great. The problem I'm having is that sometimes not every
unique value is listed. I've only noticed this problem when I have a _lot_ of
unique data in the column... I'm thinking this might be a problem with a
limitation on the drop-down box and the number of options it can show.
Is anyone aware of such a limitation?
Thanks,
Edward