Delete extra row
I have a document with 95 people, where I fill in 1 row for each of them for each day. One day I fill in 91 rows, the second day 89 rows, the third 94... (each day a different number of rows to fill in). After that entry, for each person I need to have 24 filled in rows for the last 24 days when I entered data. The next day I enter data for 92 people, for those 92 people I will have 25 filled in rows (the 25th row is extra and I have to delete it, now I do it manually). How can I delete that 25th row at once for all 92 people, so that I have 24 rows left for everyone?Table visual is not filtered due to dax measure
Hi Team, I have a visual as below: when i filter company as below: Table should give me records for selected company and not any other records. But the table here shows all records which means the filter is not recognized. for example, the site and device slicer shows correct records for filtered company but table is not: I guess the problem is due to the below dax online status: This brings in all records irrespective of the selected slicer. Could you please help me resolve this? Please advise! PFA file here PR0442 - Heatsense Live_V1 - Copy.pbix Thanks in advance! SergeiBaklan
Urgent for geography Coursework help (due tonight)
I compared 2 different areas using a visual housing survey and used 4 different categories - including exterior appearance, noise level, cleanliness and house plot size - I want to use statistical test to help my conclusion but i don't know which one and how
Office Scripts Custom Sort Failing During Automation
I am attempting to use office scripts within a OneDrive Excel document within Microsoft Teams to run a custom sort. Using the "Record Action" feature, I simply attempted to sort the range H3:J28 via the Timestamp or the H column. When running the custom sort manually, I get the below result, no errors. When I run the same action using the recorded Script, for some reason the values within the I and the J columns are swapped. Is there a way to avoid this? The relevant script is listed below. function main(workbook: ExcelScript.Workbook) { let selectedSheet = workbook.getActiveWorksheet(); // Custom sort on range range H3:J128 on selectedSheet selectedSheet.getRange("H3:J28").getSort().apply([{key: 0, ascending: true}], false, true, ExcelScript.SortOrientation.columns); }Python in Excel quota problem
I understand that there is a quota. It's normal because Microsoft's servers are not sufficient. However, there's a problem: I have an Excel file with a total of 22 tabs, each containing independent calculations. When I change the content of a single cell, all formulas in all Excel tabs start working. Why are they all running, and why am I not controlling this calculation or compilation process myself? I have Anaconda installed on my machine. If you allow me to run the Excel calculations with Python on my machine without limits, it would be an excellent solution. The same issue exists with GPT. We can't perform large calculations on your servers. GPT already says, "You can run this code." GPT and Python in Excel only support small calculations with a few formulas. Unfortunately, large-scale enterprise operations fail. Since no CPU or GPU solution is available right now, at least allow running Python within Excel on our own machines until this crisis is resolved. If this isn't possible, only calculate the formulas in the tab I'm currently working on. Additionally, let me control this calculation process. When writing a code, all lines of code are executed for each row. This is very unnecessary.
How to pull values from a different sheet based on a checkbox
I have a list of clients and their contact information on one sheet, and an invoice template on the other. I want to pull the clients' names and email addresses into a specific field on my invoice template, and I want to be able to do that by ticking a checkbox next to whoever's name I want to include. I can pull values of specific cells to the other sheet, so multiple sheets isn't the problem. I just don't know how to make it so I can tick a checkbox and have that pull the right information to where I need it.
