User Profile
OkenAnalytics
Brass Contributor
Joined 6 years ago
User Widgets
Recent Discussions
Re: Conditional Formatting Ranges Increasing on Data Refresh
Would you like to check the paste action, perhaps the system interprets it as an insert column action? I am no VBA expert but the only explanation for this 'anomaly' is that the paste as values action inserts a column first, which would inevitably expand the conditional formatting range. Can you share the code in part or whole?SUMMARIZE function
I think it would be a great idea to leverage on the spill property of excel functions to create a new function that creates table instead of an array of single data type. I think this should be introduced to Excel just as we have for DAX. That would be a great addition to Excel, although it might reduce the use of Pivot tables significantly.Re: Cross multiplication with variable input across cells
ameenac This is what I propose: You will retain your initial 'gold standard' composition. The orange cells are your input cells and the grey cells are you output. In this case it uses proportions of the totals from the input and original composition to estimate the output. Let me know if this works for you.Re: How to add an asterisk in front of a, b, c, d?
kevingmc I used the find and replace showed below and it worked for some and not others as you mentioned. The reason is that some of the options are autoformatted as lists while some lists were created by you. The manually created lists will work while the auto-completed lists will not work. You will notice below that Question 2's options are autoformatted while that of Question 3. is not. Try to create the answer lists manually. Unfortunately, that's almost like manually adding the asterisks throughout the document.
