1. O

    Dynamically add rows and columns and keep manual data

    Hi all, As recommended in another post, I converted my macros into a table-based Excel which includes queries. I am now facing a issue that I hope somebody can help with. I am trying to create a table that has both columns and rows dynamically updated. I managed to do this, but the content of...
  2. D

    DAX Direct Query

    Hello, I have a question regarding some DAX functions, What exactly does This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules. mean? I presume the function has to be nested...
  3. R

    Copy paste multiple columns based on the account name

    Hi team, Can you please help me find a solution to the below issue? I tried Vlookup, but it is really time-consuming. I have two sheets. One with the contact details and one with the product details. I want them to map it based on the account data. Sheet 1: Sheet 2 Result required ...
  4. A

    Query Editor Support in Power Bi and Tableau

    Hello All, I am working on a project and I want to know which one supports a query editor between Power Bi and Tableau? According to a source, Tableau does not support this feature may be and I have no idea about power bi? Can anyone explain to me who supports query editor?
  5. L

    Get external data from a website that requires a login.

    Long story short, I managed to push data from "public" websites. Quite straight forward process Data > Get External Data > Run Web Query and I get the data I want. My problem is how to do this if the data I need to access is personalized for a single user. I do have access to login details and...
  6. J

    Table.Buffer - Queries won't Refresh on other computers

    Howdy! Since I see update speed benefit in it, I typically use Table.Buffer in all of my queries by wrapping the very last line. Example Source = #"My Data" in Table.Buffer(Source) as table However, when someone else uses the same template file on their machines, the queries won't refresh...
  7. K

    How to change Month No. according Dropdown List selection ????

  8. 2

    Renaming a query

    Hello, How can I rename a query (not its shortcut)? I've a query that is part of a 'Group' under 'Custom' category in Navigation pane. When I right click on the query I see option of renaming the shortcut. How can I rename the actual query (not only the shortcut)? I am using MS Access2016...
  9. Jyggalag

    Pivot Table with Query

    Hi All, I am currently facing an issue in with my pivot table that I have been absolutely unable to fix and it does not seem like the Power Pivot forum is very active compared to this one. In addition, mine is more related to Pivot Tables than Power BI, Query or anything like that, so I may...
  10. J

    Filter column outside dynamic table range

    Hello, I use a dynamic table which absorbs data from a query regarding the name of sales agents, names and codes of (their) clients, and hours left from a pack. It can be updated to reflect the new amount of hours left, and I can filter by name of salesperson to show only their clients and the...
  11. B

    Need help with Query on linked tables

    Hello All, I am completely new to access and was trying to do this with Excel Power query and was successful however the data is so large that it is taking forever to run, so I decided to give access a go. Here is the situation, I have 10 locations I manage and each day I receive a csv file for...
  12. M

    Query to return only the latest records record from linked table

    This has probably been posted but I have been looking for it confused for quite some time. I'm quite new to access - have written a few queries but am looking for a solution which doesn't seem to fit anything I have found as yet. I have a database with linked tables with 1 to many...
  13. B

    MS Query - Order No beginning with W but does not contain a '/'

    Hi There i am new to using MS Query, i think this should be a very simple answer. I am looking to display all of the order numbers that are beginning with W, but do not include those with a '/' in the order number. I started by doing Like 'W%' which works for the first part. How do i then edit...
  14. S

    Auto fill Excel Template with data

    Hello, I have a large excel file with over 50 columns that is out of order when i downloaded from web. So web content management system scrambled all the columns, and when export to excel, all columns are out of order. Original data is a Form responses that exported out to excel...
  15. B

    How to distinguish data from same column to different columns

    Good day, I would like to solve this problem using formula, query, or pivot. My company is issuing invoices. Most of them charge audit service fee and outlay together, and a few of them only charge outlay. I cannot think of a logic to distinguish them in the format I expected. Please help.
  16. M

    Query function

    I am using the query function with 3 different ranges within 1 formula, Where i want to Select a column if Column X = to a 'Name'. The problem i am facing currently is that the first 2 Ranges are give me back 2 Null values since it cannot find the name and the 3rd range contains the name. I am...
  17. VBA learner ITG

    Table Merge creates duplicate records in Power Query

    Hi Folks, I am stumped. I am trying to merge two tables into a new table using a LEFT JOIN. Both tables have unique records on each row. When I join the tables, BI creates duplicate rows on some records for no apparent reason. The duplicates are identical in every way. I followed the steps...
  18. K

    #Get data "Sheet 1" to "Sheet 2" in excel ( Check in Image , Follow Condition )

    #Get data "Sheet 1" to "Sheet 2" in excel ( Check in Image , Sheet 1 many Spaces in there , So i Need "invoice Number list" on Sheet 2 (Auto Generated) how to possible get data as a list format, NOTE: SHEET 1 : *** So many Space in there*** SHEET 2...
  19. K

    How to show selected menu in slicer to other cell ??? (Like a Refrence Indication)

    @ How to show selected menu in slicer to other cell ??? (Like a Reference Indication) in pivot table ???? I have Try selection in slicer information reference to other cell , Above image like this yellow Highlight cell this reference
  20. I

    Excel in mac showing as #REF!

    Hi All, I am using Mac and my team is using windows majorly. We have excel where windows user are able to see the data without any issue but i am getting #REF! in most of the cells. Weirdly , when i opened another excel which is connecting to DB and getting the data and then opened the above...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back