Hi, i have a peculiar problem - i have a spreadsheet with roughly 100 rows and when i apply the filter on any of the columns and select a value for filter, it selects that value but also other rows in seemingly random fashion as well. Any idea what i'm doing wrong ? Thanks !
Last edited by Hagar Delest on Sun May 19, 2013 7:28 pm, edited 3 times in total.
Reason:tagged solved.
I've seen this come up before, either here or on another forum, but I can't find the post, or remember if it was solved.
Are you using AutoFilter or Standard Filter? Have you filtered other spreadsheets without this problem occuring? Are you able to attach the spreadsheet here - i.e. is it non-confidential?
I experienced this using the AutoFilter. This happens to me when I retrieve a data table previously saved with the AutoFilter mode "on" and then I add data to the table from the last row on. I've solved this turning the autofilter off and then on again, before filtering the table containing the recently added rows. S.Lopez