Last seen: Mar 8, 2026
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...
Hello, For a formula based solution it is of course easier if you split up the dates and times to helper columns, then you easily can use the MINIF...
Hello Jaginder, In my opinion I think you should go with a rebuild of your data. The idea you have to gather all loans into one table/sheet is corr...
Hello Angelo, Glad I could be of help. Br, Anders
Hello Tony, Why don't you simply create a report in ServiceNow? I assume your exports comes from the Incident Management system from ServiceNow ITS...
Hello Sherry, I am glad I could be of help. Sometimes we tend to miss the simple solutions just because we think it must be more difficult than so....
Hello, If you want to create a formatting rule based on other cell values than the cells you want to format, you need to create a rule using a form...