Hi for certain reason one of my indirect drop down list is not showing any result, the rest of the data are showing something. The range has been identified and there are certain data inside the range.

I am trying to combine 2 large sets of data produced from 2 pivot tables using a vLookup so the data/graph changes as I use a slicer to filter each table. (The Data sets are not able to be combined) The trouble is in one set of data the time is formatted as HH:MM:SS AM/PM but uses only the Hour not minutes PLUS the AM or PM (which I want as I am grouping data by the hour of the day for the chart, and the other data HH:MM:SS PLUS the AM or PM but uses the exact time i.e.:

I’m lost and not finding the correct formula.

I have a formula that finds the index of the first non-empty cell in a specified range:
=MATCH(TRUE,INDEX(OFFSET(H1,0,0,10,1)="",0,0),0)

I’m concatenating two strings and I want one of them to be bold.

I am hoping for help for a new challenge in my veterinary research project. I would like a way to cross check values in different columns in my Excel spreadsheet. I want to make sure that for every case (bird) that has been assigned a category that it has at least one diagnosis (subcategory) for that category; and that no diagnoses were incorrectly assigned to a bird that didn’t have that category assigned. I have 6500 cases (birds), 27 categories, and over 200 diagnoses (subcategories) and so I am hoping for a formula to help save me time and improve accuracy.

I am hoping for help for a new challenge in my veterinary research project. I would like a way to cross check values in different columns in my Excel spreadsheet. I want to make sure that for every case (bird) that has been assigned a category that it has at least one diagnosis (subcategory) for that category; and that no diagnoses were incorrectly assigned to a bird that didn’t have that category assigned. I have 6500 cases (birds), 27 categories, and over 200 diagnoses (subcategories) and so I am hoping for a formula to help save me time and improve accuracy.

I have two tables:
The first is a table of roles where each person is in a team but person c has changed teams in June:

I have the following data set:

I have the following table where we have the same ID and date. However, I want to create an array that changes the ID based on the ID and the date.