As the war wages on between #TEAMVLOOKUP and #TEAMINDEXMATCH, a new challenger has arisen. #SUMPRODUCT, a function often associated with math and trig, has now taken on a new purpose – Boolean logic. But can it compete? Or, will it continue to lurk in the shadows, only to be utilized by Power Users… Download Workbook […]Read more "I Always Feel Like SUMPRODUCT()’s Watching Me"
piv·ot·al ˈpivədl/ Of crucial importance in relation to the development or success of something else. Synonyms: central, crucial, vital, critical, focal, essential, key, decisive There is no such thing as “the right time” when it comes to developing your talents in Excel. You are always on call as the swiss-army-knife of information. Today a financial analyst, tomorrow […]Read more "That Pivotal Moment"