Written by There are multiple way to sum unique values in a dataset using Excel. The situation comes up with you have a list of data that is duplicate or repeating and you don’t want to count the duplicate values, or in other words count duplicate only once, otherwise you get to a chaotic solution as Relativity […]
What an annoyance! I personally, have never found any use in Excel’s Research Pane, other that it being really annoying and becoming such a distraction if it pops up unexpectedly, just like that dude Jar-Jar-Binks in Star Wars! If you find yourself wanting to disable it, follow these steps: Method 1 (the only one I […]
Want to give some magic to your Excel modeling? Then its time to call Galdalf and seriously learn about Excel Cube functions! One of my favorite Excel functions to do business modeling are Cube functions. They act as a more efficient replacement for SUMIFS, GETPIVOTDATA functions that serve to sum aggregated results with various filters […]
What to do if your PowerBI Excel cube is not refreshing new dimensions? Dont let your Excel spoil your refreshing drinks. Read on to find the answer.
If you want to measure a distance between any two points, there is an Excel formula that does just that. For that you solely need the coordinates of locations (Latitude, Longitude) and a blank Excel worksheet.
Get a comprehensive comparison between CUBEVALUE, GETPIVOTDATA and SUMIFS functions broken down into 12 categories and get recommendation when to use which formula.