Help with Index match/countblank

[glockgal42]

So I need to use Index Match and Countblank in order to arrange the number of parking spots I have available by using information from two sheets.

The first sheet (Yard Configurations) is what we use for the arguments:

#Id Type Code Screen Order Audit Order Zone Inbound Outbound NonInventory Sortable Deleted Camera Id Multicapacity Capacity 10065 <colgroup><col width="64"></colgroup><tbody> </tbody> ParkingLocation <colgroup><col width="64"></colgroup><tbody> </tbody> PS84 3Z 1ew No Yes No No No No 1 10066 <colgroup><col width="64"></colgroup><tbody> </tbody> ParkingLocation <colgroup><col width="64"></colgroup><tbody> </tbody> PS85 4A 1ex No Yes No No No No 1 10067 <colgroup><col width="64"></colgroup><tbody> </tbody> ParkingLocation <colgroup><col width="64"></colgroup><tbody> </tbody> PS86 4B 1ey No Yes No No No No 1 10068 <colgroup><col width="64"></colgroup><tbody> </tbody> ParkingLocation <colgroup><col width="64"></colgroup><tbody> </tbody> PS88 4D 1fa No Yes No No No No 1 <tbody> </tbody>

IF (H:H, "Yes") & (B:B, "ParkingLocation") Then INDEXMATCH (B:B in "Yard configurations" with A:A in "Data Dump") Finally Countblank (B:B in "Data Dump") If all is true. ​

The second sheet (Data Dump): Location Type Time In Yard Visit Reason Owner Vehicle Id Load Identity Seal Notes PS84 Skirted Trailer <colgroup><col width="64"></colgroup><tbody> </tbody> 1 hour(s), 28 minute(s) <colgroup><col width="64"></colgroup><tbody> </tbody> OUTBOUND <colgroup><col width="64"></colgroup><tbody> </tbody> UPSS <colgroup><col width="64"></colgroup><tbody> </tbody> 827970 <colgroup><col width="64"></colgroup><tbody> </tbody> PS85 Skirted Trailer <colgroup><col width="64"></colgroup><tbody> </tbody> 4 hour(s), 1 minute(s) <colgroup><col width="64"></colgroup><tbody> </tbody> OUTBOUND <colgroup><col width="64"></colgroup><tbody> </tbody> UPSS <colgroup><col width="64"></colgroup><tbody> </tbody> 841850 <colgroup><col width="64"></colgroup><tbody> </tbody> PS86 Skirted Trailer <colgroup><col width="64"></colgroup><tbody> </tbody> 7 hour(s), 19 minute(s) <colgroup><col width="64"></colgroup><tbody> </tbody> OUTBOUND <colgroup><col width="64"></colgroup><tbody> </tbody> SNCY <colgroup><col width="64"></colgroup><tbody> </tbody> 157524 <colgroup><col width="64"></colgroup><tbody> </tbody> PS88 <colgroup><col width="64"></colgroup><tbody> </tbody> <colgroup><col width="64"></colgroup><tbody> </tbody> <colgroup><col width="64"></colgroup><tbody> </tbody> <colgroup><col width="64"></colgroup><tbody> </tbody> <colgroup><col width="64"></colgroup><tbody> </tbody> <tbody> </tbody>

<colgroup><col style="width:48pt" span="14" width="64"> </colgroup><tbody>
</tbody>

 

[JackDanIce]

It's not very clear what the outcome should be. Can you use an actual example showing exactly what is being matched where and what the expected outcome needs to be and where this should be shown?

As far as I can tell, you're asking:

For each row in Yard Configurations:
If Outbound in Yard Configurations = "Yes" AND Type in Yard Configurations = "ParkingLocation" Then
Take the #Id number from the same row in Yard Configurations
Find this #Id number in Data Dump

Where it's not clear is what blanks do you want counted; I think you want to filter Data Dump for the #Id number and count the filtered number of blank cells in column B of Data Dump?

Can you provide more clarity please?

 

[glockgal42]

Taking the ID# in data dump and counting any blank cells in the column to the right of the ID#'s. The ID #'s are different parking spots we have. The column to the right of the ID #'s is telling you if there is a trailer in that parking spot or not. I need to count all the ID #'s that do not have a trailer in them.