Excel 2007 : Sorting

[Zeeb]

so i tried to do some sorting but i'm not sure i quite understand it..

i choose the column i wanted and set "sort on" to value and order to ">15000 & < 25000"
i want this to only show the results are between 15000 and 25000 but it does not seem to be working.

for another column i set "sort on" to value and order to "a" what i wanted this to do was to only show data in the column containing the letter "a" but again it's not working could anyone help me out here?

[chetanmehra1989]

Can u provide me dummy data then i will gave right solution

[Zeeb]

dummy data below. what i want to do is find the ones whos numbers are between 300-500 and who has a name with an "a" in it

Please Login or Register  to view this content.

[chetanmehra1989]

1. First of fall copy the data and paste special with value or text in excel sheet
2. Go to Cell A1 create filter (Alt+d+f+f)
3. in Coloum B Create Custom Auto filter is greater than 300 and is less than 500
4. in Coloum A Create Custom Auto Filter Begins With Text a