Posted to microsoft.public.excel.misc

colensa

external usenet poster

Posts: 4

counting matching multiple entries

I have two columns containing numbers.
I want to count the frequency with which the two columns' numbers match i.e.
the number of times 5,9 or 6,8 or 13,21 etc etc crop up (sports scores) and
leave the spreadsheet showing each unique number combination and the number
of times it occurs. Can I do this in one operation?

Colensa

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Combine Multiple Entries with differing amounts of entries	Katie	Excel Worksheet Functions	2	November 28th 07 09:53 PM
Matching List Entries	steev_jd	Excel Discussion (Misc queries)	3	April 6th 06 03:11 PM
Matching and Copying entries	Box666	Excel Discussion (Misc queries)	1	January 9th 06 09:45 PM
Help matching entries in two sheets???	Curalice	Excel Worksheet Functions	2	November 12th 05 07:53 PM
matching column entries	billytf	Excel Worksheet Functions	6	April 11th 05 06:41 AM

All times are GMT +1. The time now is 03:09 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us