Last seen: Apr 19, 2025
Try this in B43 =IF(INDIRECT("Table_Matrix["&Person&"]")="X",XLOOKUP(SubNrs,Table_Tasks[subnr],Table_Tasks[task],""),"") Note I made B41...
If you want to go with your original formulas then it is possible to enable interactive calculation just for this workbook by using the following VBA ...
This will give you the results you need. In the formula bar type =Contingency then select the range of costs that the contingency needs to be...
It is possible that a UDF could get the desired result. If using a UDF is acceptable by you then let me know and I will create one for you.
The csv file is located in a folder of similar csv files. I import the folder contents into PQ, sort "Date Created" descending to get most recent file...
Everything seems ok with the sample file, but that is not the same with the actual file. I will investigate some more and come back with another sa...
Here is the file reduced from 2,200kb to 44kb The wrapped text is in column B The actual file has 7,500 rows and 80 columns.
The file was too big for upload to be accepted. I will reduce a load of unused columns and about 6000 rows and try again.
I mean text is like in excel if you enter text in a cell and click the Wrap button on ribbon. The CSV file is attached. Filter Name column for A...
Try this Use a formula in conditional formatting, the formula: =AND($I$5="",$I$6<TODAY()-5) and applies to: $I$5
I got it sorted, couldn't see the wood for the trees! I had left off the closing bracket after MyFile. let MyFile=Excel.CurrentWorkbook(){[Name="Or...
Thanks Riny. As I said in my previous reply I managed to resolve the issue.
I am using windows 11 with Office 365 By "all the images" I meant all the files, which are .jpg files, in a folder which contains only the required...