Forum

Hello, What do you want help with? You don’t write what you are trying to do. Br, Anders

Hello John, Ok, if we make this parameter based then it's a lot easier. See attached file. You just simply type the cell reference you want to c...

Hello, Below is an example of a formula to check if any value in a range exists in another range. This is however static and of lttle use, but as y...

Hello, This is wrong forum for such issues. Anyway, take a look at this support page. Br, Anders

Hello, Easiest solution is to use Pivot Table, see attached. If you don't want to show the Pivot Table, you can use GETPIVOTDATA to fetch the infor...

Hello, While you are in the protect sheet/workbook window, you can untick the option to select locked cells. If they can't select such cell, it doe...

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...