Detecting Duplicate Pairs

S

stylencia18

New Member
Joined
Aug 14, 2017
Messages
31
Please help!! I have a large list ofcompanies (approx. 180,000 rows) that placed bids on different contracts. I amtrying to determine how to figure out how many TOTAL times each company bidagainst one another. Any suggestions?? Sample dataset is below:


Contract Number (Column A) Company Bidder Name (Column S)
15461 Fun Company Inc.
15461 Joe’s Pools
15461 Molly’s Restaurantand Co.
15461 Alpha’s Dreamhouse
15461 Wonder Inc.
15461 Go N Wash LLC
22222 Go N Wash LLC
22222 Fun Company Inc.
22222 Sandra’s Steak NMore
22222 Crab Co.
22222 Designer Outlet
22222 Shoes For All
22222 Joe’s Pools
22222 Hard Life LLC
36363 Go N Wash LLC
36363 All the Time Inc.
36363 Peruvian ChickenCo.
36363 Crab Co.
36363 Maryland Crab Co.
36363 Blue Crab Co.
36363 Wonder Inc.
36363 Alpha Streams LLC
36363 Day N Night Inc.
36363 Fun Company Inc.
36363 Allison’sPlayground Inc.




 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
Sort by date Sort by votes
Hey stylencia18,

This is one way to do it via a VBA code if you like. The way it works that it will show you an input box where you have to enter the first company name & then another input box for the second company name then it will show you the number of contacts they bid against. Let me know if this works for you or in case you are having any issues

PS. Couple of remarks:

  1. I assumed that your data starts in cell A1 with a header in row 1
  2. When you write the company name in the input box, it will also search partial text so ensure to have the exact company name to avoid mistakes

Code: 
Sub CompaniesList()
Dim Dic As Object, k As Variant, Ar As Variant, CompA As String, CompB As String, Cnt As Long
Set Dic = CreateObject("scripting.dictionary")
CompA = InputBox("Please enter first company name below ...")
CompB = InputBox("Please enter second company name below ...")
Ar = ActiveSheet.Range("A1").CurrentRegion.Value
For i = 2 To UBound(Ar)
    If Not Dic.exists(Ar(i, 1)) Then
        Dic.Add Ar(i, 1), Ar(i, 19)
    Else
        Dic(Ar(i, 1)) = Dic(Ar(i, 1)) & "," & Ar(i, 19)
    End If
Next i
ReDim Ar(1 To Dic.Count, 1 To 1)
For Each k In Dic.keys
    If InStr(1, Dic(k), CompA, 1) > 0 And InStr(1, Dic(k), CompB, 1) > 0 Then
        Cnt = Cnt + 1
        Ar(Cnt, 1) = k
    End If
Next
If MsgBox("There is " & Cnt & " contract(s) that both" & vbNewLine & _
    "    a. " & CompA & vbNewLine & "    b. " & CompB & vbNewLine & _
    "placed bids against. Would you like to see the contract numbers in a separate new sheet ?" _
    , vbYesNo + vbInformation) = vbYes Then
    With Sheets.Add(after:=Sheets(Sheets.Count))
        .Range("A1") = "Contract Number"
        .Range("A2").Resize(UBound(Ar)) = Ar
    End With
End If
End Sub
 
Upvote 0
Thank you for replying! If I have a list of 8,000 companies do I need to run a macro for each pair of companies?












mse330 said:
Hey stylencia18,

This is one way to do it via a VBA code if you like. The way it works that it will show you an input box where you have to enter the first company name & then another input box for the second company name then it will show you the number of contacts they bid against. Let me know if this works for you or in case you are having any issues

PS. Couple of remarks:

  1. I assumed that your data starts in cell A1 with a header in row 1
  2. When you write the company name in the input box, it will also search partial text so ensure to have the exact company name to avoid mistakes

Code: 
Sub CompaniesList()
Dim Dic As Object, k As Variant, Ar As Variant, CompA As String, CompB As String, Cnt As Long
Set Dic = CreateObject("scripting.dictionary")
CompA = InputBox("Please enter first company name below ...")
CompB = InputBox("Please enter second company name below ...")
Ar = ActiveSheet.Range("A1").CurrentRegion.Value
For i = 2 To UBound(Ar)
    If Not Dic.exists(Ar(i, 1)) Then
        Dic.Add Ar(i, 1), Ar(i, 19)
    Else
        Dic(Ar(i, 1)) = Dic(Ar(i, 1)) & "," & Ar(i, 19)
    End If
Next i
ReDim Ar(1 To Dic.Count, 1 To 1)
For Each k In Dic.keys
    If InStr(1, Dic(k), CompA, 1) > 0 And InStr(1, Dic(k), CompB, 1) > 0 Then
        Cnt = Cnt + 1
        Ar(Cnt, 1) = k
    End If
Next
If MsgBox("There is " & Cnt & " contract(s) that both" & vbNewLine & _
    "    a. " & CompA & vbNewLine & "    b. " & CompB & vbNewLine & _
    "placed bids against. Would you like to see the contract numbers in a separate new sheet ?" _
    , vbYesNo + vbInformation) = vbYes Then
    With Sheets.Add(after:=Sheets(Sheets.Count))
        .Range("A1") = "Contract Number"
        .Range("A2").Resize(UBound(Ar)) = Ar
    End With
End If
End Sub
Click to expand...
 
Upvote 0
For the code provided above yes, you would have to run each pair. Can you post a sample of the expected result & I’ll adjust the code accordingly
 
Upvote 0
maybe

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td=bgcolor:#70AD47]Company Bidder Name[/td][td=bgcolor:#70AD47]Count[/td][td=bgcolor:#70AD47]Contract Number[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]Fun Company Inc.[/td][td=bgcolor:#E2EFDA]
3​
[/td][td=bgcolor:#E2EFDA]15461, 22222, 36363[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Joe’s Pools[/td][td]
2​
[/td][td]15461, 22222[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]Molly’s Restaurantand Co.[/td][td=bgcolor:#E2EFDA]
1​
[/td][td=bgcolor:#E2EFDA]15461[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Alpha’s Dreamhouse[/td][td]
1​
[/td][td]15461[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]Wonder Inc.[/td][td=bgcolor:#E2EFDA]
2​
[/td][td=bgcolor:#E2EFDA]15461, 36363[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Go N Wash LLC[/td][td]
3​
[/td][td]15461, 22222, 36363[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]Sandra’s Steak NMore[/td][td=bgcolor:#E2EFDA]
1​
[/td][td=bgcolor:#E2EFDA]22222[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Crab Co.[/td][td]
2​
[/td][td]22222, 36363[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]Designer Outlet[/td][td=bgcolor:#E2EFDA]
1​
[/td][td=bgcolor:#E2EFDA]22222[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Shoes For All[/td][td]
1​
[/td][td]22222[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]Hard Life LLC[/td][td=bgcolor:#E2EFDA]
1​
[/td][td=bgcolor:#E2EFDA]22222[/td][/tr]

[tr=bgcolor:#FFFFFF][td]All the Time Inc.[/td][td]
1​
[/td][td]36363[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]Peruvian ChickenCo. [/td][td=bgcolor:#E2EFDA]
1​
[/td][td=bgcolor:#E2EFDA]36363[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Maryland Crab Co.[/td][td]
1​
[/td][td]36363[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]Blue Crab Co.[/td][td=bgcolor:#E2EFDA]
1​
[/td][td=bgcolor:#E2EFDA]36363[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Alpha Streams LLC[/td][td]
1​
[/td][td]36363[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]Day N Night Inc.[/td][td=bgcolor:#E2EFDA]
1​
[/td][td=bgcolor:#E2EFDA]36363[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Allison’sPlayground Inc.[/td][td]
1​
[/td][td]36363[/td][/tr]
[/table]

or post expected result for your example
 
Upvote 0
Hey mse330:

I was hoping to obtain aresult similar to the following:


Company Names Numberof Contracts Bid Against Each Other
Fun Company Inc. & Joe’sPools 1
Go N Wash LLC & FunCompany Inc. 4


Is it possible to generate alist of all potential company pairs and then run a count?


Apologies if this doesn’tmake sense!
 
Upvote 0
here is a part of the list

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td=bgcolor:#70AD47]VS[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]Fun Company Inc. & Joe’s Pools[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Fun Company Inc. & Molly’s Restaurantand Co.[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]Fun Company Inc. & Alpha’s Dreamhouse[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Fun Company Inc. & Wonder Inc.[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]Fun Company Inc. & Go N Wash LLC[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Fun Company Inc. & Sandra’s Steak NMore[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]Fun Company Inc. & Crab Co.[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Fun Company Inc. & Designer Outlet[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]Fun Company Inc. & Shoes For All[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Fun Company Inc. & Hard Life LLC[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]Fun Company Inc. & All the Time Inc.[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Fun Company Inc. & Peruvian ChickenCo. [/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]Fun Company Inc. & Maryland Crab Co.[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Fun Company Inc. & Blue Crab Co.[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]Fun Company Inc. & Alpha Streams LLC[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Fun Company Inc. & Day N Night Inc.[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]Fun Company Inc. & Allison’sPlayground Inc.[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Joe’s Pools & Fun Company Inc.[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]Joe’s Pools & Molly’s Restaurantand Co.[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Joe’s Pools & Alpha’s Dreamhouse[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]Joe’s Pools & Wonder Inc.[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Joe’s Pools & Go N Wash LLC[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]Joe’s Pools & Sandra’s Steak NMore[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Joe’s Pools & Crab Co.[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]Joe’s Pools & Designer Outlet[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Joe’s Pools & Shoes For All[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]Joe’s Pools & Hard Life LLC[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Joe’s Pools & All the Time Inc.[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]Joe’s Pools & Peruvian ChickenCo. [/td][/tr]

[tr=bgcolor:#FFFFFF][td]Joe’s Pools & Maryland Crab Co.[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]Joe’s Pools & Blue Crab Co.[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Joe’s Pools & Alpha Streams LLC[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]Joe’s Pools & Day N Night Inc.[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Joe’s Pools & Allison’sPlayground Inc.[/td][/tr]
[/table]

can you say what you want to count???
 
Upvote 0
How did you do that?! I am trying to count the number of contracts they both bid on. In other words, when both company names appear under the same contract number.
 
Upvote 0
like this?

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td=bgcolor:#70AD47]Contract Number[/td][td=bgcolor:#70AD47]Count[/td][td=bgcolor:#70AD47]VS[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]
15461​
[/td][td=bgcolor:#E2EFDA]
102​
[/td][td=bgcolor:#E2EFDA]Fun Company Inc. & Joe’s Pools[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
15461​
[/td][td]
102​
[/td][td]Fun Company Inc. & Molly’s Restaurantand Co.[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]
15461​
[/td][td=bgcolor:#E2EFDA]
102​
[/td][td=bgcolor:#E2EFDA]Fun Company Inc. & Alpha’s Dreamhouse[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
15461​
[/td][td]
102​
[/td][td]Fun Company Inc. & Wonder Inc.[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]
15461​
[/td][td=bgcolor:#E2EFDA]
102​
[/td][td=bgcolor:#E2EFDA]Fun Company Inc. & Go N Wash LLC[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
15461​
[/td][td]
102​
[/td][td]Fun Company Inc. & Sandra’s Steak NMore[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]
15461​
[/td][td=bgcolor:#E2EFDA]
102​
[/td][td=bgcolor:#E2EFDA]Fun Company Inc. & Crab Co.[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
15461​
[/td][td]
102​
[/td][td]Fun Company Inc. & Designer Outlet[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]
15461​
[/td][td=bgcolor:#E2EFDA]
102​
[/td][td=bgcolor:#E2EFDA]Fun Company Inc. & Shoes For All[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
15461​
[/td][td]
102​
[/td][td]Fun Company Inc. & Hard Life LLC[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]
15461​
[/td][td=bgcolor:#E2EFDA]
102​
[/td][td=bgcolor:#E2EFDA]Fun Company Inc. & All the Time Inc.[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
15461​
[/td][td]
102​
[/td][td]Fun Company Inc. & Peruvian ChickenCo. [/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]
15461​
[/td][td=bgcolor:#E2EFDA]
102​
[/td][td=bgcolor:#E2EFDA]Fun Company Inc. & Maryland Crab Co.[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
15461​
[/td][td]
102​
[/td][td]Fun Company Inc. & Blue Crab Co.[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]
15461​
[/td][td=bgcolor:#E2EFDA]
102​
[/td][td=bgcolor:#E2EFDA]Fun Company Inc. & Alpha Streams LLC[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
15461​
[/td][td]
102​
[/td][td]Fun Company Inc. & Day N Night Inc.[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]
15461​
[/td][td=bgcolor:#E2EFDA]
102​
[/td][td=bgcolor:#E2EFDA]Fun Company Inc. & Allison’sPlayground Inc.[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
15461​
[/td][td]
102​
[/td][td]Joe’s Pools & Fun Company Inc.[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]
15461​
[/td][td=bgcolor:#E2EFDA]
102​
[/td][td=bgcolor:#E2EFDA]Joe’s Pools & Molly’s Restaurantand Co.[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
15461​
[/td][td]
102​
[/td][td]Joe’s Pools & Alpha’s Dreamhouse[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]
15461​
[/td][td=bgcolor:#E2EFDA]
102​
[/td][td=bgcolor:#E2EFDA]Joe’s Pools & Wonder Inc.[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
15461​
[/td][td]
102​
[/td][td]Joe’s Pools & Go N Wash LLC[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]
15461​
[/td][td=bgcolor:#E2EFDA]
102​
[/td][td=bgcolor:#E2EFDA]Joe’s Pools & Sandra’s Steak NMore[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
15461​
[/td][td]
102​
[/td][td]Joe’s Pools & Crab Co.[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]
15461​
[/td][td=bgcolor:#E2EFDA]
102​
[/td][td=bgcolor:#E2EFDA]Joe’s Pools & Designer Outlet[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
15461​
[/td][td]
102​
[/td][td]Joe’s Pools & Shoes For All[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]
15461​
[/td][td=bgcolor:#E2EFDA]
102​
[/td][td=bgcolor:#E2EFDA]Joe’s Pools & Hard Life LLC[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
15461​
[/td][td]
102​
[/td][td]Joe’s Pools & All the Time Inc.[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]
15461​
[/td][td=bgcolor:#E2EFDA]
102​
[/td][td=bgcolor:#E2EFDA]Joe’s Pools & Peruvian ChickenCo. [/td][/tr]

[tr=bgcolor:#FFFFFF][td]
15461​
[/td][td]
102​
[/td][td]Joe’s Pools & Maryland Crab Co.[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]
15461​
[/td][td=bgcolor:#E2EFDA]
102​
[/td][td=bgcolor:#E2EFDA]Joe’s Pools & Blue Crab Co.[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
15461​
[/td][td]
102​
[/td][td]Joe’s Pools & Alpha Streams LLC[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]
15461​
[/td][td=bgcolor:#E2EFDA]
102​
[/td][td=bgcolor:#E2EFDA]Joe’s Pools & Day N Night Inc.[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
15461​
[/td][td]
102​
[/td][td]Joe’s Pools & Allison’sPlayground Inc.[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]
15461​
[/td][td=bgcolor:#E2EFDA]
102​
[/td][td=bgcolor:#E2EFDA]Molly’s Restaurantand Co. & Fun Company Inc.[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
15461​
[/td][td]
102​
[/td][td]Molly’s Restaurantand Co. & Joe’s Pools[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]
15461​
[/td][td=bgcolor:#E2EFDA]
102​
[/td][td=bgcolor:#E2EFDA]Molly’s Restaurantand Co. & Alpha’s Dreamhouse[/td][/tr]
[/table]

but this is 425 rows...

or like this with PivotTable

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]Contract Number[/td][td=bgcolor:#DDEBF7]Count[/td][td=bgcolor:#DDEBF7]VS[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
15461​
[/td][td]
102​
[/td][td]Alpha’s Dreamhouse & All the Time Inc.[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td]Alpha’s Dreamhouse & Allison’sPlayground Inc.[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td]Alpha’s Dreamhouse & Alpha Streams LLC[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td]Alpha’s Dreamhouse & Blue Crab Co.[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td]Alpha’s Dreamhouse & Crab Co.[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td]Alpha’s Dreamhouse & Day N Night Inc.[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td]Alpha’s Dreamhouse & Designer Outlet[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td]Alpha’s Dreamhouse & Fun Company Inc.[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td]Alpha’s Dreamhouse & Go N Wash LLC[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td]Alpha’s Dreamhouse & Hard Life LLC[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td]Alpha’s Dreamhouse & Joe’s Pools[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td]Alpha’s Dreamhouse & Maryland Crab Co.[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td]Alpha’s Dreamhouse & Molly’s Restaurantand Co.[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td]Alpha’s Dreamhouse & Peruvian ChickenCo. [/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td]Alpha’s Dreamhouse & Sandra’s Steak NMore[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td]Alpha’s Dreamhouse & Shoes For All[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td]Alpha’s Dreamhouse & Wonder Inc.[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td]Fun Company Inc. & All the Time Inc.[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td]Fun Company Inc. & Allison’sPlayground Inc.[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td]Fun Company Inc. & Alpha Streams LLC[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td]Fun Company Inc. & Alpha’s Dreamhouse[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td]Fun Company Inc. & Blue Crab Co.[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td]Fun Company Inc. & Crab Co.[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td]Fun Company Inc. & Day N Night Inc.[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td]Fun Company Inc. & Designer Outlet[/td][/tr]
[/table]
 
Last edited:
Upvote 0
I was hoping to obtain aresult similar to the following:

Company Names DistinctCount of Contracts Bid Against Each Other Contract Numbers
Fun Company Inc. & Joe’sPools 1 15461

Go N Wash LLC & FunCompany Inc. 2 22222, 36363

 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Question Question
Conditional sum help?
Replies
5
Views
5K
stanleydgromjr
S

Forum statistics

Threads
1,223,895
Messages
6,175,257
Members
452,625
Latest member
saadat28

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top