Forum

Hi Frans, Custom Number Formats are only available in the current file. So if you want to use them in a different file then you need to set them up...

Hi Rath, Rather than over complicate the formula I'd just create a single column. Convert Credits to negative values so you can keep track of which...

Hi Amy, Please upload a sample file (with some dummy data if you prefer), this will help us to see how your data is structured and give you an alte...

Hi Craig, There is no built in way to edit comment formatting to all or even some comments in one operation. If the comments are all the same then ...

Hi Rath, What do you mean by 'elaborate'? Is the formula not working? You can learn more about the AGGREGATE function here and the WEEKDAY Funct...

Hi Valerie, A conversion is when someone moves from one stage in a sales funnel to the next. For example, a lead may convert into a seminar attende...

Hi Teri, You can back out but when you remove the navigation step created when you clicked on the Employee record you go back to the list of tables...

You can learn about the Excel Camera tool here.

I don't know, Valerie. What 'Dashboard' and in what context is 'Conversion Pivot' mentioned? Mynda

Hi Bob, A #DIV/0! error occurs when the denominator is zero. You can't divide by zero so Excel returns #DIV/0! This error suggests that the lead...

Hi Teri, When you click on a cell make sure you don't click on the text in the cell, instead click on the white space to the right of the text. Thi...

Hi Paul, There is no NETWORKDAYS function in Power Query or Power Pivot, as you already know. In Power Query you have to write a custom function...

Hi Valerie, I'm not sure I fully understand your question. You can control multiple PivotTables in two ways: 1. using the technique shown in ...

Hi Divisha, Glad you figured out a solution. I think you answered your own question about what you could do to make this easier: "What I could have...

Hi Divisha, It depends what you mean by compare? That said, the numbers in that table are text so Excel can't do any math calculations on it. Yo...