Forum

Hi Chen, You can use this calculated column in Opportunity table: Filter Quota = IF(AND(OR(RELATED(Compensate[Business Group Area])="GSMB - Sale...

Your materials sheet structure is not appropriate for automation. It might look better, but it's built for visual purposes, not functional. You wil...

Hi Vicky, You have to identify the step that slows down your query and use Table.Buffer in the previous step. As an example, if the #"Merged Que...

Nothing appears at a double click, is that a fact or a wish? If you are trying to build a userform, you can find a tutorial here:

If you are trying to write the cell formula from VBA, you have to duplicate the double quotes within the formula string: .Range("K8").Formula= "=Co...

Hi Stephen, Here is a sample UI with a new tab containing a new tab, with various number of groups and buttons: One of the tabs looks l...

Hi Khine, Just select your range, press Ctrl+T (or from ribbon: Insert>Table), add a new column with origin and destination combined, then all y...

Hi Raul, Is the question related to excel or you need this on a website? We can help with excel... For a website, you have to find a developer t...

Try not to use the existing Oracle connector, use the OleDB connector instead, as suggested in your other topic.

Direct Query might help. Also, see this article:

Hi Johan, If you want to keep some records based on component description, we can build a workaround. For example, you can add an Index column a...

Hi Howard, I still don't see a way to do it unfortunately. More, in the latest file you sent, the problem is even more complex than before: ther...

Hi Moriel, Noticed that you have in column F the newest month, so I guess you always insert a new column in column F, right? You can use the cod...

Hi Brent, Don't know how to answer this question. What are your expected results?

Ok, without that AE1 text the text is trimmed to 255. A good way to fix this is to write a simple macro that converts .xls to .xlsx file type, .xls...