Forum

Hello Mohammed, As you don't mention what Excel version you are using I only mention two simple solutions, which includes using Pivot Table to view...

Hello David, Please take a look at this post, it explaines how you attach files to your post. Read This First | Forum Rules and Guides | Excel F...

Hello, The %3A is the url encoding for colon (:). See the link for more info. Br, Anders

Hello, It will work perfectly fine for them to view the cached data, if they by chance try to update the data they will get an error, but they will...

Hello, Typically this scenario happens when the columns bordering the table is hidden and when you add data to visible bordering column. Example...

Hello Alan, All I know of is the standard shortcuts to use Ctrl + PgUp/PgDown to move up/down the range of sheets. If there are many sheets I right...

Hello, Do you want something like this? Below formula gives #N/A if no match is found, else it pulls the indicator value for that driver. Might be ...

Hello, If you can upload a sample file with some dummy data along with a mockup of the expected result that would be of great help for all. Br, ...

Hello, No file was uploaded. You need to click the Start Upload button after you have added the file, then wait a few seconds for the upload to fin...

Hello, No file got uploaded. Br, Anders

Hello, Ok, I hope you get a solution that works. Br, Anders

Hello, It is quite possible I don’t understand what you are doing. Do you have a sample file? Br, Anders

Hello, Don’t delete ColA is a good start to retain the formatting made for that specific column. You will get the same result if you remove other f...

Hello Scott, The solution I give here is using another approach and I am using exact match, not just the first three characters as that can give mu...

Hello, From Excel 2013 and newer you have the ISFORMULA function, so you can check if the cell contains a formula or not. Example: =IF(ISFORMULA...