Forum

Hello, Can you give examples of what data you want in the yellow rows, I do not understand what it is you are trying to do. Br, Anders

Hello, With signature line you can’t sign an individual sheet, you sign the workbook. Br, Anders

Hello, Not sure if the text to speech feature works for this, you have to try it out. Br, Anders

Hello Peter, As I don't know what version of Excel you are using, but see if you can use XLOOKUP function instead. Br, Anders

Hello Carl, You have made the date as text. Try below formula. I pretend in this example that the date 200104 is in cell Q25. =DATUM(20&VÄNSTER...

Hello, The column header Duration most likely interferes with the Excel function Duration, just rename the header. Br, Anders

Nice job Velouria!

Hello John, So you don't want a parameter based solution then. As far as I understand what you want to do, you are most likely better off with a...

Hello John, Just change the formula in cell O4 to =IF(ROW(INDIRECT($R$2))=ROW(),Result,""). Make sure it copies down to the other cells in the tabl...

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