Short Tips#0034: Useful tips for Find and Replace By Puspendu Roy Karmakar Posted on August 15, 2018 Posted in Excel short tips Tagged with FIND&REPLACE
Short Tips#0033: Get Kth smallest value with SMALL function By Puspendu Roy Karmakar Posted on August 8, 2018 Posted in Excel short tips Tagged with SMALL
Short Tips#0032: Get Kth largest value with LARGE function By Puspendu Roy Karmakar Posted on August 8, 2018 Posted in Excel short tips Tagged with LARGE
Short Tips#0031: COUNTIF application on date By Puspendu Roy Karmakar Posted on August 8, 2018 Posted in Excel short tips Tagged with COUNTIF, COUNTIFS
Short Tips#0030: COUNTIF application on numbers By Puspendu Roy Karmakar Posted on August 8, 2018 Posted in Excel short tips Tagged with COUNTIF, COUNTIFS
Short Tips#0029: Generate random text value from fixed set of options By Puspendu Roy Karmakar Posted on August 5, 2018 Posted in Excel short tips Tagged with CHOOSE, RANDBETWEEN, ROUND
Short Tips#0028: Generate random numbers from fixed set of options By Puspendu Roy Karmakar Posted on August 5, 2018 Posted in Excel short tips Tagged with CHOOSE, RANDBETWEEN, ROUND
Short Tips#0027: How to count cells containing any part of text By Puspendu Roy Karmakar Posted on August 4, 2018 Posted in Excel short tips Tagged with COUNTIF
Short Tips#0026: How to count cells having value between two dates? By Puspendu Roy Karmakar Posted on August 4, 2018 Posted in Excel short tips Tagged with COUNTIF
Short Tips#0025: How to paste a column reverse? By Puspendu Roy Karmakar Posted on August 2, 2018 Posted in Excel short tips Tagged with FILTER
