ExcelNewbe
New Member
- Joined
- Jan 26, 2011
- Messages
- 4
Hello
i am a bit stumped and need an expert's advice! I am trying to perform an advanced filter on a worksheet and i can't figure out why it is not picking up all the matches.
I am searching for the term 'akhund' and i would like to copy the results to another part of the worksheet. I insert a few blank lines at the top of the sheet, copy the headings and under Name of Individual or Entity column i type akhund - i then perform the advanced filter - i get only 2 results but i know there at at least 28 (i did a manual Find).
I did notice that if i manually go and type in akhund in some cells and run the advanced filter again it picks them up - so i am thinking it has to do with the formatting of the cells or something like that.
Can someone have a look at my file and help me out? i have uploaded the file here http://wikisend.com/download/544236/regulation8_consolidated.xls
Thanks!!
Deb
i am a bit stumped and need an expert's advice! I am trying to perform an advanced filter on a worksheet and i can't figure out why it is not picking up all the matches.
I am searching for the term 'akhund' and i would like to copy the results to another part of the worksheet. I insert a few blank lines at the top of the sheet, copy the headings and under Name of Individual or Entity column i type akhund - i then perform the advanced filter - i get only 2 results but i know there at at least 28 (i did a manual Find).
I did notice that if i manually go and type in akhund in some cells and run the advanced filter again it picks them up - so i am thinking it has to do with the formatting of the cells or something like that.
Can someone have a look at my file and help me out? i have uploaded the file here http://wikisend.com/download/544236/regulation8_consolidated.xls
Thanks!!
Deb
Last edited:
