Countifs In Array Not Working As Expected, then Update question

Good Morning or Afternoon,

First, I've enjoyed looking through all the posts here, it has been very informative!

My question is related to the Array expression (copied on all fields) on the HR tab of this workbook. I have used this expression in several worksheets to pull the appropriate records and it doesn't seem to be working correctly.

It is supposed to pull any records that are "" in the HR column from the Data worksheet. I tried modifying the expression to count zeros, no joy. I tried using "<0", no joy. I'm still retrieving columns that have "HR" in the "HR" column. When the actual "HR" person reviews this and makes changes, they don't want results that have been previously reviewed.

So, having said that, I think this may be a mute point. The spreadsheet is designed for the employee supervisor to enter the absences in the "EnterTime" worksheet. It should update to another table. HR reviews that table and then data will update to the final table once modifications are made. Perhaps I should create the VBA to update records to the HR sheet for review, and then copy finished records to the Data worksheet?

Forgive me, I'm new at this and have never worked on an application or VBA.

Thanks so much for input!

Jan

Hello, XOR LX - Thanks for the quick reply.

1 - The countifs assist with relative cell references in order to pull the next matching record from the source data (Data tab). A simple if statement does not assist with mathematical calculations by counting the number of rows that meet a specific criteria.
2 - The small function returns the first row number, I believe, but the matching isn't working as expected anyway, I'm still getting records with "HR" in them and this is why the function isn't performing as expected.
3 - Upper in the calculation is used for all columns due to text that I want returned in uppercase. I can remove the ones I don't need later - good catch though!
4 - Row and column is not for row insertion, it is for retrieving matched data based on relative cell references based on the number of records counted in the countifs... which isn't working as expected.

To see the formula working correctly, and as expected, view the Overview, SupShifts, Location and DynDrop tabs. It worked on four other tabs... just not this one with blanks or "" values.

I'll test your example and see what happens though!

Thanks!

Jan

XOR LX, Thanks - that seemed to work. Now I want to sort out why and I'll try modifying the calculations in the other worksheets and see how that does as well.

I think the countifs were for multiple criteria, but I'll have to look into that futher. Some worksheets require multiple criteria...