Thread: Sorting

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?

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

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

Walter	349	mauris@velit.com
Donovan	698	magna@semperauctor.org
Macon	119	vulputate.ullamcorper.magna@ligula.ca
Louis	105	odio@ipsumprimisin.org
Damian	522	in.tempus.eu@augue.com
Jackson	615	sem.mollis.dui@malesuadafamesac.ca
Hayes	37	risus.Donec@Ut.edu
Gabriel	188	Duis@consequatenim.com
Bert	121	viverra@purusmaurisa.org
Amos	482	luctus.Curabitur.egestas@consectetueradipiscing.com
Darius	470	quis@velquamdignissim.ca
Thomas	144	ornare@ipsumprimis.com
Sawyer	490	diam.nunc@nequevenenatislacus.com
Myles	345	auctor.nunc.nulla@non.com
Lance	465	volutpat.Nulla@erat.org
Walter	377	et.malesuada@elitpellentesquea.edu
Cadman	478	ipsum.dolor@arcu.ca
Bruce	518	iaculis@turpis.org
Dillon	736	laoreet.ipsum.Curabitur@musProin.ca
Thane	236	morbi.tristique@nectempusmauris.org
Jonah	129	auctor.velit.Aliquam@etultricesposuere.org
Brian	205	faucibus.Morbi@nequeetnunc.edu
Byron	50	ut.odio.vel@et.com
Moses	82	et@Fuscealiquam.com
Daniel	165	sodales@duiFusce.com
Cody	135	metus@veliteu.org
Hashim	539	interdum.ligula.eu@esttemporbibendum.edu
Solomon	22	nisi.dictum@Ut.edu
Keaton	700	porta.elit@neque.org
Keaton	488	pellentesque@DonecegestasDuis.edu
Driscoll	71	egestas.lacinia.Sed@blanditatnisi.com
Lester	706	sagittis.felis@DonectinciduntDonec.edu
Brennan	158	Nunc@lorem.org
Emmanuel	353	erat@molestie.org
Yuli	394	Aliquam.ornare.libero@bibendumullamcorper.edu
Hilel	96	arcu.Aliquam@vel.org
August	347	turpis.Aliquam@eratnonummyultricies.ca
Scott	424	eu.eleifend@Nam.edu
Chandler	613	Phasellus.at.augue@augueeu.com
Zeph	176	tellus.eu@eratvolutpat.org
Herrod	450	enim@turpis.org
Phelan	389	ante.bibendum@libero.ca
Cade	465	et.lacinia.vitae@lacusvestibulum.org
Rooney	216	ipsum.ac.mi@Donectempor.com
Theodore	269	dignissim.lacus.Aliquam@accumsannequeet.ca
Anthony	468	ut.ipsum@Fusce.com
Dante	213	Cras@Proinegetodio.ca
Galvin	577	mi@Mauris.edu
Laith	560	tellus@cursus.ca
Beck	16	elementum.sem.vitae@euodio.ca
Reuben	421	odio.semper@consectetuermaurisid.com
Price	551	quis@nibhvulputate.com
Laith	591	pede.nonummy@auctorvelit.org
Merrill	588	placerat.eget@sapienmolestieorci.ca
Hunter	458	tincidunt.adipiscing.Mauris@porttitor.com
Amir	691	varius.ultrices.mauris@cursusnonegestas.ca
Clayton	473	pede.Cras@tinciduntDonec.edu
Abbot	312	Donec.dignissim.magna@sapien.com
Ali	420	amet.risus@nisl.ca
Galvin	441	Mauris@Duisat.com
Cody	91	nunc@hendreritconsectetuercursus.edu
Christopher	236	ut@elementumpurusaccumsan.ca
William	208	dui.nec@sedconsequatauctor.org
Allen	32	in@antelectus.ca
Carson	352	Proin@velitdui.ca
Flynn	685	arcu@velit.ca
Zahir	255	ullamcorper.eu@eratEtiam.ca
Ian	569	dapibus.id@feugiatSednec.ca
Hilel	169	consectetuer.mauris.id@risusaultricies.edu
Driscoll	166	placerat.orci.lacus@lacus.edu
Grady	211	eu@lectusCum.com
Damon	515	posuere@feugiatSed.edu
Devin	392	dui@ullamcorpereueuismod.com
Hop	617	aliquet.Phasellus@torquent.com
Clinton	150	at.pretium.aliquet@montesnascetur.edu
Brady	264	Integer.urna@viverra.edu
Jesse	316	at.fringilla@euismodenimEtiam.org
Nicholas	356	dictum.eu.eleifend@montes.ca
Gannon	439	quis.lectus@quisdiamPellentesque.edu
Devin	548	neque@in.ca
Caesar	183	nascetur.ridiculus.mus@Curae;Phasellusornare.com
Linus	561	Aliquam@mi.org
Kasper	222	Vivamus.nibh@volutpatNullafacilisis.org
Moses	690	imperdiet.nec.leo@tellusimperdietnon.com
Price	417	porttitor@Fuscedolorquam.org
Ishmael	201	consequat@Mauris.com
Demetrius	94	eu@Donectempor.ca
Elliott	269	Duis@ultrices.ca
Yardley	47	Nullam.vitae@fringillaeuismod.org
Hashim	418	ac@nonbibendumsed.edu
Stewart	428	cursus.luctus@nislQuisquefringilla.ca
Brian	12	Sed.auctor.odio@eratSed.com
Melvin	138	nec.ante@metus.com
Tad	266	sollicitudin@estNunclaoreet.edu
Phelan	627	dolor@semPellentesque.ca
Brock	254	ut.quam.vel@liberoProin.org
Orlando	482	bibendum@fermentummetusAenean.edu
Baxter	362	mauris.ut@atpretiumaliquet.com
Preston	32	iaculis.nec@elementumloremut.edu
Elliott	483	a.purus.Duis@Donecvitaeerat.org

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