About:
- Website
- http://
- Details
Posts by :
-
July 21, 2010 Which Group does a name belong to?
-
July 24, 2009 Lookup for “contains”
-
July 16, 2009 Cell value from a grid
-
July 10, 2009 The trick of ––
-
July 10, 2009 Extracting the nth occurence from an array
-
July 6, 2009 Sum – Year to Date
-
June 15, 2009 First, Last, Min, Max for a particular value in an array
-
June 10, 2009 DPD analysis using two condition sum
-
June 9, 2009 Lookup_value as array
-
June 8, 2009 Text to Numbers
Author
You may contact me at agarwalanup(at)gmail(dot)comSearch blog
-
Recent posts
-
Blog Stats
- 15,059 hits
Share with others!
What have I used most
address array array formula array function column() columns concatenate Conditional formatting countif date day exact Find frequency Go To... If index indirect int IPMT isblank iserror isnumber Left Len lookup match max mid mod month offset PMT PPMT Right row rows search Substitute sum sumproduct Text to Columns.. Trim vlookup yearGet down to work!
May 2012 M T W T F S S « Jul 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31