Short Tips#0034: Useful tips for Find and Replace By Puspendu Roy Karmakar Posted on August 15, 2018 Posted in Excel short tips No Comments 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 No Comments 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 No Comments Tagged with LARGE
Short Tips#0031: COUNTIF application on date By Puspendu Roy Karmakar Posted on August 8, 2018 Posted in Excel short tips No Comments 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 No Comments 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 No Comments 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 No Comments 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 No Comments 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 No Comments 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 No Comments Tagged with FILTER