I have found that a formula I have been using is not searching the first entry using the Last Row formula and I can't figure out why this is happening. I also found that the formula is counting more rows than are actually being used. The last row is actually row 10 and it is showing row 37.
The formula is to count the number of different labels in column K and put them into the appropriate column in the persons ID row. The formula works but it will not count anything in the first row to be counted Row 5. In the example there are 6 entries and the last row is showing the last row as 37 when it is 10 so I seem to have two problems (Last Row Count wrong) and (not searching the first row in range row 5). I didn't write the search code and can't figure out where the problem is. I have put remarks in as to what I think the code is doing but I am not sure if I am right.
I have attached a sample workbook with the code. To run the search select the EOD #1 button. The results will appear in columns AO5, AP5 and AO6, AP6. The total of the entries should be 6 entries but it will only show 5.
Here is my search code:
Any and all help is greatly appreciated!
Bookmarks