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!
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?
