Okay we have a couple of issues. I am using a formula that looks at the value in B4 and tries to match it with your locations in column E of your Data sheet. I was getting errors and couldn't figure out why. I finally discovered that your bin locations in column E of your Data sheet have multiple hidden spaces in them. I had to remove these manually, I don't know if they are a by product of you importing your data from somewhere else, but you need to be aware of it. Excel sees a number with no spaces and what appears to be the same number with spaces after the number as being different. If this list is going to be updated often you might want to consider a macro that fixes the issue. What I did was entered a column to the right of E and used a trim formula. So in the blank column F I entered in cell F4 the formula =Trim(E4) and copied it down, which brings the value of E values into F without the spaces, but it's a formula that looks at E, so I have to copy all the F cells and then "paste special values" back onto themselves. I then deleted the original column E and the column F becomes column E and all the bins are now free of spaces.

The second issue is your sheet goes to row 29 and that's not going to be enough for some of your locations, you need to add some rows.

Note the formula in Cell B29 is the formula I want you to use at the bottom of your data to count, this is very important because this formula is reference in the formula in cell B5 in my example. So add your extra rows to fit your data and enter the formula shown in B29 of my example in the last row and make sure you change the references in the formula in cell B5 to whatever that last row is, taking care to preserve the dollar sign.

The reason I entered the formula in B5 the way I did is for timing purposes. You have a lot of data and this will keep the calculation time down.

The formulas are both array formulas and you must use Control Shift Enter to confirm the formulas, but once you have done this you can just copy the formulas to all the other cells.

**WarehouseControl1**
* | B | C |

4 | 7A08 | 7A12 |

5 | 6450 | 6545 |

6 | 6450 | 6545 |

7 | 6450 | 6545 |

8 | 6807 | 6545 |

9 | 6807 | 6545 |

10 | * | 6545 |

11 | * | 6545 |

12 | * | 6545 |

13 | * | 6545 |

14 | * | 6545 |

15 | * | 6545 |

16 | * | 6545 |

17 | * | 6951 |

18 | * | 6951 |

19 | * | 6951 |

20 | * | 6951 |

21 | * | 6951 |

22 | * | 6951 |

23 | * | 6951 |

24 | * | 6951 |

25 | * | 6951 |

26 | * | 6951 |

27 | * | * |

28 | * | * |

29 | 5 | 22 |

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:58px;"><col style="width:64px;"></colgroup><tbody>

</tbody>

**Spreadsheet Formulas** |

Cell | Formula | B5 | {=IF(ROWS(B$5:B5)>B$29,"",INDEX(Data!$A$1:$A$7710,SMALL(IF(Data!$E$1:$E$7710=WarehouseControl1!B$4,ROW($E$1:$E$7710)),ROWS(B$5:B5))))} | B29 | =COUNTIF(Data!$E$2:$E$7710,WarehouseControl1!B$4) |
<tbody>
</tbody> |

**Formula Array:**
Produce enclosing **{ }** by entering
formula with CTRL+SHIFT+ENTER! |

<tbody>

</tbody>

**Excel tables to the web >> ** Excel Jeanie HTML 4