Wednesday, May 11, 2016

Excel VBA Macro Delete all images / drawing objects from sheet in one go

›
Excel VBA Macro code to Delete all images / drawing objects from sheet in one go: Sub DelObjects() Dim sh As Worksheet For Each sh...
Sunday, May 1, 2016

Excel formula to find overlapping dates in columns

›
Query: I have a range of dates, start date and end date in a single row in below format. I want to check for overlap for in each...
Monday, April 25, 2016

Excel formula : Find Bottom 5 values excluding zero

›
Query: I have list of numbers from that i want to extract smallest 5 numbers excluding zero. Solution: we can use combination of Smal...
1 comment:
Wednesday, April 20, 2016

Excel VBA macro highlight break in attendance / gap in dates

›
Query: I have downloaded attendance data/log from application employee wise, I want to highlight break days. e.g. if an employee has worke...
Sunday, April 17, 2016

Excel Unique & Difficult formula : Find date when target is achieved (Running total / Cumulative sum for item exceeding target)

›
Query: I want a formula for searching date when a total target for particular agent exceeds between select dates. Basically, I have data ...
Wednesday, April 13, 2016

Excel Pivot table - Conditional formatting pivot table & maintaining format after filtering and un filtering data

›
Query: I have a pivot table and I want to have the format apply to any cell in the data area, regardless of the configuration of the colum...
Tuesday, April 12, 2016

Excel VBA Macro to compare employee data head wise between multiple sheet and give out to separate sheet

›
Query: Hi I have employee master data in two or sometimes three or more sheets, I want to match data in all sheets and get the comparison...