Forum

Hello, You made a good effort trying to explain, but you did not attach a sample file. Br, Anders

Hello, Your file is empty. However, check out this article linked to below and have a go at it. Br, Anders

Hello Cynthia, I assume you refer to Power Query and load files from folder. I would go for such approach. Not knowing what data you have, but if y...

Hello Derek, I understand what you are trying to achieve, but even though Excel can handle big data in the Data Model it is not a relational databa...

Hello James, Just simply wrap it with the TIME function. In cell E2: =TIME(HOUR(NOW()),MINUTE(NOW()),0) Br, Anders

Hello, The asterisks are wildcard characters which makes it possible to make a fuzzy search. More info about wildcard characters in Excel can be fo...

Hello Mouna, If you search for export data into separate workbooks in whatever search engine you prefer you will get some examples, some also havin...

Hello Lea, It is quite simple when you get the hang of it. First, I defined in the Name Manager the list of names to check against as Lookup, if...

Hello, There is, to my knowledge, no other tool than find and replace, wheras you search for the old filename in the formulas and replace that with...

Hello Diane, If you can provide a sample file with this data that would be great. Br, Anders

Hello Salim, You will have to use custom number formatting or conditional formatting to get those symbols. Br, Anders

Hello, No Excel file attached, probably to big. I would say that Excel is not the best tool for this scenario, but with VBA code it can be done....

Hello, You can set this behaviour, check out this info at Microsoft support pages. Br, Anders

Hello Lea, Have a look in this blog article, it shows what needs to be done to consolidate many tables into one. Br, Anders

Hello Ali, With a helper column where you for example count how many times the individual names is found in your range, the formula to get what you...