In Column “C”, I have product list and some of them are duplicates. My requirement is to format with background color of green for 1st found value among the duplicates. To solve this, I used...
When you copy a cell's contents, formula or format, that information goes into the clipboard. The clipboard will hold the information until you decide to paste it somewhere else on the spreadsheet,...
Sometimes you may want to analyse and view trends in your data without creating an entire chart. Sparklines are miniature charts that fit into a single cell. A Sparkline is a tiny chart in a worksheet...
Avoid VLookup function in excel, instead use index and match combination. Reason: 1) Index and Match combination will be faster than Vlookup function. In order to proof this you can create 1000 rows...