Power Query for Excel Enable load
Hello all, Does PowerQuery for Excel has the option to stop loading some queries? I Collect data from multiple sources and then append them to one query, then when I load the data all the queries and tables are loaded, the original and the appended tables, this results in data duplication in reports. I found an option in Power BI to enable or disable loading data for selected queries in the same file as shown in the following screenshot: Where can I find this option in Power Query for Excel or how can I solve this problem when I append multiple queries in Excel? Thanks
Can you use AND / OR in an INDEX MATCH
Hi I have am array formula that looks like this: =INDEX('Rebate report'!A:A,MATCH(1,('Rebate report'!A:A=A2)*('Rebate report'!B:B=B2)*('Rebate report'!C:C=C2),0),1) which works. I want to add in an OR function for the name in column A. I will add this name in Column T. In other words the match is correct if column A or T match A2 and COL B=B2 and COL C=C2 also match the criteria I tried using the + to add T criteria but gave me a 0 =INDEX('Rebate report'!A:A,MATCH(1,('Rebate report'!A:A=A2)*('Rebate report'!B:B=B2)*('Rebate report'!C:C=C2)+('Rebate report'!A:A=T2),0),1) Thanks for the help!
Refresh VLookup Data
Hello, The first time I enter the Vlookup information, it will retrieve the correct information (in terms of correct row and column), after I change the Cell value, it will not refresh. It just stays stuck on the previous value (row/col combination). I need to update the data in one worksheet with the data in the original sheet without having to double click and press enter in each cell. B-
pre-1900 dates
I can find no help on how to tell Excel to properly format and calculate dates before 1900. I want to calculate age at death and have birth and death dates in columns. But Excel does not recognize March 30, 1894. It calls is YYYY = 3794. And subtracting death date from birth date returns "#VALUE!" How do I use the DATE(YYYY,MM,DD) function or format March 30, 1894 so Excel will understand and I can have it calculate the age at death correctly? TIA. Also I've seen #1 shown in Excel Help in different posts as BOTH Dec 31, 1899 AND as Jan 1, 1900. Which is it?
Calculate Percentage of cell range of cells with value
Hello, I wish to calculate the percentage of a range of cells (column), but only if they have a value other than '0' (some lazy conditional formatting on my part). It pertains to calculating students were present (which I indicate with a 'P'). However, I obviously want to calculate the percentage based upon the lessons they had, not the whole range (future lessons). So, there will be 100 lessons (cell range) total, but if the student had 10 lessons where he/she was present 9 times, the percentage should be 90%. Thank you for reading this post, and thank you in advance for your consideration. Martin
