| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Want to count all repeated number only once in Excel 2007.
I have a data:
set A 3 21 23 30 43 1 20 36 52 53 18 19 36 45 59 9 16 27 35 57 set B 4 16 23 36 53 I want to create a formula that will count how many number in set B are repeated in set A. So set B has 16, 23, 36, 53 repeated in set A. there return value should be 4 because I only one to count each repeat number in set B only once. I have count the =countif(a1:e4,a6)+countif(a1:e4,a7)....but it gave me the total sum of each repeats..5. And that's not what I wanted? Please help. thanks EggHeadCafe - Software Developer Portal of Choice Spambot Killer ASP.NET Mailto: Hyperlink Control http://www.eggheadcafe.com/tutorials...aspnet-ma.aspx |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I do A repeated measures ANOVA on Excel 2007??? | Excel Worksheet Functions | |||
| Count of times a number is repeated by date? | Excel Worksheet Functions | |||
| How can I count the frequency that a number is repeated? | Excel Worksheet Functions | |||
| how to count maximum number of lines repeated for a site | Excel Worksheet Functions | |||
| how do I count the number of times a word is repeated in a range? | Excel Discussion (Misc queries) | |||
Threaded Mode
