Negative Positive icons using Conditional Formatting

Click here Subject Line RAG indicators make reports colourful and impressive Overview Sometimes you may want to rate status reports based on different indicators just like the traffic lights using red, amber (yellow) and green to signify different scale ratings. There is always a need to make reports appealing based on the format and presentation.

Continue Reading

2 way lookup using INDEX(),MATCH(),MATCH() function.

Click here Subject Line 2 way lookup is amazing Overview Sometimes you may want to lookup a value in a table using both rows and columns. You can build your own formula that to perform a two-way lookup with help of INDEX and MATCH function. Syntax =INDEX(data,MATCH(val,rows,0),MATCH(val,columns,0)) Let’s understand both the function INDEX function returns a

Continue Reading