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.
Menu
How to filter dr & cr. in excel from tally exported data
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.
Recent Topics :
- On which amount 200% penalty under section 270A is
- RECEIVED INTIMATION U/S 399 FOR TDS PAYMENT ON PRO
- How do CA firms track SEBI/AMFI circulars and dead
- Jurisdictional validity of Sec 148 notice after fa
- Taxable Income or Not
- GST Input Tax Credit (ITC) on Camera Purchase &
- What makes CA Himanshu Singla different from other
- TAX TREATMENT AND ACCOUNTING ENTRIEOF PERQUISITES
- Gifting money to my father-in-law (my husband's da
- GSTR-1 JSON from marketplace exports (Myntra / Ama
Related Topics :
CAclubindia
