query

I have a Query that includes a column with list of last names, i.e. Smith, Jones, etc. In my worksheet there is a named range of Week_Smith, Week_Jones, etc and this named range is a single cell, which contains a date. I would like to add a new column to the Query to return the named range of...

Hello, I have a quite intense (some may think its pretty basic) excel document, which shows information within it that I am looking to condense into a pivot/vlookup basis. There are multiple sheets (within a workbook) - so i am trying to have a 'link' feature to do this correctly. its also...

I run an SPC chart with a power query created table that tests results against Nelson Rules. The samples runs fairly quickly, so I have the Refresh every set to 2 minutes during the day. The refresh triggers a Worksheet_Change event that checks the timestamp of the most recent run, to the...

File link: Gofile Hi, I am pulling in 10 tables from William Hill (bookmakers) with all the English Premier League anytime goalscorer odds. Part of this process includes tweaking the data in the 'edit' mode which I've detailed below. However, when the gameweek is over, the tables are updated...

I have the following cell data. A2 = 108.59 B2 = 20% C2 = 27.15 C2 has the following formula in it: =A2/(1-B2) - A2 this gives me the 27.15 What I want to do is have in D2 a hard value of 23.00 and then in E2 I want the % value based on the formula in C2. IE - If C2 was 23.00, what would B2...

Hi, Looking for some help with some VBA - I'm a beginner with it so it's much appreciated. I have an Excel workbook with a number of queries on different tabs that refresh when I click Refresh All (and Excel handles these in the right order for the final Merged Query), but the Pivot Tables...

Hi All, I have a MS SQL stored procedure returning data to excel. After retrieval I carry out some actions using a macro. When I run the query and then run the macro, the macro takes a long time. If I run the query save, close and reopen the workbook and run the macro first, then it executes...

Good afternoon, Please could you advise where i would put the following array: {QUERY;{"TOTAL",SUM($E$5:$E)}} ...in this query: =IFERROR(QUERY(IMPORTRANGE("sheetname","INVOICE_ENTRY!B2:J"), "SELECT *" & IF ((LEFT(G4,1))="*", "WHERE Col7 STARTS WITH '"& RIGHT(G4,LEN(G4)-1) &"' AND Col1...

i All, In English, I want to populate the cell J4 based on the table value (see attached image) If cell IA = WDDS the populate with table WDDS value 6:00 If cell IA = WDAS the populate with table WDAS value 12:00 If cell IA = WDNS the populate with table WDNS value 20:00 If cell IA = WEDS the...

Hi All, Is there a way to retrieve in VBA the latest refresh date / time of a query ? Thanks!

I'm working on a spreadsheet for our inventory. The inventory is pulled out of a SQL database called Inventory. The retail price field is called PriceRetail and the wholesale price field is called PriceWholesale. The table starts in cell A6. I have a dropdown in cell B3 so I can select...

Tyring to build a report that shows Organization and position that people are in. For example: There is a table that shows all employees (admin) and them in the respective positions Sort ORder Org Big Boss Manager Worker 1 South Group me 1 South Group vacant 2 North Group Tom...

Good day, everyone! I'm in an environment that is running two different versions of Excel. Excel 2016 and O365. I developed a utility which has three data connections to other Excel files, and these data connections are causing me issues. In Excel 2016, I've recently discovered that when a...

I am trying to fetch data from my oracle db using excel VBA. I have made the connection and successfully fetching the data, however my data containing japanese character is broken. It became something like "A14 ｿｿ: ｿｿｿ ｿ ｿｿ: ｿｿｿｿ (ｿｿｿｿｿ)" I wonder why my data containing japanese character is...

Hi there to all Mr Excelssss men. Ok, i know we can type an sql query and bring data to our excel. What a want to do, is to type something, which in this case is an Invoice ID number, and that triggers sql query and give me back some fields. I actually have the query that brings all the records...

I want to have a list of values, say 0001, 0002, 0003, and 0004, and have them formatted into the following text string, where the list of values populate only the bold portions of the below text. I want to have all 4 generated so I can copy/paste them into RapidSQL. Any ideas? select * from...

I have a table TTimeRecords with records including DateofJob and HoursofWork. DateofJob | HoursOfWork 1/1/19 | 6.0 1/2/19 | 8.0 1/2/19 | 6.0 1/3/19 | 7.0 1/3/19 | 8.0 I then wanted to create a query in which hours were summarized for 2019 on a weekly basis, with...

I have a table that has serial numbers with dates that show when a job was entered, the date it was closed and the date it was installed. The Date of the installation is on the incorrect line and I would like to have it put onto the correct line. How can I do this in Access without going thru...

Hello everybody, I'm trying to download financial data from yahoo finance: specifically I have all the tickers of the shares of the Italian market (circa 450 stocks) in an Excel file and I would like to extract some tables from the "key-statistics" section. I'm not very skilled with VBA and...

Hi, I am beginning in power Query in Excel. I have a general issue is the speed of refresh. I have something very basic code like : Source1 = Excel.CurrentWorkbook(){[Name="tblprofit"]}[Content], #"Filtered Rows1" = Table.SelectRows(Source1, each ([Sales organisation] <> null) and...