You are here: HomeExcelTutorials
Facebook Twitter Reddit More...

Extracting List of Occurrences

Extracting List of Occurrences

Price: FREE

I have a large data table. In column A (say A1:A100) there will be random occurrences of particular items of text, ie:
Oranges
Peaches
etc
etc
Obviously I can count how many times each item occurs using COUNTIF or SUMPRODUCT but how do I extract a simple list of all the different types of items? I just need a list as above, ignoring the fact that any one item may occur several hundred times (ie; a list exactly like you get on the drop-down when filtering data).

Visit publisher's web-site: Extracting List of Occurrences

Category and Tags: ExcelTutorials : : Functions

Related Tutorials

Extracting entries from large list

Free: Yes
Tags: Excel ›

I have a rather large list of customers for our non-profit (almost 700 names) and it is set up to keep track of this years purchases of six different products. The products are in different columns and contain just one number to indicate number of items purchased. They may have purchased one or all six items.
I am trying to find an efficient way to extract this years customers and purchases and create a list that I can take to our distribution site to keep track of who has shown up and what they should be receiving.
There has to be an easy way to do this, but I haven't found it yet.

Sorting by number of occurrences

Free: Yes
Tags: Excel ›

Please see the attached spreadsheet. I have a list of 1268 names, some of them appearing more than once. I want to know how many times each name appears on the list, and then rank the names by the number of times they're listed.

Extracting a list from an array

Free: Yes
Tags: Excel ›

I have a large rectangular table filled with cells each holding
numerical integer values, from -2,00 to + 2,00.
I want to extract a listing sorted by values, ending up with a two column list data in the form of:
Value1, frequency1
Value2, frequency2
Etc...
Is there a statistical or other Function which will accomplish this

Extracting numbers from tables

Free: Yes
Tags: Excel ›

I run excel 2007 on a mac and I'm having trouble extracting numbers from a table to create another separate table or list. Spreadsheet attached is how I get the information from a 3rd party and I want to simply extract the weekly total hours so that I have a list something like that in blue. It can be anywhere just I need the information with no gaps
I've been trying to do this for couple of days now and really need an answer, as I've hundreds to go through for a couple of years worth of data.
I need the new table to be in a format so that I can then easily run formula's off of these numbers.

Counting occurrences only once in a list of duplicates basing the range off of a date

Free: Yes
Tags: Excel ›

need help with this.
Column L contains the values I want to count the occurrences of. The list contains some values once, some multiple times. For example, the list contains the word "near" 32 times and the word "far" 1 time, BUT I only want to count 2 (once for each word)
Now I have seen the equation that does this for a set range:
=SUMPRODUCT(($A$1:$A$100<>"")/COUNTIF($A$1:$A$100,$A$1:$A$100&""))
And I understand what it does (Not really positive on how it actually works the calculation).
Anyways - Column J includes the date. So I want to make the above calculation (counting each unique occurrences only once in a list that includes duplicates) where it only looks at Column L cells that corresponding to Column J cells of the date in question.

Related Applications & Scripts

Online link extractor utility

Free: Yes
Tags: Web Services › Excel Link Based

Free link extractor tool helps in extracting the url or link from a specific web page.

Attachments Processor for Outlook

Free: No
Tags: Software › Excel Emailing

Attachment Processor is the most powerful and multifunctional addon for Microsoft Outlook for managing of attached files.
This addon for Microsoft Outlook includes the functionality of three products:
Attachments Processor: allows extracting attachments from the incoming messages and save them to your hard disk (extracted attachments are replaced in the incoming message with a link to the file on the disk or a text file with an attachment description as well and a link to it).
Attachments Zip Compressor: allows automatic archiving the attached files by ZIP both for incoming and outgoing messages. It can create self-extracting archives and password-protected archives.
Blocked Attachments management: utility for managing the list of attachment types, which are blocked by the Outlook security system (only for Internet Mail).
Attachments Processor is compatible with Microsoft Outlook 2010, 2007, 2003, 2002/XP and 2000. It is one of a number of outlook add-ins that works both with Microsoft Exchange server and Internet Mail (POP3/IMAP). Unsecured attachments blocked by the Microsoft Outlook security system can be saved on the hard drive and also there is an utility for managing the list of attachment types, which are blocked by the Outlook security system (only for Internet Mail). The program works both in manual and automatic modes.

CodePeople List

Free: No
Tags: DreamWeaver › Excel Forms

The ComboBox can be configured to allow selection of multiple options, but in this case a list of options with CheckBox is much more intuitive for users.
CodePeople List transform ComboBox with multiple selection into a CheckBox list, and also to allow the incorporation of new options that are not part of the initial listing.

Mailman Mailing List Manager

Free: Yes
Tags: Python › Excel Mailing Lists

Mailman is Python-based software to help manage email discussion lists, much like Majordomo and Smartmail. Unlike most similar products, Mailman gives each mailing list a web page, and allows users to subscribe, unsubscribe, etc. over the web. Even the list manager can administer his or her list entirely from the web. Mailman also integrates most things people want to do with mailing lists, including archiving, mail-to-news gateways, multiple list owners and moderators, and so on.

Relational List

Relational List is a Dreamweaver extension that allows to insert two associated lists (select fields) into your forms, a main list and a subordinate list. This is useful if you need related fields into your forms, for example country/states, brand/model, etc. In these cases the second field is populated when the user select the value for the first one. Relational List executes these actions without reloading the page, through the use of dynamic Javascript and Ajax technologies. The fields’ data are retrieved from XML files. You can edit your own XML files for your form fields.
Requirements:
Adobe Dreamweaver MX or later

© 2014 Contact us - Privacy Policy - Terms of use - Add Listing