Forum

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.

Hello, Ok, it was just a thought. My experience is that mixing number values and text values in same cells as allowed data just gives problems. Bes...

Hello, Some years ago I used the camera tool a lot and had similar experiences from time to time. Initially when this tool was new in Excel 2010 th...

Hello, I am not sure if this is what you want, but I have rearranged your data so we have one fact table and one dimension table. I am using Power ...

Hello, A simple solution is to use a formula with nested IF's. Check out the attached file and see if it is what you want.

Hello, Please upload a sample file, it makes it a lot easier for any of us to check and try to help.

Hello Karen, Thank you for the feedback, I am just glad I was able to help.

Hi, Just a thought, but instead of using letters P and F, can you instead use 0 and -1 instead? Then you can use same approach as you already have....