Last seen: Mar 8, 2026
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.
Hello, It is always easier if we can see the data, a small sample file is good enough.
Hello, With this approach you need a VBA solution. Coloured cells is nothing you can check for and use as values/conditions in formulas. You find m...
Hello, More info here about the TODAY function. Change your formula to =IF(M2-TODAY()<0,””,M2-TODAY()&” days”) and it will work. You can ...
Hello, That is a lot of conditional formatting rules you have in your workbook. It seems to me that you know how to set up such rule you want help ...
Hello, I also found this blog article that covers this topic.
Hello, Sorry, but no file is attached. Seems to me that you want to do something like this.
Hello, The INDEX function has following syntax: INDEX(array, row_num, [column_num]) Your formula is wrong as you are trying to find the column_n...