How to filter dr & cr. in excel from tally exported data

Others 3352 views 2 replies

1) Place your cursor on cell D3 and go into the Define Name (Formulas -> Define Name/Name Manager)
2) Ener Name as "CRDR" (of your choice if you want) and under "Refers to" enter this formula =Get.cell(7,!C3)
3) On Cell D3, enter =CRDR, this should display the custom format applied on the cell like (0.00 "DR").
4) Enter the same formula =CRDR on all the Cells on D column
5) Apply autofilter on the D column, using custom filters, filter as desired.

Replies (2)

"Sorry, I am not a featured member."

For featured members contact....

https://www.caclubindia.com/catalogue/featured.asp

Thanks for sharing.
Download XLTOOL Excel To Tally FREE 100% version. 
Import All Vouchers and Masters in Tally Prime, ERP 9, Tally 7.2
Also Export Tally data to Excel.
Source: www.xltool.in.


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Related Threads
Loading