Return non blank "numerical" cells from a range - Excel 2016

[Cred69]

I am tracking my time per a job#. I want to create a chart of the data. The time and the projects can vary and there are days that I don't work on the project, so there are several spaces between the project# and the Hours\Minutes worked.

I searched and I found a solution that works for my project number. According to the site I found this solution on, its supposed to work for numerical as well, but not in excel 2016.

Formula is from Excel 2007:

=IFERROR(INDEX(G:G,SMALL(INDEX(NOT(ISBLANK($G$3:$G$375))*ROW($G$3:$G$375),0),COUNTBLANK($G$3:$G$375)+ROW(A1))),"")

Value returned: "P0011" and it skips all the blank rows and places the next value directly below the previous project#. Which is what I am in need of. However when I try the same formula on the time, it does give me the value, but it also shows all the blank cells as well. Its not skipping them, what am I doing wrong?

Thanks,
Scott

 

[pgc01]

Hi Scott

You should post a small sample of the data so that we can test.

Anyway, just looking at the formula I see you are using IsBlank() which tests for empty cells. Maybe your cells are not empty?
What do you have in those cells?

 

[Cred69]

My apologies for my late reply.

Best way to show you is with this link to the spreadsheet:
https://drive.google.com/file/d/17G_-LA-0JVRpTrOf2182rITSzbNBGxUB/view?usp=sharing

I should point out the cells in column U I have removed the 0:00 cells to condense them down like I need them to appear. Column X is what actually happens when I copy the cell down. The same formula is in Column T and W and it works without issue.

Thanks,
Scott

 

[Cred69]

pgc01,

Have you had a chance to look at the link above? if it doesn't work, please let me know.

thanks,
Scott