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 Topic
- Dividend and withholding tax - DTAA- RSU
- NRI Query: Capital Gains Tax Exemption under Secti
- Royalty payment to UK
- Calculate ITR2 tax with equity and non equity prof
- LTCG on residential property sale - Rebate?
- TDS MISMATCH AND AIS
- Return filing for intervening period upto date of
- EPF Withdrawal taxation
- While e filing otp not generating
- INCOME FROM CLOSING OF NSS -1992 -EXEMPT UNDER W
Related Topics
CAclubindia
