Maps Data for Scotland
Hi, Apologies if this has been answered elsewhere but I'm trying to create a map chart for Scottish Local Authorties (Council regions) and I have all of their official names but the Maps chart isn't having it. Is there a list somewhere for how I should be naming these or am I missing anything else? I've attached a picture of my data. Thanks, Chris
Excel data link without permission in Sharepoint
Good morning, please excuse if the terms I use are not correct, Excel is not running in English, so all terms I use are translated. I've got an Excel sheet with some data links to other Excel sheets. Let's call this sheet A. I access the other sheets (let's call them sheets B-F) via sharepoint, they're shared by a colleague via onedrive. Now I shared my sheet A with a third colleague, works fine. BUT: As the data in sheet A should be automatically updated from sheets B-F, the latter colleague is asked to sign in with another account, because he has no access to sheets B-F. Can I somehow give access to the relevant data of sheets B-F for each user of sheet A without giving them access to whole files? Thanks in advance for your help!Excel Version 1907 [Expression.Error] This native database query isn't currently supported
I have a file that contains a data connection that has been working for months. It recently stopped working after the 1907 update applied. Is anyone else experiencing an issue? How might I go about determining what part of the native query is causing the issue? I have also converted the query to a stored procedure and it doesn't work either. Is there a way to get more detailed error information?
Taking values from certain rows based on data input
So I'm trying to get a value into the column "Cat A Tied" (C column). This value depends on the number in the "# People Tied With" column (D Column). In this case, cell D2 has the number 3 in it. I want the sum of the first three rows of the B column (not including column headers) and then divide that by 3. However, I want the cell to be dynamic so if I change the number to 5 it will then automatically take the sum of the first 5 rows and divide by 5. Additionally, if I put this value into D3, the second row of my table, I'd want the first number (3 or 5, or any number put in) of rows from that same row onwards instead of from the first row of the data set. Any help would be greatly appreciated 🙂
Sorting data - by reference
Hi I have data set like this; Date Reference 28/11/2017 119737 28/01/2018 119737 28/02/2018 119737 28/03/2018 119737 07/09/2017 119787 07/10/2017 119787 07/11/2017 119787 07/12/2017 119787 07/01/2018 119787 07/02/2018 119787 07/03/2018 119787 28/09/2017 119807 28/11/2017 119807 28/09/2017 119839 28/10/2017 119839 28/11/2017 119839 28/12/2017 119839 28/01/2018 119839 28/02/2018 119839 28/03/2018 119839 01/10/2017 119931 01/11/2017 119931 01/01/2018 119931 01/02/2018 119931 I need to split the references /dates to different CSV files as one file cant have duplicate references. Im currently filtering and numbering, then will move all 1's, all 2's etc. Is there a quicker way to do this? Thanks :)
Excel - auto-transfer data between column
Hello, I have column A to G. In the column B were listed first and the last names in alphabetical order. In the column F the same first and the last names from column B were listed without any order. Column C is empty. Column G have data related to the column F. What I need? I need the name from column B to be recognized from column F and the data from column G to be automatically assigned to the column C. Please see the screenshot below. From the screenshots: B1 to be recognized from F (in this case F7) and G7 to be automatically added to C1. B2 to be recognized as F6 and G6 to be automatically added to C2. The most important is data from column B to be recognized in F if that is possible. Any help is much appreciated. Thank you!
Calender names, multiple subject to select *option draw-down*, with specific dates copied pasted
Hi, Thank you for taking the time to read this. I am looking for the following excel spreadsheet (guidance). I am looking for the ability to have an excel "macro" or "formula" to be used so I can see instant modifications to information from TAB "A" to reflect specific information for TAB "B" in the manner requested. I believe it is possible but bottom-line, I would be looking to have a calender broken down Jan 1 2018 until Dec 31 2018 (Just for an example of dates), where I have "x" number people listed from "1-x" numbers and on the columns a-xyz dates, individuals are annotated on their 'c14 until K14' as Seattle, WA, and the information reflects on my second tab *in specific location identified for the start date 14 Jan 2018 and for the end date 31 January 2018* With a highlight of anyone with a changed start/stop date within the past 4 days for identification. The ideal formula, would be easily and feasibly to move, and change the required information for the person if needing to add or remove their information accordingly for if fired, hired, etc... without becoming too messy or complicated to follow or create. I hope this makes sense in what I am asking, and others have similar information easily accessible for use. Recap: X person name tab A annotated Seattle, WA from X1 to X14 (without break or change from Seattle WA annotation in each block), on Tab B Next to person name, Seattle, WA for location block and start date reflects actual date 4 Jan 2018 and end date (last date annotated as Seattle WA) 14 Jan 2018. This will be highlighted. Y Person name tab A annotated Georgia, GA From Y1 to Y24 (without break or change from Georgia, GA annotation in each block), on Tab B Next to person Name, Georgia, GA for location block and start date reflects actual date 1 January 2018 and end date (last date annotated as Georgia, GA) 24 January 2018. This will be highlighted. X Person name tab A annotated as Alaska, Alaska From X260 to 260 (without break or change from Alaska, Alaska annotation in block, TAB B Next to person name would be the default choice (Present) for location block and start end date would be blank because it didn't meet the current time-frame of 4 April 2018. Please see excel for example of what I am trying to explain for help to use if needing help. If needing further clarification for better understanding of request please let me know.
