Written by Puneet Gogia in Advanced Excel In my starting days with Excel, I was really bad at consolidating data.If [...]
About PuneetThis author has not yet filled in any details.
So far Puneet has created 140 blog entries.
It’s hard to recognize blank cells in a large data. Because a blank cell is just a white [...]
The best way to highlight top bottom values is by using conditional formatting. It's quick, simple and all you [...]
Everyone know that we can find and replace a text with find and replace option. But very [...]
In Excel, we can't simply use default MAX function with a condition……(unless you are using Microsoft Office 365).But [...]