How to Filter Debtors List in Ms. Excel

If you have recorded all debtors' transaction in ms. excel , then you need filter tool to analyze different debtors' list . You may be interested what is the balance of particular debtor from 500000 or 600000 debtors list in ms excel or you may be interested to know the debtors in different range . You may know who are the debtors whose balance is between Rs. 50000 to Rs. 70000 . So , all facility available in Filter .

First of all you have to select the title of data in ms excel , it may be name of debtors and amount receivable or balance . Then go to data option in menu bar and here you will see filter option , click it and then click on auto filter . After this you will see small filter button on the title of data . Click it and you can see the list of debtors . When you will select any debtor , excel show only that debtor's balance and all other debtors will hide . You can click also balance filter and select custom and here you can enter amount of balance between . After this click pop up box , you will see only all debtors who will come in this range .

Same filtering process can be done in google docs . In google docs , it is called " Validate data"
This option in tool of google spreadsheet . In pop up window of data validate you can fix the range of numbers as well as text also .



access account accountant Accounting accounting definitions accounting ebook Accounting education accounting procedure accounting process outsourcing Accounting Software advance advertising africa Amalgamation amendments announcements Annuity assets audit auditing Australia B.Com. balance sheet bank banking Bank reconciliation basic accounting BBA benefits best bill black money blog bloggers book keeping Branch Accounting - full tutorial budget Budget variance business businessman CA calculator canada capital capital budgeting career cash cash book cash flow statement Chiense children china class coaching coins college commerce commerce students company computer computer accounting conference Contact vinod kumar corporate accounting cost cost accounting cost center cost centre CPA credit credit card cs currency data Debit and credit debit cards debt debtor degree depletion depreciation documents dollar domain Downloads Dubai e-accounting earning education Education Loans email employee EPF ERP euromoney examination excel excise duty expenses facebook factor of loan fans feature fifo FII fiji finacle finance Financial financial accounting fire insurance flickr flow forensic forex formula france fraud free fun function fund GAAP GDP gdr germany gold goodwill goodwill accounting google google apps google base google buzz google calendar Google docs google finance google fusion tables google talk govt. guide health Hindi Hindi Language history holding company How to treat FBT in Tally 9 HRA ICAI ICAWI ICICI Bank IFRS income income statement Income Tax India indian railway Indonesia inflation inflation accounting infographics information inspiration insurance insurance accounting interest international Internet Introduction of Tally 9 inventory investment invoice IT Japan Job costing journal entries keyboard kindle kuwait laptop law LBT learning lease lecture ledger leducation Leverage Analysis liabilities lifo linkedin loan logical point loss loss of profit M.Com. m.phil malaysia management accounting manual accounting manufacturing account market marketing mastercard material MBA MCA media migration mobile money ms. excel ms word Multicurrency Accounting multi currency in tally 9 mutual fund national security new and sacrifice ratio news new york times new zealand NGO nonprofit-accounting North Georgia Mountains NPV NSE odbc office oman online accounting online application otcei pakistan parents pay pal pdf pie chart pie chart of income pnb podcast ppf presentation price privacy policy prize money prof. vinod kumar profit profit and loss account project management provision purchase puzzles quickbooks Quote quotes quotes of svtuition rating agency ratio analysis RBI readers real estate rectification of errors remote control reports reserves responsibility accounting retirement revenue Revenue reserves review risk rupees salary sale saudi arabia saving sbi scholarship school SEBI security service tax share Shares share trading shri lanka singapore sms social accounting society solution South Africa stock stock exchange structure student students study subsidiary company svtuition swiss bank tally Tally.ERP 9 Tally 7.2 Tally 9 tanzania tax Tax Accounting TDS teacher teaching technology test testimonial testimonials thailand tips trading trading on equity transaction trend trial balance tuition twitter UAE UGC - NET Commerce UK United Arab Emirates university usa valuation VAT Video Voucher and vouching wikipedia working capital youtube
Accounting Education: How to Filter Debtors List in Ms. Excel
How to Filter Debtors List in Ms. Excel
Accounting Education
Not found any posts VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES POSTS View All RECOMMENDED FOR YOU LABEL ARCHIVE SEARCH ALL POSTS Not found any post match with your request Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS CONTENT IS PREMIUM Please share to unlock