In my starting days with Excel, I was really bad at consolidating data. If you asked me to capture sales data for four different zones, I would create four different worksheets
It’s hard to recognize blank cells in a large data, because a blank cell is just a white cell without any value. In most of the cases, blank cells represent some
The best way to highlight top bottom values is by using conditional formatting. It’s quick, simple and all you need a few clicks. But, the best part is, you don’t
It happens sometimes… …when we need to lookup for a value from a table… …according to the row heading and… …column heading.It happens sometimes when we need to lookup for a value from
Everyone know that we can find and replace a text with find and replace option. But very few people know that you can use this option to an advance level.
In Excel, we can’t simply use default MAX function with a condition……(unless you are using Microsoft Office 365).But the thing is…If want to get maximum value from a range using