Microsoft Excel – matching all dates highlighted in one column to those in another column

My ultimate goal is to highlight all of the dates highlighted in column P of column M. I was wondering if there was a formula so that I could choose all the values ​​highlighted only in column P and highlight the same values ​​in column M.

So I have a bunch of highlighted dates in one column, see column P. I didn't find a way to copy the highlighted dates in column M, so I had to have them copy manually, which led to the formation of column N, as I was hoping that there would be a formula to highlight all of the same values ​​in column N and column M. I could only still not find the appropriate formula to do so.

As there are several documents, it would take an extremely long time to do it by hand. Thanks to the advance picture of my document

Microsoft Excel – How to make a value field display the last value in a PivotTable

I have a table like this:

enter description of image here

And I would like a PivotTable like this:

enter description of image here

Except that instead of displaying the sum of the amount groups by region in the value field, I want to display the last value based on the date. For example, it will display 300 for Central, 1200 for East, etc.

I am looking at the summary options of the value field, but it seems that such an operation is not available.

Microsoft Outlook – lost editing function

I manage my boss’s Outlook calendar. From my office at work, I can modify the appointments that she has not sent. For example, I want to attach an agenda or make a note in the description. Now that I am working remotely from home, it seems like I have lost this functionality. I can't just change the appointment. There is no editing option. How to edit?

Microsoft Excel 2016 – Preservation of information entered by the user in a table from Power Pivot

Is there a way to keep the information entered by the user in a table from PowerPivot?

I have a read-only query pulling a large dataset and populating a Power Pivot table.

The table is imported into a spreadsheet using Data-> Existing Connections-> Table. I would like to be able to add a "Comments" column which would be updated manually by different users. I would like to keep this column when the query is refreshed – with comments not moving randomly from their records if the table is sorted, filtered, etc. before updating (each record has its unique identifier).

How can this be done?

Microsoft Excel – How to generate a table where an output occurs x times

Basically, I'm trying to recreate code names in Excel and the last thing I miss is to create a name "map", which looks like this. Basically, this is a table where 9/8 spots are blue, 8/9 spots are red, one is black and the rest is white. I don't know how to do this, can you help me?

Thank you!

Multiply a table column by another column – Microsoft Access

I am looking for a code to multiply a column by another in Microsoft Access.

I want to add a database question where I would like to multiply the Inpris column by 1 3338 and define the multiplied value in the Apris column where Artnr starts with "CAS".

For example. Inrpis = 1000, then I would like to multiply 1000 by 1338, which is equivalent to 1338.8, but only on the lines starting with CAS on artnr.

Here is an image of the table columns

Microsoft Flow – How to display only values ​​in a copy of a custom SharePoint list where values ​​are the result of selecting options from a drop-down list?


Of Site Contents directory in SharePoint, I created a Custom List via New > App > Custom List.

I have created my columns and added entries via the form associated with the list.

Some columns are of type Choice and configured to allow multiple selections.

For example:

Service Type:  
 - Groceries - Apples
 - Groceries - Oranges   
 - Groceries - General

(note: multiple options can be selected)    

Desired behavior

Copy a SharePoint list to a CSV file via a recurring Microsoft Flow based on this Microsoft model.

Current behavior

The feed I created works.

However, when I open the CSV in Excel, where the values ​​are the result of selecting options from a drop-down list, the corresponding field has 4 columns (rather than 1):


with the corresponding values ​​of:

({"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":2,"Value":"Groceries - General"})





How can I make sure that:

  • Only one column is displayed for each drop-down field
  • Only values ​​are displayed, rather than all of Microsoft's "markup" text


enter description of image here
enter description of image here

onedrive for business – How do I update Microsoft Form responses when the values ​​in the corresponding spreadsheet are updated?

Desired behavior

  1. Public User A submits Microsoft Form which fills out a connected spreadsheet in real time.

  2. Company Users can modify the answers in the connected spreadsheet.

  3. The data presented in the Responses The Microsoft Forms interface tab reflects the updated values.

Current behavior

Currently, after Company Users modify the spreadsheet, the data presented in the Responses Microsoft Forms interface tab displays data as it was originally entered, rather than displaying the new values.


How can I make the data presented in the Responses The Microsoft Forms interface tab displays the updated values ​​from the connected spreadsheet, rather than the original submitted values?

Steps to replicate

Create a form via:

OneDrive file list > New > Forms for Excel

This will redirect you to the Microsoft Forms interface.

Click on Responses tab and the Open in Excel link, which will create a spreadsheet where responses are added in real time.

Edit the values ​​in the responses in the connected spreadsheet.

Click on Responses in the Microsoft Forms interface.

The data presented will reflect the values ​​as they were originally entered, rather than the updated values.

Microsoft Pauses Optional Windows Updates

Security updates coming soon.

How to disable / block the Microsoft Store on Windows 10 Pro by firewall?

I want to block Microsoft Store on Windows 10 pro in a corporate environment. After reading relevant articles on this subject and tested on my machine, I find that Windows 10 Pro does not support this function (whether via group policy (not recommended by my manager) or the registry.

Now, I opt for another solution, that is to say block it by a firewall. If possible, can someone show me the Microsoft Store firewall blocking rules? I am using a tool to configure this rule.