About: Anup Agarwal
- Website
- http://
- Details
Posts by Anup Agarwal:
-
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
Anup Agarwal is adept at financial modeling on excel and often doubles up as an excel trainer and troubleshooter for his friends and colleagues. You may contact him at agarwalanup(at)gmail(dot)comSearch blog
-
Recent posts
Blog Stats
- 47,237 hits
Share with others!
What have I used most
-- -- address Advanced Filter array array formula array function choose code column() columns concatenate Conditional formatting count countif date day error.type exact Find Formatting frequency Go To... If index indirect int IPMT isblank iserror isnumber istext large Left Len lookup lower match max mid min mod month offset PMT PPMT Printing proper rand() Right rounddown row rows search sign Substitute sum sumproduct sumx2py2 Text to Columns.. today() Toggle Grid Trim value vlookup weekday yearWhoa! Love this
May 2024 M T W T F S S 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 Tweet
Tweets by Anup1009-
Join 3 other subscribers