How do I Sort Less than Rs. 200.00 Recharge

[basavarajkh]

Hi


How do I Sort Less than Rs. 200.00 Recharge


Please find link below


http://speedy.sh/7fJSt/Sort-Less-than-200-Rs-Recharge.xlsx


in column G


pls help me


Thanks in advance

 

[mahaveer]

http://www.2shared.com/file/bvb7supe/Sort_Less_than_200_Rs_Recharge.html


check you file now on the above link..........


Regards

CA Mahaveer Somani

 

[basavarajkh]

please explain me how you did?

 

[mahaveer]

i made filter for row 1

then i click on the filter of column G

then i select number filters

then i select less than option

then i put there "200" value and click ok

thats it.....


i hope now you understood.......it properly.....


Regards

CA Mahaveer Somani

 

[basavarajkh]

I understood but

How you Remove "Rs."

Please explain me

 

[mahaveer]

i select the Whole column G and then i press Ctrl + H

there i write find = Rs.

and Replace = "nothing"


so it deletes all Rs.


Regards

CA Mahaveer Somani