Forum

Hello Stephen, Great that you have it all working. I am just glad that I could give a helping hand.

Hello, The Office suite is in its core American English, same with Windows 10. The different languages are just added/installed language packs. So ...

Hello Anne, For getting latest features you need to be on the monthly update channel. More about the differences here.

Hello Stephen, Nothing wrong with the formulas, but the data needs to be cleaned. I just trimmed the ENTRYYEAR and STUDENTTYPE data and after th...

Hello Paul, When you have two or more criterias you have to use AVERAGEIFS function. The syntax is =AVERAGEIFS(average_range, criteria_range1, c...

Hello Jay, I an not sure that I have grasped fully what it is you want to do, for example, what is to be matched? Any way, from what I understan...

Hello, You have to add ”<>0” as a criteria.

Hello, i have tested the same, created two new rows in Data sheet, rows 38480 and 38481, entered data in columns N, O, P, AA and for the second new...

Hello Nando, If you can provide a sample file also I am pretty sure you will get help from this forum.

Hello, My first check didn't include the coloured columns in Weekly sheet, only the control in range J92:AI98. I have now modified your formulas...

Hello, I have done some tests and noticed that in ENTRYYEAR column there were lots of trailing spaces in the data, so I did a clean. I also changed...

Hello, I am sorry, I don't understand what you are trying to get from that data. Anyway, DGET function is just a lookup function for one or seve...

Hello Gabriel, There is no file. It would be good if you can upload a sample file showing how you want the results to be presented.

Hello, If it is just a simple check like you describe then it is easiest to use DGET function. See attached file for an example.

Hello, I did a search on the Internet and found some informative pages, this one gives in my view a good explanation of how to setup the formula.