Last seen: Jul 6, 2025
Hello Steve, I think you will find an answer to your question in this article. The data in the MLB site seems to be structured the same way, so wha...
Hello, I am not sure I understand what you mean with having a searchable drop down list, normally that termonology means that you start write in th...
Hello, Can you describe more detailed what it is you want to achieve? As it is now I am not clear with what you want to do. Here is one techniqu...
Hello, If you check the file I uploaded you will see examples of three different methods. INDEX and MATCH, below formula is in Swedish. =INDEX(V...
Hej Mattias! The time values in table Vertical is formatted as text, while in table DateAndDay they were correctly as numbers. In attached copy of ...
Hello Mike, There are of course lots of books covering from beginner to expert levels, as I have not read any such books I don’t know how good or u...
Hello, Have you read this article? If you for example reference to a named cell where you type in what cell(s) you want to summarize it will make i...
Hello, There are no other methods what I know of than setting a lower screen resolution or using zoom features in Excel or Windows 10/11 or to use ...
Hello, Your subject line mentions there is an error, but you write that it works. I did have a reference error when viewing the uploaded file, but ...
Hello, Do you access the site data with user credentials? Did it stop working after you changed or added a step? Does it work if you create a new q...
Hello, Have you seen this article? Br, Anders
Hello Rob, Your formula will always evaluate to FALSE in regards to the ISNUMBER checks, simply because the equal sign makes it to fail. You have h...
Hello Rob, It seems to me that you want the highest number for each row, so for that you only need the MAX function. The reason to why you get t...
Hello, You can use the database function DCOUNT or you can use SUMPRODUCT to get what you want. See attached file for examples. Br, Anders
Hello Bill, I am not a QuickBooks user myself, but it seems it is possible to connect to data source using Microsoft Query, click this link to a we...