Forum

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....

Hello, A simple solution is to create one extra column in both tables, then you can use VLOOKUP. Note: I hade both files opened when working wit...

Hello, Sorry, there is no file attached.

Hello, It would help a lot if you can provide some sample file or two. No need for real data, what is important here is to see the structure and wh...

Hello, Not sure if the example in the attached file is good enough, but it is at least simple and do show what you want to see. Br, Anders

Hello, Check these pages.

Hello, The formula Sunny provided is an array formula. Just press the control and shift keyes and then press enter. /Anders

Philip Treacy said Your data validation formula could be =EXACT(B2,VLOOKUP(B2,E2:E6,1)) with the cell you are typing into being B2 and the permitte...

Hi, You can get that using Pivot Table. See attached. Br, Anders