Excel Formula for Quick Data Sorting

-
Cpearson's page contains list of most of the excel formula, which can aid after patent ananlysis and data sorting for creating IP maps.

Comments

Unknown said…
ys it possible
we will have to rank the numbers first
and put the s.No and do Vlookup with he S.no
then it will come in decending order.
9:42 AM
Post a Comment

Popular posts from this blog

WIPO Pearl - Recap

-
WIPO’s multilingual terminology portal gives access to scientific and technical terms derived from patent documents. It helps promote accurate and consistent use of terms across different languages, and makes it easier to search and share scientific and technical knowledge. You can conduct your searches by following two modes: Linguistic Search  :  WIPO’s multilingual terminology portal gives access to scientific and technical terms derived from patent documents. Search by term, with optional parameters. Select a Source Language for best results, and disable ad-blocking plug-ins. Concept Map Search  :  WIPO’s multilingual terminology portal gives access to scientific and technical terms derived from patent documents. Search by concept, or by subject field/subfield by clicking on the bubbles; click on a concept to open the terminology record. Select a second concept to view the concept path, and click on the "Export concept path" button to perform a combined keyword search
Read more

Databases on the FDA Website

-
The search engine on the FDA Website will not find information that is in the databases that make up a large part of the site. Those databases can be accessed separately, using the links below. Following each link is a brief description of the database. Animal Feed and Drugs FDA Approved Animal Drug Products : A listing of searchable databases in the following categories: Approved Animal Drug Products (Basic search), Approved Animal Drug Products (Advanced search), Suitability Petitions, Sponsors, Green Book, Code of Federal Regulations, Federal Register, Patents, and Exclusivity. FDA BSE/Ruminant Feed Inspections Firms Inventory : Inspection information of renderers, feed mills, ruminant feeders, protein blenders, pet food manufacturers, pet food salvagers, animal feed distributors and transporters, ruminant feeders, and others regarding compliance with the BSE/Ruminant Feed regulations. Biological Products Adverse Event Reporting System : The Adverse Event Reporting System is a compu
Read more

Zotero - Next Generation Research Tool

-
Image
Zotero is a free citation management tool to help you save and organize citations and automatically create formatted bibliographies. Zotero Key Features Automatically extract citation information from websites, library catalogs, databases, and more. Save PDF files, images, screenshots, and other files. Record your research notes. Automatically create formatted bibliographies in many different styles. Use Zotero with word processing programs like Microsoft Word. Sync the citations and files you save online. Access your saved information from anywhere. Share your saved information online with groups. Use Zotero -- an open source tool -- for free. To get Started                         Go to  http://www.zotero.org/  and click on the red  Download  button.
Read more