G
Guest
I have a large file with multipule names in over 1800 rows, as well as other
information in the columns, such as ref numbers. The problem is when I use
Autofilter, some of the names in one column doesn't show in the drop down
box. As an example, let say you have the letter A in A1, B in A2 and C in A3
with the heading of "Letters". When you use autofilter, you should see A, B,
C in the drop box. However, in my case, I'm only seeing A and C, I'm not able
to find B in the drop down box list. I'm seeing this same problem in my
spreadsheet, however, it's on a much larger scale. What is more frustrating,
is when I use the autofilter drop box I can see (for example) letter X in row
1200 but letter Y in row 1201 isn't avaliable. There isn't any gaps
inbetween the data, and I can't see any reason why a field in a column
wouldn't show up when the one right above it is showing up!
If anyone has clue on how to fix this, please let me know!!!
information in the columns, such as ref numbers. The problem is when I use
Autofilter, some of the names in one column doesn't show in the drop down
box. As an example, let say you have the letter A in A1, B in A2 and C in A3
with the heading of "Letters". When you use autofilter, you should see A, B,
C in the drop box. However, in my case, I'm only seeing A and C, I'm not able
to find B in the drop down box list. I'm seeing this same problem in my
spreadsheet, however, it's on a much larger scale. What is more frustrating,
is when I use the autofilter drop box I can see (for example) letter X in row
1200 but letter Y in row 1201 isn't avaliable. There isn't any gaps
inbetween the data, and I can't see any reason why a field in a column
wouldn't show up when the one right above it is showing up!
If anyone has clue on how to fix this, please let me know!!!