Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
TRYING TO SORT OR FILTER DUPLICATE DATA
I have two columns, one with numbers and another with yes or no. In the
number column I will have 5 digit numbers that may repeat 2 to three times in that column and along side in the other column it will say either yes or no. For any particular number it will only say yes or no, it wont be yes in one row and no in another. This information gets uplinked from another sheet and hence is that way. heres a sample Warranty W.O. YES 66888 YES 66888 NO 67471 NO 67471 YES 66992 YES 66992 YES 66992 YES 66948 YES 66948 NO 66945 Now what I need to do is count the number of W.O's that were waranty and which were not, without couting twice or thrice for the same W.O. So in this example it would need to be a small table like this Warranty Yes NO Number of WO's 3 2 would really appreciate any help. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Match and Sort two range of data? | New Users to Excel | |||
Pivot Table Data Filter Problem | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) | |||
How do I sort a column of data and have each data row sort accordi | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |