Complicated Match/Lookup in between dates formula?

jwillits

New Member
Joined
Jul 10, 2018
Messages
36
Office Version
  1. 2010
Platform
  1. Windows
Objective: I am trying to obtain a number (ID) from Table A based off of the Date and Number in Table B. What I am trying to say in my formula is that if Phone Number in Table B is equal to a Phone Number in Table A, and the Date in Table B in the same row as that Phone Number is between the Start and End Date in Table A, then I want the corresponding ID from Table A generated in the first column in Table B.

Furthermore, if the phone number matches but it does not fall between a one of the list of dates, I need it to pull the ID from the closest range of dates before it.

For instance, the last row in Table B has a Master Date of 4/22/19, however there is no date range in Table A for it, so it is pulling the ID from the date ranges of 3-26-19 to 4-1-19 because it is the closest date ranges before the master date.

Hopefully this makes sense and there is some wizard out there who can accomplish this. Multiple formulas building on each other is fine as well.





Table A

NameIDDate StartDate EndPhone Number
Apple

<tbody>
</tbody>
375
12/30/2018

<tbody>
</tbody>
1/5/2019

<tbody>
</tbody>
210-908-5231

<tbody>
</tbody>
Pear224
12/30/2018

<tbody>
</tbody>
1/5/2019

<tbody>
</tbody>
210-361-8442

<tbody>
</tbody>
Grape846
3/26/2019

<tbody>
</tbody>
4/1/2019

<tbody>
</tbody>
210-361-5592

<tbody>
</tbody>
Lemon552
5/26/2019

<tbody>
</tbody>
6/1/2019

<tbody>
</tbody>
210-361-5592

<tbody>
</tbody>

<tbody>
</tbody>

<tbody>
</tbody>



Table B

IDMaster DatePhone Number
2241/3/19
210-361-8442

<tbody>
</tbody>
8463/27/19210-361-5592
8464/22/19210-361-5592

<tbody>
</tbody>
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
This array formula turned out.

Maybe someone else can help you with a shorter one.

<table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:76.04px;" /><col style="width:76.04px;" /><col style="width:76.04px;" /><col style="width:76.04px;" /><col style="width:128.32px;" /><col style="width:76.04px;" /><col style="width:76.04px;" /><col style="width:76.04px;" /><col style="width:122.61px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td><td >D</td><td >E</td><td >F</td><td >G</td><td >H</td><td >I</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td style="background-color:#ffff00; font-weight:bold; text-align:center; ">Name</td><td style="background-color:#ffff00; font-weight:bold; text-align:center; ">ID</td><td style="background-color:#ffff00; font-weight:bold; text-align:center; ">Date Start</td><td style="background-color:#ffff00; font-weight:bold; text-align:center; ">Date End</td><td style="background-color:#ffff00; font-weight:bold; text-align:center; ">Phone Number</td><td style="background-color:#ffff00; font-weight:bold; "> </td><td style="background-color:#ffff00; font-weight:bold; text-align:center; ">ID</td><td style="background-color:#ffff00; font-weight:bold; text-align:center; ">Master Date</td><td style="background-color:#ffff00; font-weight:bold; text-align:center; ">Phone Number</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td >Apple</td><td style="text-align:right; ">375</td><td style="text-align:right; ">30/12/2018</td><td style="text-align:right; ">05/01/2019</td><td >210-908-5231</td><td > </td><td style="text-align:right; ">224</td><td style="text-align:right; ">03/01/2019</td><td >210-361-8442</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td >Pear</td><td style="text-align:right; ">224</td><td style="text-align:right; ">30/12/2018</td><td style="text-align:right; ">05/01/2019</td><td >210-361-8442</td><td > </td><td style="text-align:right; ">846</td><td style="text-align:right; ">27/03/2019</td><td >210-361-5592</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td >grape</td><td style="text-align:right; ">846</td><td style="text-align:right; ">26/03/2019</td><td style="text-align:right; ">01/04/2019</td><td >210-361-5592</td><td > </td><td style="text-align:right; ">846</td><td style="text-align:right; ">22/04/2019</td><td >210-361-5592</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td >lemon</td><td style="text-align:right; ">552</td><td style="text-align:right; ">26/05/2019</td><td style="text-align:right; ">01/06/2019</td><td >210-361-5592</td><td > </td><td > </td><td > </td><td > </td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b></b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Array Formula</td></tr><tr><td >G2</td><td >{=IFERROR(INDEX($B$1:$B$5,LARGE(IF(($E$2:$E$5=I2)*($C$2:$C$5<=H2)*($D$2:$D$5>=H2),ROW($A$2:$A$5)),1)),INDEX($B$1:$B$5,MAX(IF(ABS($C$2:$C$5-H2)=MIN(ABS($C$2:$C$5-H2),ABS($D$2:$D$5-H2)),ROW($B$2:$B$5),IF(ABS($D$2:$D$5-H2)=MIN(ABS($C$2:$C$5-H2),ABS($D$2:$D$5-H2)),ROW($B$2:$B$5))))))}</td></tr></table></td></tr></table>


Array formulas
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
Note: Do not try and enter the {} manually yourself
 
Upvote 0


Code:
=sum(if($e$2:$e$5=l2;if(k2>$c$2:$c$5;if(k2<$d$2:$d$5;j2;index($b$2:$b$5;match(min(abs($c$2:$c$5-k2));abs($c$2:$c$5-k2);0)));index($b$2:$b$5;match(max(abs($c$2:c$5-k2));abs($c$2:$c$5-k2);0)));"no"))

So, I used this formula and dragged the fill handle and get the exact results as you, 224;846;846. I already blocked the cells.
IMPORTANT: When you enter the formula, don't press just ENTER, instead press CTRL + SHIFT + ENTER. It will appear "{}" on the formula. This is because you have to cell by cell and compare with your master date.

Hope I could help.
 
Upvote 0
Sorry, didn't see your response. Perhaps yours is better than mine. But they are very similar! :)

Welcome to the forum!

Do not worry. The important thing is to deliver the best response to the OP.
They are similar, but you missed to include the dates in column D, to also verify with those dates which is the closest.

-------------

The same formula but a little shorter.

ZelleFormel
G2{=IFERROR(INDEX($B$1:$B$5,LARGE(IF(($E$2:$E$5=I2)*($C$2:$C$5<=H2)*($D$2:$D$5>=H2),ROW($A$2:$A$5)),1)),INDEX($B$1:$B$5,MAX(((ABS($D$2:$D$5-H2)=MIN(ABS($C$2:$C$5-H2),ABS($D$2:$D$5-H2)))+(ABS($C$2:$C$5-H2)=MIN(ABS($C$2:$C$5-H2),ABS($D$2:$D$5-H2))))*ROW($B$2:$B$5))))}

<tbody>
</tbody>
 
Upvote 0
Welcome to the forum!

Do not worry. The important thing is to deliver the best response to the OP.
They are similar, but you missed to include the dates in column D, to also verify with those dates which is the closest.

-------------

The same formula but a little shorter.

ZelleFormel
G2{=IFERROR(INDEX($B$1:$B$5,LARGE(IF(($E$2:$E$5=I2)*($C$2:$C$5<=H2)*($D$2:$D$5>=H2),ROW($A$2:$A$5)),1)),INDEX($B$1:$B$5,MAX(((ABS($D$2:$D$5-H2)=MIN(ABS($C$2:$C$5-H2),ABS($D$2:$D$5-H2)))+(ABS($C$2:$C$5-H2)=MIN(ABS($C$2:$C$5-H2),ABS($D$2:$D$5-H2))))*ROW($B$2:$B$5))))}

<tbody>
</tbody>




Code:
=sum(if($e$2:$e$5=l2;if(k2>$c$2:$c$5;if(k2<$d$2:$d$5;j2;index($b$2:$b$5;match(min(abs($c$2:$c$5-k2));abs($c$2:$c$5-k2);0)));index($b$2:$b$5;match(min(abs($c$2:c$5-k2));abs($c$2:$c$5-k2);0)));"no"))
I think I did compare, but used MAX when I should used MIN, because you always want the minimum difference.
I tryed yours and get all done. Although when you use
Code:
LARGE(IF(($E$2:$E$5=I2)*($C$2:$C$5<=H2)*($D$2:$D$5>=H2)
I don't know what "*" are for? Never used before.
Been wondering why your formula use "," and mine ";".
 
Upvote 0
Code:
=sum(if($e$2:$e$5=l2;if(k2>$c$2:$c$5;if(k2<$d$2:$d$5;j2;index($b$2:$b$5;match(min(abs($c$2:$c$5-k2));abs($c$2:$c$5-k2);0)));index($b$2:$b$5;match(min(abs($c$2:c$5-k2));abs($c$2:$c$5-k2);0)));"no"))
I think I did compare, but used MAX when I should used MIN, because you always want the minimum difference.
I tryed yours and get all done. Although when you use
Code:
LARGE(IF(($E$2:$E$5=I2)*($C$2:$C$5<=H2)*($D$2:$D$5>=H2)
I don't know what "*" are for? Never used before.
Been wondering why your formula use "," and mine ";".

"*" is a nested if.

if (condition, if (condition, true))
or
if (condition * condition, true)


"," or ";" It is the argument separator that you have configured by region.
 
Upvote 0
These do not seem to be working when I switch the columns I am using into the formula and I can not figure out why. I could send you the actual workbook I am using, however I do not see an attachment button anywhere.

The formula seems to not have errors, however it is pulling the incorrect numbers.
 
Last edited:
Upvote 0
Here is the actual data from my workbook. Note that this info is contained on different pages. In this case, could you write the formula trying to get the Related Weekly Spend number from Sheet2 into the column on Sheet1?

The rules are the same as that I need the Tracking Number to Match from Sheet1 to Sheet2, and then I need the Date in Sheet1 to fall between the Date of the Matching Tracking Number. If there is none, I need it to go to the date range before it.


Sheet1

Related PatientRelated Weekly SpendDateTimeTracking Number
#N/A6/2/20193:56 PM210-960-9944
#N/A6/1/20192:52 PM210-239-2304
#N/A6/1/20192:12 PM210-610-9726
#N/A6/1/201911:35 AM210-263-3116
#N/A5/31/20192:30 PM210-361-3306
297875/31/20192:25 PM210-610-9726
#N/A5/31/20191:16 PM210-239-2304
296325/31/201910:35 AM210-361-1720
#N/A5/30/20193:05 PM210-610-9726
296345/30/20192:57 PM210-610-9726
196665/30/20192:28 PM210-960-9944
#N/A5/30/20191:44 PM210-361-1720
#N/A5/30/201911:56 AM210-944-4129
296265/30/201910:21 AM210-361-1720
#N/A5/30/201910:20 AM210-361-1720
#N/A5/30/201910:20 AM210-361-1720
296225/30/201910:18 AM210-361-1720
#N/A5/30/201910:17 AM210-361-1720
#N/A5/30/201910:17 AM210-361-1720
#N/A5/30/201910:16 AM210-361-1720
#N/A5/30/201910:16 AM210-361-1720
296245/30/201910:16 AM210-361-1720
#N/A5/30/201910:16 AM210-361-1720
296255/30/201910:16 AM210-361-1720

<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>


Sheet 2



Related Weekly Spend
ClinicReferral Detail - SourcesRelated Referral DetailReferral Detail - Record ID#Weekly Cost# of Times RanAdvertised NumberCost Per SpotCallrail callsWeek Start DateWeek End Date Tracking Number
375Male Medical Group (SO)TVDaytime at 9 (KABB)113$7501(210) 908-5231$75037512/30/20181/5/2019210908-5231210-908-5231
397Male Medical Group (SO)TVSA Living (WOAI)111$7501(210) 361-8442$75039712/30/20181/5/2019210361-8442210-361-8442
262Slimedica (San Pedro)TVDaytime at 9 (KABB)113$8501(210) 361-5592$8502625/26/20196/1/2019210361-5592210-361-5592
291Slimedica (San Pedro)TVSA Living (WOAI)111$7501(210) 361-1720$7502915/26/20196/1/2019210361-1720210-361-1720
338Male Medical Group (SO)BillboardBillboard (281/Beside Our Building)155$1,1747(210) 239-2304$167.713385/26/20196/1/2019210239-2304210-239-2304
356Male Medical Group (SO)BillboardBillboard (1604/Braun)156$3187(210) 960-9944$45.433565/26/20196/1/2019210960-9944210-960-9944
374Male Medical Group (SO)BillboardBillboard (35/Eisenhauer)157$4657(210) 263-3116$66.433745/26/20196/1/2019210263-3116210-263-3116
396Male Medical Group (SO)TVDaytime at 9 (KABB)113$8501(210) 908-5231$8503965/26/20196/1/2019210908-5231210-908-5231
418Male Medical Group (SO)TVSA Living (WOAI)111$7501(210) 361-8442$7504185/26/20196/1/2019210361-8442210-361-8442
428Male Medical Group (SO)TVGreat Day SA (KENS 5)112$1,0001(210) 361-3306$1,0004285/26/20196/1/2019210361-3306210-361-3306
493Male Medical Group (SO)NewspaperSA Express-News6$2,6802(210) 610-9726$1,3404935/26/20196/1/2019210610-9726210-610-9726
261Slimedica (San Pedro)TVDaytime at 9 (KABB)113$8501(210) 361-5592$8502615/19/20195/25/2019210361-5592210-361-5592
269Slimedica (San Pedro)TVSA Live (KSAT)114$1,7501(210) 361-1480$1,7502695/19/20195/25/2019210361-1480210-361-1480
290Slimedica (San Pedro)TVSA Living (WOAI)111$7501(210) 361-1720$7502905/19/20195/25/2019210361-1720210-361-1720
301Slimedica (San Pedro)TVGreat Day SA (KENS 5)112$1,0001(210) 361-8667$1,0003015/19/20195/25/2019210361-8667210-361-8667
337Male Medical Group (SO)BillboardBillboard (281/Beside Our Building)155$1,1747(210) 239-2304$167.713375/19/20195/25/2019210239-2304210-239-2304
355Male Medical Group (SO)BillboardBillboard (1604/Braun)156$3187(210) 960-9944$45.433555/19/20195/25/2019210960-9944210-960-9944
373Male Medical Group (SO)BillboardBillboard (35/Eisenhauer)157$4657(210) 263-3116$66.433735/19/20195/25/2019210263-3116210-263-3116
395Male Medical Group (SO)TVDaytime at 9 (KABB)113$8501(210) 908-5231$8503955/19/20195/25/2019210908-5231210-908-5231
417Male Medical Group (SO)TVSA Living (WOAI)111$7501(210) 361-8442$7504175/19/20195/25/2019210361-8442210-361-8442
433Male Medical Group (SO)TVSA Live (KSAT)114$2,5001(210) 361-1203$2,5004335/19/20195/25/2019210361-1203210-361-1203
453Male Medical Group (SO)RadioKISS 99.518$2,86547(210) 361-5581$60.964535/19/20195/25/2019210361-5581210-361-5581
460Male Medical Group (SO)RadioKONO 101.1103$015(210) 361-5581$04605/19/20195/25/2019210361-5581210-361-5581
480Male Medical Group (SO)RadioKTKX 106.7105$1,13051(210) 361-5581$22.164805/19/20195/25/2019210361-5581210-361-5581
492Male Medical Group (SO)NewspaperSA Express-News6$1,1481(210) 610-9726$1,1484925/19/20195/25/2019210610-9726210-610-9726
260Slimedica (San Pedro)TVDaytime at 9 (KABB)113$8501(210) 361-5592$8502605/12/20195/18/2019210361-5592210-361-5592
289Slimedica (San Pedro)TVSA Living (WOAI)111$7501(210) 361-1720$7502895/12/20195/18/2019210361-1720210-361-1720
336Male Medical Group (SO)BillboardBillboard (281/Beside Our Building)155$1,1747(210) 239-2304$167.713365/12/20195/18/2019210239-2304210-239-2304
354Male Medical Group (SO)BillboardBillboard (1604/Braun)156$3187(210) 659-7070$45.433545/12/20195/18/2019210659-7070210-659-7070
372Male Medical Group (SO)BillboardBillboard (35/Eisenhauer)157$4657(210) 263-3116$66.433725/12/20195/18/2019210263-3116210-263-3116
394Male Medical Group (SO)TVDaytime at 9 (KABB)113$8501(210) 908-5231$8503945/12/20195/18/2019210908-5231210-908-5231
416Male Medical Group (SO)TVSA Living (WOAI)111$7501(210) 361-8442$7504165/12/20195/18/2019210361-8442210-361-8442
452Male Medical Group (SO)RadioKISS 99.518$2,86548(210) 361-5581$59.694525/12/20195/18/2019210361-5581210-361-5581
459Male Medical Group (SO)RadioKONO 101.1103$015(210) 361-5581$04595/12/20195/18/2019210361-5581210-361-5581
479Male Medical Group (SO)RadioKTKX 106.7105$1,13053(210) 361-5581$21.324795/12/20195/18/2019210361-5581210-361-5581
491Male Medical Group (SO)NewspaperSA Express-News6$5,5573(210) 610-9726########4915/12/20195/18/2019210610-9726210-610-9726
509Slimedica (San Pedro)RadioMIX 96.1152$21529 $7.415095/12/20195/18/2019#VALUE! #VALUE!
512Slimedica (San Pedro)RadioMAGIC 105.3151$20029 $6.905125/12/20195/18/2019#VALUE! #VALUE!
259Slimedica (San Pedro)TVDaytime at 9 (KABB)113$8501(210) 361-5592$8502595/5/20195/11/2019210361-5592210-361-5592
288Slimedica (San Pedro)TVSA Living (WOAI)111$7501(210) 361-1720$7502885/5/20195/11/2019210361-1720210-361-1720
300Slimedica (San Pedro)TVGreat Day SA (KENS 5)112$1,0001(210) 361-8667$1,0003005/5/20195/11/2019210361-8667210-361-8667
335Male Medical Group (SO)BillboardBillboard (281/Beside Our Building)155$1,1747(210) 239-2304$167.713355/5/20195/11/2019210239-2304210-239-2304
353Male Medical Group (SO)BillboardBillboard (1604/Braun)156$3187(210) 659-7070$45.433535/5/20195/11/2019210659-7070210-659-7070
371Male Medical Group (SO)BillboardBillboard (35/Eisenhauer)157$4657(210) 263-3116$66.433715/5/20195/11/2019210263-3116210-263-3116
393Male Medical Group (SO)TVDaytime at 9 (KABB)113$8501(210) 908-5231$8503935/5/20195/11/2019210908-5231210-908-5231
415Male Medical Group (SO)TVSA Living (WOAI)111$7501(210) 361-8442$7504155/5/20195/11/2019210361-8442210-361-8442
427Male Medical Group (SO)TVGreat Day SA (KENS 5)112$1,0001(210) 361-3306$1,0004275/5/20195/11/2019210361-3306210-361-3306
451Male Medical Group (SO)RadioKISS 99.518$2,86548(210) 361-5581$59.694515/5/20195/11/2019210361-5581210-361-5581
458Male Medical Group (SO)RadioKONO 101.1103$015(210) 361-5581$04585/5/20195/11/2019210361-5581210-361-5581
478Male Medical Group (SO)RadioKTKX 106.7105$1,13052(210) 361-5581$21.734785/5/20195/11/2019210361-5581210-361-5581
490Male Medical Group (SO)NewspaperSA Express-News6$5,5573(210) 610-9726########4905/5/20195/11/2019210610-9726210-610-9726
508Slimedica (San Pedro)RadioMIX 96.1152$21528 $7.685085/5/20195/11/2019#VALUE! #VALUE!
511Slimedica (San Pedro)RadioMAGIC 105.3151$20030 $6.675115/5/20195/11/2019#VALUE! #VALUE!
258Slimedica (San Pedro)TVDaytime at 9 (KABB)113$8501(210) 361-5592$8502584/28/20195/4/2019210361-5592210-361-5592
268Slimedica (San Pedro)TVSA Live (KSAT)114$1,7501(210) 361-1480$1,7502684/28/20195/4/2019210361-1480210-361-1480
287Slimedica (San Pedro)TVSA Living (WOAI)111$7501(210) 361-1720$7502874/28/20195/4/2019210361-1720210-361-1720
334Male Medical Group (SO)BillboardBillboard (281/Beside Our Building)155$1,1747(210) 239-2304$167.713344/28/20195/4/2019210239-2304210-239-2304
352Male Medical Group (SO)BillboardBillboard (1604/Braun)156$3187(210) 659-7070$45.433524/28/20195/4/2019210659-7070210-659-7070
370Male Medical Group (SO)BillboardBillboard (35/Eisenhauer)157$4657(210) 263-3116$66.433704/28/20195/4/2019210263-3116210-263-3116
392Male Medical Group (SO)TVDaytime at 9 (KABB)113$8501(210) 908-5231$8503924/28/20195/4/2019210908-5231210-908-5231
414Male Medical Group (SO)TVSA Living (WOAI)111$7501(210) 361-8442$7504144/28/20195/4/2019210361-8442210-361-8442
432Male Medical Group (SO)TVSA Live (KSAT)114$2,5001(210) 361-1203$2,5004324/28/20195/4/2019210361-1203210-361-1203
450Male Medical Group (SO)RadioKISS 99.518$2,86568(210) 361-5581$42.134504/28/20195/4/2019210361-5581210-361-5581
457Male Medical Group (SO)RadioKONO 101.1103$015(210) 361-5581$04574/28/20195/4/2019210361-5581210-361-5581
477Male Medical Group (SO)RadioKTKX 106.7105$1,13059(210) 361-5581$19.154774/28/20195/4/2019210361-5581210-361-5581
507Slimedica (San Pedro)RadioMIX 96.1152$21535 $6.145074/28/20195/4/2019#VALUE! #VALUE!
510Slimedica (San Pedro)RadioMAGIC 105.3151$20041 $4.885104/28/20195/4/2019#VALUE! #VALUE!
257Slimedica (San Pedro)TVDaytime at 9 (KABB)113$8501(210) 361-5592$8502574/21/20194/27/2019210361-5592210-361-5592
286Slimedica (San Pedro)TVSA Living (WOAI)111$7501(210) 361-1720$7502864/21/20194/27/2019210361-1720210-361-1720
333Male Medical Group (SO)BillboardBillboard (281/Beside Our Building)155$1,1747(210) 239-2304$167.713334/21/20194/27/2019210239-2304210-239-2304
351Male Medical Group (SO)BillboardBillboard (1604/Braun)156$3187(210) 659-7070$45.433514/21/20194/27/2019210659-7070210-659-7070
369Male Medical Group (SO)BillboardBillboard (35/Eisenhauer)157$4657(210) 263-3116$66.433694/21/20194/27/2019210263-3116210-263-3116
391Male Medical Group (SO)TVDaytime at 9 (KABB)113$8501(210) 908-5231$8503914/21/20194/27/2019210908-5231210-908-5231
413Male Medical Group (SO)TVSA Living (WOAI)111$7501(210) 361-8442$7504134/21/20194/27/2019210361-8442210-361-8442
426Male Medical Group (SO)TVGreat Day SA (KENS 5)112$1,0001(210) 361-3306$1,0004264/21/20194/27/2019210361-3306210-361-3306
449Male Medical Group (SO)RadioKISS 99.518$2,86548(210) 361-5581$59.694494/21/20194/27/2019210361-5581210-361-5581
456Male Medical Group (SO)RadioKONO 101.1103$013(210) 361-5581$04564/21/20194/27/2019210361-5581210-361-5581
476Male Medical Group (SO)RadioKTKX 106.7105$1,13053(210) 361-5581$21.324764/21/20194/27/2019210361-5581210-361-5581
256Slimedica (San Pedro)TVDaytime at 9 (KABB)113$8501(210) 361-5592$8502564/14/20194/20/2019210361-5592210-361-5592
285Slimedica (San Pedro)TVSA Living (WOAI)111$7501(210) 361-1720$7502854/14/20194/20/2019210361-1720210-361-1720
299Slimedica (San Pedro)TVGreat Day SA (KENS 5)112$1,0001(210) 361-8667$1,0002994/14/20194/20/2019210361-8667210-361-8667
332Male Medical Group (SO)BillboardBillboard (281/Beside Our Building)155$1,1747(210) 239-2304$167.713324/14/20194/20/2019210239-2304210-239-2304
350Male Medical Group (SO)BillboardBillboard (1604/Braun)156$3187(210) 659-7070$45.433504/14/20194/20/2019210659-7070210-659-7070
368Male Medical Group (SO)BillboardBillboard (35/Eisenhauer)157$4657(210) 263-3116$66.433684/14/20194/20/2019210263-3116210-263-3116
390Male Medical Group (SO)TVDaytime at 9 (KABB)113$8501(210) 908-5231$8503904/14/20194/20/2019210908-5231210-908-5231
412Male Medical Group (SO)TVSA Living (WOAI)111$7501(210) 361-8442$7504124/14/20194/20/2019210361-8442210-361-8442
448Male Medical Group (SO)RadioKISS 99.518$2,86548(210) 361-5581$59.694484/14/20194/20/2019210361-5581210-361-5581
455Male Medical Group (SO)RadioKONO 101.1103$015(210) 361-5581$04554/14/20194/20/2019210361-5581210-361-5581
475Male Medical Group (SO)RadioKTKX 106.7105$1,13053(210) 361-5581$21.324754/14/20194/20/2019210361-5581210-361-5581
255Slimedica (San Pedro)TVDaytime at 9 (KABB)113$8501(210) 361-5592$8502554/7/20194/13/2019210361-5592210-361-5592
284Slimedica (San Pedro)TVSA Living (WOAI)111$7501(210) 361-1720$7502844/7/20194/13/2019210361-1720210-361-1720
331Male Medical Group (SO)BillboardBillboard (281/Beside Our Building)155$1,1747(210) 239-2304$167.713314/7/20194/13/2019210239-2304210-239-2304
349Male Medical Group (SO)BillboardBillboard (1604/Braun)156$3187(210) 659-7070$45.433494/7/20194/13/2019210659-7070210-659-7070
367Male Medical Group (SO)BillboardBillboard (35/Eisenhauer)157$4657(210) 263-3116$66.433674/7/20194/13/2019210263-3116210-263-3116
389Male Medical Group (SO)TVDaytime at 9 (KABB)113$8501(210) 908-5231$8503894/7/20194/13/2019210908-5231210-908-5231
411Male Medical Group (SO)TVSA Living (WOAI)111$7501(210) 361-8442$7504114/7/20194/13/2019210361-8442210-361-8442
425Male Medical Group (SO)TVGreat Day SA (KENS 5)112$1,0001(210) 361-3306$1,0004254/7/20194/13/2019210361-3306210-361-3306
447Male Medical Group (SO)RadioKISS 99.518$2,86548(210) 361-5581$59.694474/7/20194/13/2019210361-5581210-361-5581
454Male Medical Group (SO)RadioKONO 101.1103$015(210) 361-5581$04544/7/20194/13/2019210361-5581210-361-5581
474Male Medical Group (SO)RadioKTKX 106.7105$1,13053(210) 361-5581$21.324744/7/20194/13/2019210361-5581210-361-5581
489Male Medical Group (SO)NewspaperSA Express-News6$3,2291(210) 610-9726$3,2294894/7/20194/13/2019210610-9726210-610-9726
506Male Medical Group (SO)Internet Search/WebsiteSA Express-News Web158$9571(210) 951-2205$9575064/7/20194/13/2019210951-2205210-951-2205
525Male Medical Group (SO)Internet Search/WebsiteSA Express-News Web158$9571(210) 951-2205$9575254/7/20194/13/2019210951-2205210-951-2205
254Slimedica (San Pedro)TVDaytime at 9 (KABB)113$8501(210) 361-5592$8502543/31/20194/6/2019210361-5592210-361-5592
283Slimedica (San Pedro)TVSA Living (WOAI)111$7501(210) 361-1720$7502833/31/20194/6/2019210361-1720210-361-1720
298Slimedica (San Pedro)TVGreat Day SA (KENS 5)112$1,0001(210) 361-8667$1,0002983/31/20194/6/2019210361-8667210-361-8667
330Male Medical Group (SO)BillboardBillboard (281/Beside Our Building)155$1,1747(210) 239-2304$167.713303/31/20194/6/2019210239-2304210-239-2304
348Male Medical Group (SO)BillboardBillboard (1604/Braun)156$3187(210) 659-7070$45.433483/31/20194/6/2019210659-7070210-659-7070
366Male Medical Group (SO)BillboardBillboard (35/Eisenhauer)157$4657(210) 263-3116$66.433663/31/20194/6/2019210263-3116210-263-3116
388Male Medical Group (SO)TVDaytime at 9 (KABB)113$8501(210) 908-5231$8503883/31/20194/6/2019210908-5231210-908-5231
410Male Medical Group (SO)TVSA Living (WOAI)111$7501(210) 361-8442$7504103/31/20194/6/2019210361-8442210-361-8442
446Male Medical Group (SO)RadioKISS 99.518$2,86568(210) 361-5581$42.134463/31/20194/6/2019210361-5581210-361-5581
473Male Medical Group (SO)RadioKTKX 106.7105$1,13055(210) 361-5581$20.554733/31/20194/6/2019210361-5581210-361-5581
505Male Medical Group (SO)Internet Search/WebsiteSA Express-News Web158$9571(210) 951-2205$9575053/31/20194/6/2019210951-2205210-951-2205
524Male Medical Group (SO)Internet Search/WebsiteSA Express-News Web158$9571(210) 951-2205$9575243/31/20194/6/2019210951-2205210-951-2205
253Slimedica (San Pedro)TVDaytime at 9 (KABB)113$8501(210) 361-5592$8502533/24/20193/30/2019210361-5592210-361-5592
282Slimedica (San Pedro)TVSA Living (WOAI)111$7501(210) 361-1720$7502823/24/20193/30/2019210361-1720210-361-1720
329Male Medical Group (SO)BillboardBillboard (281/Beside Our Building)155$1,1747(210) 239-2304$167.713293/24/20193/30/2019210239-2304210-239-2304
347Male Medical Group (SO)BillboardBillboard (1604/Braun)156$3187(210) 659-7070$45.433473/24/20193/30/2019210659-7070210-659-7070
365Male Medical Group (SO)BillboardBillboard (35/Eisenhauer)157$4657(210) 263-3116$66.433653/24/20193/30/2019210263-3116210-263-3116
387Male Medical Group (SO)TVDaytime at 9 (KABB)113$8501(210) 908-5231$8503873/24/20193/30/2019210908-5231210-908-5231
409Male Medical Group (SO)TVSA Living (WOAI)111$7501(210) 361-8442$7504093/24/20193/30/2019210361-8442210-361-8442
424Male Medical Group (SO)TVGreat Day SA (KENS 5)112$1,0001(210) 361-3306$1,0004243/24/20193/30/2019210361-3306210-361-3306
488Male Medical Group (SO)NewspaperSA Express-News6$9801(210) 610-9726$9804883/24/20193/30/2019210610-9726210-610-9726
504Male Medical Group (SO)Internet Search/WebsiteSA Express-News Web158$9571(210) 951-2205$9575043/24/20193/30/2019210951-2205210-951-2205
523Male Medical Group (SO)Internet Search/WebsiteSA Express-News Web158$9571(210) 951-2205$9575233/24/20193/30/2019210951-2205210-951-2205
252Slimedica (San Pedro)TVDaytime at 9 (KABB)113$7501(210) 361-5592$7502523/17/20193/23/2019210361-5592210-361-5592
281Slimedica (San Pedro)TVSA Living (WOAI)111$7501(210) 361-1720$7502813/17/20193/23/2019210361-1720210-361-1720
297Slimedica (San Pedro)TVGreat Day SA (KENS 5)112$1,0001(210) 361-8667$1,0002973/17/20193/23/2019210361-8667210-361-8667
328Male Medical Group (SO)BillboardBillboard (281/Beside Our Building)155$1,2707(210) 239-2304$181.433283/17/20193/23/2019210239-2304210-239-2304
346Male Medical Group (SO)BillboardBillboard (1604/Braun)156$3447(210) 659-7070$49.143463/17/20193/23/2019210659-7070210-659-7070
364Male Medical Group (SO)BillboardBillboard (35/Eisenhauer)157$5037(210) 263-3116$71.863643/17/20193/23/2019210263-3116210-263-3116
386Male Medical Group (SO)TVDaytime at 9 (KABB)113$8501(210) 908-5231$8503863/17/20193/23/2019210908-5231210-908-5231
408Male Medical Group (SO)TVSA Living (WOAI)111$7501(210) 361-8442$7504083/17/20193/23/2019210361-8442210-361-8442
445Male Medical Group (SO)RadioKISS 99.518$2,86547(210) 361-5581$60.964453/17/20193/23/2019210361-5581210-361-5581
472Male Medical Group (SO)RadioKTKX 106.7105$1,13053(210) 361-5581$21.324723/17/20193/23/2019210361-5581210-361-5581
503Male Medical Group (SO)Internet Search/WebsiteSA Express-News Web158$1,5541(210) 951-2205$1,5545033/17/20193/23/2019210951-2205210-951-2205
522Male Medical Group (SO)Internet Search/WebsiteSA Express-News Web158$1,5541(210) 951-2205$1,5545223/17/20193/23/2019210951-2205210-951-2205
251Slimedica (San Pedro)TVDaytime at 9 (KABB)113$7501(210) 361-5592$7502513/10/20193/16/2019210361-5592210-361-5592
280Slimedica (San Pedro)TVSA Living (WOAI)111$7501(210) 361-1720$7502803/10/20193/16/2019210361-1720210-361-1720
312Slimedica (San Pedro)TVSA Live (KSAT) Commercial136$4,5009(210) 941-2984$5003123/10/20193/16/2019210941-2984210-941-2984
327Male Medical Group (SO)BillboardBillboard (281/Beside Our Building)155$1,2707(210) 239-2304$181.433273/10/20193/16/2019210239-2304210-239-2304
345Male Medical Group (SO)BillboardBillboard (1604/Braun)156$3447(210) 659-7070$49.143453/10/20193/16/2019210659-7070210-659-7070
363Male Medical Group (SO)BillboardBillboard (35/Eisenhauer)157$5037(210) 263-3116$71.863633/10/20193/16/2019210263-3116210-263-3116
385Male Medical Group (SO)TVDaytime at 9 (KABB)113$8501(210) 908-5231$8503853/10/20193/16/2019210908-5231210-908-5231
407Male Medical Group (SO)TVSA Living (WOAI)111$7501(210) 361-8442$7504073/10/20193/16/2019210361-8442210-361-8442
423Male Medical Group (SO)TVGreat Day SA (KENS 5)112$1,0001(210) 361-3306$1,0004233/10/20193/16/2019210361-3306210-361-3306
444Male Medical Group (SO)RadioKISS 99.518$2,86543(210) 361-5581$66.634443/10/20193/16/2019210361-5581210-361-5581
471Male Medical Group (SO)RadioKTKX 106.7105$1,13054(210) 361-5581$20.934713/10/20193/16/2019210361-5581210-361-5581
487Male Medical Group (SO)NewspaperSA Express-News6$9801(210) 610-9726$9804873/10/20193/16/2019210610-9726210-610-9726
502Male Medical Group (SO)Internet Search/WebsiteSA Express-News Web158$1,5541(210) 951-2205$1,5545023/10/20193/16/2019210951-2205210-951-2205
521Male Medical Group (SO)Internet Search/WebsiteSA Express-News Web158$1,5541(210) 951-2205$1,5545213/10/20193/16/2019210951-2205210-951-2205
384Male Medical Group (SO)TVDaytime at 9 (KABB)113$8501(210) 908-5231$8503843/4/20193/10/2019210908-5231210-908-5231
406Male Medical Group (SO)TVSA Living (WOAI)111$7501(210) 361-8442$7504063/4/20193/10/2019210361-8442210-361-8442
431Male Medical Group (SO)TVSA Live (KSAT)114$2,5001(210) 361-1203$2,5004313/4/20193/10/2019210361-1203210-361-1203
486Male Medical Group (SO)NewspaperSA Express-News6$9801(210) 610-9726$9804863/4/20193/10/2019210610-9726210-610-9726
501Male Medical Group (SO)Internet Search/WebsiteSA Express-News Web158$1,5541(210) 951-2205$1,5545013/4/20193/10/2019210951-2205210-951-2205
520Male Medical Group (SO)Internet Search/WebsiteSA Express-News Web158$1,5541(210) 951-2205$1,5545203/4/20193/10/2019210951-2205210-951-2205
250Slimedica (San Pedro)TVDaytime at 9 (KABB)113$7501(210) 361-5592$7502503/3/20193/9/2019210361-5592210-361-5592
267Slimedica (San Pedro)TVSA Live (KSAT)114$1,7501(210) 361-1480$1,7502673/3/20193/9/2019210361-1480210-361-1480
279Slimedica (San Pedro)TVSA Living (WOAI)111$7501(210) 361-1720$7502793/3/20193/9/2019210361-1720210-361-1720
296Slimedica (San Pedro)TVGreat Day SA (KENS 5)112$1,0001(210) 361-8667$1,0002963/3/20193/9/2019210361-8667210-361-8667
311Slimedica (San Pedro)TVSA Live (KSAT) Commercial136$4,5009(210) 941-2984$5003113/3/20193/9/2019210941-2984210-941-2984
326Male Medical Group (SO)BillboardBillboard (281/Beside Our Building)155$1,2707(210) 239-2304$181.433263/3/20193/9/2019210239-2304210-239-2304
344Male Medical Group (SO)BillboardBillboard (1604/Braun)156$3447(210) 659-7070$49.143443/3/20193/9/2019210659-7070210-659-7070
362Male Medical Group (SO)BillboardBillboard (35/Eisenhauer)157$5037(210) 263-3116$71.863623/3/20193/9/2019210263-3116210-263-3116
443Male Medical Group (SO)RadioKISS 99.518$2,86564(210) 361-5581$44.774433/3/20193/9/2019210361-5581210-361-5581
470Male Medical Group (SO)RadioKTKX 106.7105$1,13061(210) 361-5581$18.524703/3/20193/9/2019210361-5581210-361-5581
249Slimedica (San Pedro)TVDaytime at 9 (KABB)113$7501(210) 361-5592$7502492/24/20193/2/2019210361-5592210-361-5592
278Slimedica (San Pedro)TVSA Living (WOAI)111$7501(210) 361-1720$7502782/24/20193/2/2019210361-1720210-361-1720
325Male Medical Group (SO)BillboardBillboard (281/Beside Our Building)155$1,2707(210) 239-2304$181.433252/24/20193/2/2019210239-2304210-239-2304
343Male Medical Group (SO)BillboardBillboard (1604/Braun)156$3447(210) 659-7070$49.143432/24/20193/2/2019210659-7070210-659-7070
361Male Medical Group (SO)BillboardBillboard (35/Eisenhauer)157$5037(210) 263-3116$71.863612/24/20193/2/2019210263-3116210-263-3116
383Male Medical Group (SO)TVDaytime at 9 (KABB)113$8501(210) 908-5231$8503832/24/20193/2/2019210908-5231210-908-5231
405Male Medical Group (SO)TVSA Living (WOAI)111$7501(210) 361-8442$7504052/24/20193/2/2019210361-8442210-361-8442
422Male Medical Group (SO)TVGreat Day SA (KENS 5)112$1,0001(210) 361-3306$1,0004222/24/20193/2/2019210361-3306210-361-3306
442Male Medical Group (SO)RadioKISS 99.518$2,86548(210) 361-5581$59.694422/24/20193/2/2019210361-5581210-361-5581
469Male Medical Group (SO)RadioKTKX 106.7105$1,13058(210) 361-5581$19.484692/24/20193/2/2019210361-5581210-361-5581
485Male Medical Group (SO)NewspaperSA Express-News6$7841(210) 610-9726$7844852/24/20193/2/2019210610-9726210-610-9726
500Male Medical Group (SO)Internet Search/WebsiteSA Express-News Web158$1,5541(210) 951-2205$1,5545002/24/20193/2/2019210951-2205210-951-2205
519Male Medical Group (SO)Internet Search/WebsiteSA Express-News Web158$1,5541(210) 951-2205$1,5545192/24/20193/2/2019210951-2205210-951-2205
248Slimedica (San Pedro)TVDaytime at 9 (KABB)113$7501(210) 361-5592$7502482/17/20192/23/2019210361-5592210-361-5592
266Slimedica (San Pedro)TVSA Live (KSAT)114$1,7501(210) 361-1480$1,7502662/17/20192/23/2019210361-1480210-361-1480
277Slimedica (San Pedro)TVSA Living (WOAI)111$7501(210) 361-1720$7502772/17/20192/23/2019210361-1720210-361-1720
295Slimedica (San Pedro)TVGreat Day SA (KENS 5)112$1,0001(210) 361-8667$1,0002952/17/20192/23/2019210361-8667210-361-8667
324Male Medical Group (SO)BillboardBillboard (281/Beside Our Building)155$1,2707(210) 239-2304$181.433242/17/20192/23/2019210239-2304210-239-2304
342Male Medical Group (SO)BillboardBillboard (1604/Braun)156$3447(210) 659-7070$49.143422/17/20192/23/2019210659-7070210-659-7070
360Male Medical Group (SO)BillboardBillboard (35/Eisenhauer)157$5037(210) 263-3116$71.863602/17/20192/23/2019210263-3116210-263-3116
382Male Medical Group (SO)TVDaytime at 9 (KABB)113$7501(210) 908-5231$7503822/17/20192/23/2019210908-5231210-908-5231
404Male Medical Group (SO)TVSA Living (WOAI)111$7501(210) 361-8442$7504042/17/20192/23/2019210361-8442210-361-8442
441Male Medical Group (SO)RadioKISS 99.518$2,86548(210) 361-5581$59.694412/17/20192/23/2019210361-5581210-361-5581
468Male Medical Group (SO)RadioKTKX 106.7105$1,13058(210) 361-5581$19.484682/17/20192/23/2019210361-5581210-361-5581
499Male Medical Group (SO)Internet Search/WebsiteSA Express-News Web158$1,5541(210) 951-2205$1,5544992/17/20192/23/2019210951-2205210-951-2205
518Male Medical Group (SO)Internet Search/WebsiteSA Express-News Web158$1,5541(210) 951-2205$1,5545182/17/20192/23/2019210951-2205210-951-2205
247Slimedica (San Pedro)TVDaytime at 9 (KABB)113$7501(210) 361-5592$7502472/10/20192/16/2019210361-5592210-361-5592
276Slimedica (San Pedro)TVSA Living (WOAI)111$7501(210) 361-1720$7502762/10/20192/16/2019210361-1720210-361-1720
323Male Medical Group (SO)BillboardBillboard (281/Beside Our Building)155$1,2707(210) 239-2304$181.433232/10/20192/16/2019210239-2304210-239-2304
341Male Medical Group (SO)BillboardBillboard (1604/Braun)156$3447(210) 659-7070$49.143412/10/20192/16/2019210659-7070210-659-7070
359Male Medical Group (SO)BillboardBillboard (35/Eisenhauer)157$5037(210) 263-3116$71.863592/10/20192/16/2019210263-3116210-263-3116
381Male Medical Group (SO)TVDaytime at 9 (KABB)113$7501(210) 908-5231$7503812/10/20192/16/2019210908-5231210-908-5231
403Male Medical Group (SO)TVSA Living (WOAI)111$7501(210) 361-8442$7504032/10/20192/16/2019210361-8442210-361-8442
421Male Medical Group (SO)TVGreat Day SA (KENS 5)112$1,0001(210) 361-3306$1,0004212/10/20192/16/2019210361-3306210-361-3306
440Male Medical Group (SO)RadioKISS 99.518$2,86548(210) 361-5581$59.694402/10/20192/16/2019210361-5581210-361-5581
467Male Medical Group (SO)RadioKTKX 106.7105$1,13053(210) 361-5581$21.324672/10/20192/16/2019210361-5581210-361-5581
484Male Medical Group (SO)NewspaperSA Express-News6$7841(210) 610-9726$7844842/10/20192/16/2019210610-9726210-610-9726
498Male Medical Group (SO)Internet Search/WebsiteSA Express-News Web158$5971(210) 951-2205$5974982/10/20192/16/2019210951-2205210-951-2205
517Male Medical Group (SO)Internet Search/WebsiteSA Express-News Web158$5971(210) 951-2205$5975172/10/20192/16/2019210951-2205210-951-2205
246Slimedica (San Pedro)TVDaytime at 9 (KABB)113$7501(210) 361-5592$7502462/3/20192/9/2019210361-5592210-361-5592
265Slimedica (San Pedro)TVSA Live (KSAT)114$1,7501(210) 361-1480$1,7502652/3/20192/9/2019210361-1480210-361-1480
275Slimedica (San Pedro)TVSA Living (WOAI)111$7501(210) 361-1720$7502752/3/20192/9/2019210361-1720210-361-1720
294Slimedica (San Pedro)TVGreat Day SA (KENS 5)112$1,0001(210) 361-8667$1,0002942/3/20192/9/2019210361-8667210-361-8667
314Slimedica (San Pedro)TVGreat Day SA (KENS 5) Commercial137$2,4006(210) 941-3481$4003142/3/20192/9/2019210941-3481210-941-3481
319Slimedica (San Pedro)TVSpectrum Commercial154$1,50547(210) 469-5822$32.023192/3/20192/9/2019210469-5822210-469-5822
322Male Medical Group (SO)BillboardBillboard (281/Beside Our Building)155$1,2707(210) 239-2304$181.433222/3/20192/9/2019210239-2304210-239-2304
340Male Medical Group (SO)BillboardBillboard (1604/Braun)156$3447(210) 659-7070$49.143402/3/20192/9/2019210659-7070210-659-7070
358Male Medical Group (SO)BillboardBillboard (35/Eisenhauer)157$5037(210) 263-3116$71.863582/3/20192/9/2019210263-3116210-263-3116
380Male Medical Group (SO)TVDaytime at 9 (KABB)113$7501(210) 908-5231$7503802/3/20192/9/2019210908-5231210-908-5231
402Male Medical Group (SO)TVSA Living (WOAI)111$7501(210) 361-8442$7504022/3/20192/9/2019210361-8442210-361-8442
430Male Medical Group (SO)TVSA Live (KSAT)114$2,5001(210) 361-1203$2,5004302/3/20192/9/2019210361-1203210-361-1203
439Male Medical Group (SO)RadioKISS 99.518$2,86548(210) 361-5581$59.694392/3/20192/9/2019210361-5581210-361-5581
466Male Medical Group (SO)RadioKTKX 106.7105$1,13056(210) 361-5581$20.184662/3/20192/9/2019210361-5581210-361-5581
483Male Medical Group (SO)NewspaperSA Express-News6$7841(210) 610-9726$7844832/3/20192/9/2019210610-9726210-610-9726
497Male Medical Group (SO)Internet Search/WebsiteSA Express-News Web158$5971(210) 951-2205$5974972/3/20192/9/2019210951-2205210-951-2205
516Male Medical Group (SO)Internet Search/WebsiteSA Express-News Web158$5971(210) 951-2205$5975162/3/20192/9/2019210951-2205210-951-2205
245Slimedica (San Pedro)TVDaytime at 9 (KABB)113$7501(210) 361-5592$7502451/27/20192/2/2019210361-5592210-361-5592
274Slimedica (San Pedro)TVSA Living (WOAI)111$7501(210) 361-1720$7502741/27/20192/2/2019210361-1720210-361-1720
304Slimedica (San Pedro)TVSA Living (WOAI) Commercial134$1,1208(210) 941-4062$1403041/27/20192/2/2019210941-4062210-941-4062
307Slimedica (San Pedro)TVDaytime at 9 (KABB) Commercial135$1,2606(210) 981-3280$2103071/27/20192/2/2019210981-3280210-981-3280
313Slimedica (San Pedro)TVGreat Day SA (KENS 5) Commercial137$1,4006(210) 941-3481$233.333131/27/20192/2/2019210941-3481210-941-3481
318Slimedica (San Pedro)TVSpectrum Commercial154$1,50547(210) 469-5822$32.023181/27/20192/2/2019210469-5822210-469-5822
320Slimedica (San Pedro)TVSA Live (KSAT) Commercial136$3,1506(210) 941-2984$5253201/27/20192/2/2019210941-2984210-941-2984
321Male Medical Group (SO)BillboardBillboard (281/Beside Our Building)155$1,2707(210) 239-2304$181.433211/27/20192/2/2019210239-2304210-239-2304
339Male Medical Group (SO)BillboardBillboard (1604/Braun)156$3447(210) 659-7070$49.143391/27/20192/2/2019210659-7070210-659-7070
357Male Medical Group (SO)BillboardBillboard (35/Eisenhauer)157$5037(210) 263-3116$71.863571/27/20192/2/2019210263-3116210-263-3116
379Male Medical Group (SO)TVDaytime at 9 (KABB)113$7501(210) 908-5231$7503791/27/20192/2/2019210908-5231210-908-5231
401Male Medical Group (SO)TVSA Living (WOAI)111$7501(210) 361-8442$7504011/27/20192/2/2019210361-8442210-361-8442
420Male Medical Group (SO)TVGreat Day SA (KENS 5)112$1,0001(210) 361-3306$1,0004201/27/20192/2/2019210361-3306210-361-3306
438Male Medical Group (SO)RadioKISS 99.518$2,86568(210) 361-5581$42.134381/27/20192/2/2019210361-5581210-361-5581
465Male Medical Group (SO)RadioKTKX 106.7105$1,13048(210) 361-5581$23.544651/27/20192/2/2019210361-5581210-361-5581
482Male Medical Group (SO)NewspaperSA Express-News6$9801(210) 610-9726$9804821/27/20192/2/2019210610-9726210-610-9726
496Male Medical Group (SO)Internet Search/WebsiteSA Express-News Web158$5971(210) 951-2205$5974961/27/20192/2/2019210951-2205210-951-2205
515Male Medical Group (SO)Internet Search/WebsiteSA Express-News Web158$5971(210) 951-2205$5975151/27/20192/2/2019210951-2205210-951-2205
244Slimedica (San Pedro)TVDaytime at 9 (KABB)113$7501(210) 361-5592$7502441/20/20191/26/2019210361-5592210-361-5592
264Slimedica (San Pedro)TVSA Live (KSAT)114$1,5001(210) 361-1480$1,5002641/20/20191/26/2019210361-1480210-361-1480
273Slimedica (San Pedro)TVSA Living (WOAI)111$7501(210) 361-1720$7502731/20/20191/26/2019210361-1720210-361-1720
293Slimedica (San Pedro)TVGreat Day SA (KENS 5)112$1,0001(210) 361-8667$1,0002931/20/20191/26/2019210361-8667210-361-8667
303Slimedica (San Pedro)TVSA Living (WOAI) Commercial134$1,1608(210) 941-4062$1453031/20/20191/26/2019210941-4062210-941-4062
306Slimedica (San Pedro)TVDaytime at 9 (KABB) Commercial135$1,6808(210) 981-3280$2103061/20/20191/26/2019210981-3280210-981-3280
310Slimedica (San Pedro)TVSA Live (KSAT) Commercial136$3,8009(210) 941-2984$422.223101/20/20191/26/2019210941-2984210-941-2984
317Slimedica (San Pedro)TVSpectrum Commercial154$1,50547(210) 469-5822$32.023171/20/20191/26/2019210469-5822210-469-5822
378Male Medical Group (SO)TVDaytime at 9 (KABB)113$7501(210) 908-5231$7503781/20/20191/26/2019210908-5231210-908-5231
400Male Medical Group (SO)TVSA Living (WOAI)111$7501(210) 361-8442$7504001/20/20191/26/2019210361-8442210-361-8442
437Male Medical Group (SO)RadioKISS 99.518$2,47569(210) 361-5581$35.874371/20/20191/26/2019210361-5581210-361-5581
464Male Medical Group (SO)RadioKTKX 106.7105$1,15030(210) 361-5581$38.334641/20/20191/26/2019210361-5581210-361-5581
481Male Medical Group (SO)NewspaperSA Express-News6$1,9602(210) 610-9726$9804811/20/20191/26/2019210610-9726210-610-9726
495Male Medical Group (SO)Internet Search/WebsiteSA Express-News Web158$5971(210) 951-2205$5974951/20/20191/26/2019210951-2205210-951-2205
514Male Medical Group (SO)Internet Search/WebsiteSA Express-News Web158$5971(210) 951-2205$5975141/20/20191/26/2019210951-2205210-951-2205
243Slimedica (San Pedro)TVDaytime at 9 (KABB)113$7501(210) 361-5592$7502431/13/20191/19/2019210361-5592210-361-5592
272Slimedica (San Pedro)TVSA Living (WOAI)111$7501(210) 361-1720$7502721/13/20191/19/2019210361-1720210-361-1720
302Slimedica (San Pedro)TVSA Living (WOAI) Commercial134$1,1608(210) 941-4062$1453021/13/20191/19/2019210941-4062210-941-4062
305Slimedica (San Pedro)TVDaytime at 9 (KABB) Commercial135$1,2606(210) 981-3280$2103051/13/20191/19/2019210981-3280210-981-3280
309Slimedica (San Pedro)TVSA Live (KSAT) Commercial136$3,80011(210) 941-2984$345.453091/13/20191/19/2019210941-2984210-941-2984
316Slimedica (San Pedro)TVSpectrum Commercial154$1,56048(210) 469-5822$32.503161/13/20191/19/2019210469-5822210-469-5822
377Male Medical Group (SO)TVDaytime at 9 (KABB)113$7501(210) 908-5231$7503771/13/20191/19/2019210908-5231210-908-5231
399Male Medical Group (SO)TVSA Living (WOAI)111$7501(210) 361-8442$7503991/13/20191/19/2019210361-8442210-361-8442
429Male Medical Group (SO)TVSA Live (KSAT)114$2,5001(210) 361-1203$2,5004291/13/20191/19/2019210361-1203210-361-1203
436Male Medical Group (SO)RadioKISS 99.518$2,57551(210) 361-5581$50.494361/13/20191/19/2019210361-5581210-361-5581
463Male Medical Group (SO)RadioKTKX 106.7105$1,25032(210) 361-5581$39.064631/13/20191/19/2019210361-5581210-361-5581
494Male Medical Group (SO)Internet Search/WebsiteSA Express-News Web158$5971(210) 951-2205$5974941/13/20191/19/2019210951-2205210-951-2205
513Male Medical Group (SO)Internet Search/WebsiteSA Express-News Web158$5971(210) 951-2205$5975131/13/20191/19/2019210951-2205210-951-2205
242Slimedica (San Pedro)TVDaytime at 9 (KABB)113$7501(210) 361-5592$7502421/6/20191/12/2019210361-5592210-361-5592
271Slimedica (San Pedro)TVSA Living (WOAI)111$7501(210) 361-1720$7502711/6/20191/12/2019210361-1720210-361-1720
292Slimedica (San Pedro)TVGreat Day SA (KENS 5)112$1,0001(210) 361-8667$1,0002921/6/20191/12/2019210361-8667210-361-8667
308Slimedica (San Pedro)TVSA Live (KSAT) Commercial136$1,9506(210) 941-2984$3253081/6/20191/12/2019210941-2984210-941-2984
315Slimedica (San Pedro)TVSpectrum Commercial154$1,42545(210) 469-5822$31.673151/6/20191/12/2019210469-5822210-469-5822
376Male Medical Group (SO)TVDaytime at 9 (KABB)113$7501(210) 908-5231$7503761/6/20191/12/2019210908-5231210-908-5231
398Male Medical Group (SO)TVSA Living (WOAI)111$7501(210) 361-8442$7503981/6/20191/12/2019210361-8442210-361-8442
419Male Medical Group (SO)TVGreat Day SA (KENS 5)112$1,0001(210) 361-3306$1,0004191/6/20191/12/2019210361-3306210-361-3306
435Male Medical Group (SO)RadioKISS 99.518$2,67253(210) 361-5581$50.424351/6/20191/12/2019210361-5581210-361-5581
462Male Medical Group (SO)RadioKTKX 106.7105$1,25032(210) 361-5581$39.064621/6/20191/12/2019210361-5581210-361-5581
241Slimedica (San Pedro)TVDaytime at 9 (KABB)113$7501(210) 361-5592$75024112/30/20181/5/2019210361-5592210-361-5592
263Slimedica (San Pedro)TVSA Live (KSAT)114$1,5001(210) 361-1480$1,50026312/30/20181/5/2019210361-1480210-361-1480
270Slimedica (San Pedro)TVSA Living (WOAI)111$7501(210) 361-1720$75027012/30/20181/5/2019210361-1720210-361-1720
434Male Medical Group (SO)RadioKISS 99.518$1,40030(210) 361-5581$46.6743412/30/20181/5/2019210361-5581210-361-5581
461Male Medical Group (SO)RadioKTKX 106.7105$95026(210) 361-5581$36.5446112/30/20181/5/2019210361-5581210-361-5581

<colgroup><col span="7"><col><col span="2"><col><col><col><col><col></colgroup><tbody>
</tbody>
 
Upvote 0

Forum statistics

Threads
1,213,510
Messages
6,114,044
Members
448,543
Latest member
MartinLarkin

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