Forum

Hello Justin, Have you checked out this blog article about date formatting?

Hello Mel, Great that you got it working.

Hello Melissa, If you are able to provide a sample file it would be a lot easier for me and others to give some help. Based on the formula you h...

Hello, There is a good explanation here on how this formula works.

Hello Humayun, Please share a sample file showing your data structure. Have you checked this info?

Hello, Not sure what you have tried with, if you can upload a sample file with some data it will be easier to give a correct and relevant answer. I...

Hi Paul, Thanks for the update!

Hello neighbour, Have you tried with replacing the 0 values in your data with NA()? The graph will ignore cells with the #N/A error. If you nee...

Hello, Found this thread, it does not give much info, but at least some.

Hello, If you can attach a sample file showing what you try to do and so fort it will be a lot easier to check and give you a relevant answer.

Hello, The reason to why you get these #VALUE! errors is because the month abbreviations in columns C and D are English, but you have a different l...

Hello, Change the lookup section in your formula to VLOOKUP($G2,List_tbl!$G2:List_tbl!$J21028,4,FALSE). You need also to replace the J2 referenc...

Hello, As you probably already know, by having lookups without using exact match you will end up with incorrect results, sooner or later. In order ...

Hello Alan, You are getting this #VALUE! error because you are trying to add a number value (cell AF16) to a text value (cell AF21, as the result o...

Hello, You need to use some VBA code to achieve this. I found this tip, hope it helps.