microsoft excel: you need to search for a specific phrase in a cell and then search for another value in another table

Thanks for the help in advance!

I have a table full of campaign data. I need to write a function to see a column "IO Number" on Sheet 2, Column A, in this example "AM262" and then see on Sheet 1, Column C if that name appears. In this example it does, but it looks like this "IO-AM262". If so, go to Sheet 2, find the corresponding exchange rate in C2 and return it.

SO, look at S2, CA and find it at S1, CC and return S2, C1.

More complicated example: find KP1002 in S2, A40 in S1, C24 (text: 2020 | Q2 | Sage | MEA | ZA | Small | Social_SMBS_KP1002) and return R14.95 in S2, C40)

cell phones: are all prepaid SIM cards called tourist SIM cards in Thailand? Or are there some prepaid "local" SIM cards?

Are all prepaid SIM cards called tourist SIM cards in Thailand? Or are there some prepaid "local" SIM cards?

I'm asking that all the prepaid SIM cards that they showed me (because it's behind the ATM) in a 7-eleven were called tourist SIM card:

enter the image description here

which makes me wonder if there are non-tourist prepaid SIM cards and, if so, what is the difference with tourist prepaid SIM cards.

sharepoint server – edit cell in grid view

I have a web part with grid view and I want to edit a cell of "Utente" and update this with modify. This cell gets the data from the list. How can I do that? You can help?

my aspx

    
    
    
    
        
            
        
        
            
        
    
    
        
            
            
        
            

        
    
    
       
     

 
        
        
        
        
    public GestioneAttivita()
    {
    }

    protected override void OnInit(EventArgs e)
    {
        base.OnInit(e);
        InitializeControl();
    }


    protected void Page_Load(object sender, EventArgs e)
    {
        // _id = Page.Request.QueryString("ID");
        if (!Page.IsPostBack)
        {
            SPSecurity.RunWithElevatedPrivileges(delegate ()
            {
                using (SPSite ElevatedSite = new SPSite(SPContext.Current.Web.Site.ID))
                using (SPWeb ElevatedWeb = ElevatedSite.OpenWeb(SPContext.Current.Web.ID))
                {
                   CaricaTendinaAttivita(ElevatedWeb);
                   CaricaTendinaEsito(ElevatedWeb);
                   CaricaTendinaCausale(ElevatedWeb);
                    CaricaTendinaUtente(ElevatedWeb);
                    CaricaItem(ElevatedWeb);


                }
            });
        }
    }

    protected void btnCerca_Click(object sender, EventArgs e)
    {
        SPSecurity.RunWithElevatedPrivileges(delegate ()
        {
            using (SPSite ElevatedSite = new SPSite(SPContext.Current.Web.Site.ID))
            using (SPWeb ElevatedWeb = ElevatedSite.OpenWeb(SPContext.Current.Web.ID))
            {
                CaricaItem(ElevatedWeb);
            }
        });
    }

    protected void btnAnnulla_Click(object sender, EventArgs e)
    {
        SPSecurity.RunWithElevatedPrivileges(delegate ()
        {
            using (SPSite ElevatedSite = new SPSite(SPContext.Current.Web.Site.ID))
            using (SPWeb ElevatedWeb = ElevatedSite.OpenWeb(SPContext.Current.Web.ID))
            {
                PulisciControlli();
                CaricaItem(ElevatedWeb);
            }
        });
    }

   private void PulisciControlli()
    {

        ddlAttivita.SelectedValue = "";
        ddlEsito.SelectedValue = "";
        ddlCausale.SelectedValue = "";
        ddlUtente.SelectedValue = "";
        txtOrigineCSV.Text = "";
        ddlAttivita.Enabled = false;
        ddlUtente.Enabled = false;
        ddlEsito.Enabled = false;
        ddlCausale.Enabled = false;
        txtOrigineCSV.Enabled = false;
    }


    private void CaricaItem(SPWeb web)

    {

        SPList listaGestAtt = web.GetList(web.ServerRelativeUrl + "/Lists/" + ddlListaDiRiferimento.SelectedValue);
        var value = ddlAttivita.SelectedItem.Text;
        SPListItemCollection items = null;


        if (!String.IsNullOrEmpty(ddlListaDiRiferimento.SelectedValue))
        {
            SPQuery query = new SPQuery();
            query.Query = "" + ddlListaDiRiferimento.SelectedValue + "";

            items = listaGestAtt.GetItems(query);

            if (!String.IsNullOrEmpty(ddlAttivita.SelectedValue))
            {

                SPQuery queryAttivita = new SPQuery();
                queryAttivita.Query = "" + ddlAttivita.SelectedItem.Text + "";

                items = listaGestAtt.GetItems(queryAttivita);
            }

            if (!String.IsNullOrEmpty(ddlUtente.SelectedValue))
            {
                SPQuery queryUtente = new SPQuery();
                queryUtente.Query = "" + ddlUtente.SelectedItem.Text + "";

                items = listaGestAtt.GetItems(queryUtente);
            }

            if (!String.IsNullOrEmpty(ddlEsito.SelectedValue))
            {
                SPQuery queryEsito = new SPQuery();
                queryEsito.Query = "" + ddlEsito.SelectedItem.Text + "";

                items = listaGestAtt.GetItems(queryEsito);
            }

            if (!String.IsNullOrEmpty(ddlCausale.SelectedValue))
            {
                SPQuery queryCausale = new SPQuery();
                queryCausale.Query = "" + ddlCausale.SelectedItem.Text + "";

                items = listaGestAtt.GetItems(queryCausale);
            }

            if (!String.IsNullOrEmpty(txtOrigineCSV.Text))
            {
                SPQuery queryOrigineCSV = new SPQuery();
                queryOrigineCSV.Query = "" + txtOrigineCSV.Text + "";

                items = listaGestAtt.GetItems(queryOrigineCSV);
            }
        }
        else
        {
            items = listaGestAtt.Items;
        }




        var itemBindabili = from SPListItem i in items.Cast()
                            select new
                            {
                                ID = i.ID,
                                Titolo = i("Title"),
                                Attivita = new SPFieldLookupValue(i("Attivit_x00e0_") as String).LookupValue,
                                OrigineCSV = new SPFieldLookupValue(i("OrigineCSV") as String).LookupValue,
                                IDUtente = ControllaID(web, Convert.ToString(i("Utente"))),
                                Utente = ControllaUtente(web, Convert.ToString(i("Utente"))),
                                Esito = new SPFieldLookupValue(i("Esito") as String).LookupValue,
                                Causale = new SPFieldLookupValue(i("Causale") as String).LookupValue,
                                Data = i("Created"),

                            };

        grdItems.DataSource = itemBindabili.ToList();
        grdItems.DataBind();
    }




    private string ControllaUtente(SPWeb web, string fieldValue)
    {
        if (!string.IsNullOrEmpty(fieldValue))

            return new SPFieldUserValue(web, fieldValue).User.Name;

        else
            return (fieldValue);
    }      

    private int ControllaID(SPWeb web, string fieldValue)
    {
        if (!string.IsNullOrEmpty(fieldValue))

            return new SPFieldUserValue(web, fieldValue).User.ID;

        else
            return -1;
    }







    protected void ddlListaDiRiferimento_SelectedIndexChanged(object sender, EventArgs e)
    {
        string value = ddlListaDiRiferimento.SelectedValue;
        CaricaItem(SPContext.Current.Web);
        if (!String.IsNullOrEmpty(ddlListaDiRiferimento.SelectedValue))
        {
            ddlAttivita.Enabled = true;
            ddlEsito.Enabled = true;
            ddlCausale.Enabled = true;
            ddlUtente.Enabled = true;
            txtOrigineCSV.Enabled = true;
        }



    }


     private void CaricaTendinaAttivita(SPWeb Elevatedweb)
     {
        ddlAttivita.ClearSelection();
        ddlAttivita.Items.Clear();

        SPList list = Elevatedweb.Lists.TryGetList("Attività");
        SPQuery query = new SPQuery();
        query.Query = "";
        SPListItemCollection collection = list.GetItems(query);
        ddlAttivita.DataSource = collection;
        ddlAttivita.DataTextField = "Title";
        ddlAttivita.DataValueField = "ID";
        ddlAttivita.Items.Clear();
        ddlAttivita.Items.Insert(0, new ListItem("", ""));
        ddlAttivita.DataBind();
    }


    private void CaricaTendinaEsito(SPWeb Elevatedweb)
    {
        ddlEsito.ClearSelection();
        ddlEsito.Items.Clear();

        SPList list = Elevatedweb.Lists.TryGetList("Esiti");
        SPQuery query = new SPQuery();
        query.Query = "";
        SPListItemCollection collection = list.GetItems(query);
        ddlEsito.DataSource = collection;
        ddlEsito.DataTextField = "Title";
        ddlEsito.DataValueField = "ID";
        ddlEsito.Items.Clear();
        ddlEsito.Items.Insert(0, new ListItem("", ""));
        ddlEsito.DataBind();
    }


    private void CaricaTendinaCausale(SPWeb Elevatedweb)
    {
        ddlCausale.ClearSelection();
        ddlCausale.Items.Clear();
        SPList list = Elevatedweb.Lists.TryGetList("Specifica");
        SPQuery query = new SPQuery();
        query.Query = "";
        SPListItemCollection collection = list.GetItems(query);
        ddlCausale.DataSource = collection;
        ddlCausale.DataTextField = "Title";
        ddlCausale.DataValueField = "ID";
        ddlCausale.Items.Clear();
        ddlCausale.Items.Insert(0, new ListItem("", ""));
        ddlCausale.DataBind();
    }

    private void CaricaTendinaUtente(SPWeb Elevatedweb)
    {
        using (SPWeb Web = new SPSite("http://lavorazioni.contacts/siti/crm").OpenWeb())
        {
            SPList lUtenti = Web.Lists.TryGetList("CSC");
            SPQuery query = new SPQuery();                
            query.Query = "";
            SPListItemCollection collection = lUtenti.GetItems(query);

            var itemBindabili = from SPListItem i in collection.Cast()
                                   select new
                                   {
                                       IDUtente = ControllaID(Web, Convert.ToString(i("Account"))),
                                       Utente = ControllaUtente(Web, Convert.ToString(i("Account"))),

                                   };

            ddlUtente.DataSource = itemBindabili;
            ddlUtente.DataTextField = "Utente";
            ddlUtente.DataValueField = "IDUtente";
            ddlUtente.Items.Insert(0, new ListItem("", ""));
            ddlUtente.DataBind();
        }


    }



    protected void Update(object sender, EventArgs e)
    {

    }

    protected void txtUtente_Changed(object sender, CommandEventArgs e)
    {
        int row = int.Parse(e.CommandName);
        int cell = int.Parse(e.CommandArgument.ToString());
    }






    /* protected void grdItems_SelectedIndexChanged(object sender, SPWeb web, EventArgs e)
     {
         int id = Convert.ToInt32(grdItems.SelectedValue);

         SPWeb currentWeb = SPContext.Current.Web;

      //SPList listaGestAtt = web.GetList(web.ServerRelativeUrl + "/Lists/CONGIUNTIVW"); //web.GetList(web.ServerRelativeUrl + "/Lists/CONGIUNTIVW");
      SPList listaGestAtt = web.GetList(web.ServerRelativeUrl + "/Lists/" + ddlListaDiRiferimento.SelectedValue);

      SPListItem Item = listaGestAtt.GetItemById(Convert.ToInt32(id));

         lblSelectTitleValue.Text = Item.Title;

         pnlModifica.Visible = true;
     }

     protected void grdItems_RowDeleting(object sender, SPWeb web, System.Web.UI.WebControls.GridViewDeleteEventArgs e)
     {
         string id = grdItems.DataKeys(e.RowIndex).Value.ToString();

         SPWeb currentWeb = SPContext.Current.Web;

         SPList listaGestAtt = web.GetList(web.ServerRelativeUrl + "/Lists/CONGIUNTIVW");

         SPListItem Item = listaGestAtt.GetItemById(Convert.ToInt32(id));

         Item.Delete();

         SPSecurity.RunWithElevatedPrivileges(delegate ()
         {
             using (SPSite ElevatedSite = new SPSite(SPContext.Current.Web.Site.ID))
             using (SPWeb ElevatedWeb = ElevatedSite.OpenWeb(SPContext.Current.Web.ID))
             {
                 CaricaItem(ElevatedWeb);
             }
         });

     }

     protected void grdItems_PageIndexChanging(object sender, System.Web.UI.WebControls.GridViewPageEventArgs e)
     {
         int index = e.NewPageIndex;
         grdItems.PageIndex = e.NewPageIndex;

         SPSecurity.RunWithElevatedPrivileges(delegate ()
         {
             using (SPSite ElevatedSite = new SPSite(SPContext.Current.Web.Site.ID))
             using (SPWeb ElevatedWeb = ElevatedSite.OpenWeb(SPContext.Current.Web.ID))
             {
                 CaricaItem(ElevatedWeb);
             }
         });
     }*/

}

}

reference cell to copy and paste into google sheets

I am building a Catan board on Google Sheets to interactively share and play with friends. The game starts & # 39; blank & # 39; with a frame, and players choose what kind of pieces the board should have and then they play. I have a dropdown menu that is in each piece of the game, then a macro that copies / pastes the template pieces on the side of the board. I want to adjust the macro so that when you select one of the dropdown menus, it will be copied from the SAME location of the template and then paste on the game board RELATIVE to the dropdown position.

This is what the & # 39; game board & # 39; looks like. The template pieces are on the left side, and are copied and pasted depending on what the drop-down selection value is (see cell AH6)
enter the image description here

Here is the macro script I have so far:

  var spreadsheet = SpreadsheetApp.getActive();
  spreadsheet.getRange('AF7:AJ9').activate();
  spreadsheet.getRange('B26:F28').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_NORMAL, false);
  spreadsheet.getRange('AG6:AI10').activate();
  spreadsheet.getRange('C25:E29').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_NORMAL, false);
  spreadsheet.getRange('AH5:AH11').activate();
  spreadsheet.getRange('D24:D30').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_NORMAL, false);
};```

It works, but I want it reference the same template on the left and paste into the cells that are relative to where the dropdown was

gui layout – Alternative to color coding in table cell

I'm not entirely sure that their problem is the colors themselves. When a table starts to look messy, it usually means you had a messy base to start with. Tufte coined the term "junk graph" to refer to these kinds of weird visuals that, while on the surface seem to make sense, ultimately just get in the way to see the actual data:

http://en.wikipedia.org/wiki/Chartjunk

The easiest example of chart garbage in the table is the vertical dividing lines between the cells in the table. In most cases, the data itself creates a line of sight for you. You don't need to add another line to mess things up.

Therefore, I suggest going back and ordering the table layout as much as possible. At that point, you may be able to see much simpler solutions to the highlighting problem.

Voice over cell phone and screen sharing through a laptop with Microsoft Teams?

I would like to call people with the equipment app on my cell phone because it makes using my AirPods easier. But if you want to share the screen, it is too small on the cell phone screen. I would like to get the screen share on the laptop while maintaining the voice connection on the cell phone.

If it's a team meeting, this is easy. I simply connect from my laptop and cell phone to the meeting and turn off the voice on the laptop.

But I can't find a way to do this when I call single people.

Any ideas?

Google Sheets: Merge names into a single cell based on whether a date is between the start and end date

I am trying to create a shift schedule sheet. In one tab I have vacation requests and in another the schedule. I want the names of those people who have vacations to enter a cell on that date in the schedule. Ideally, these would also be just vacation requests with the status "Approved".

So far I have:

=TEXTJOIN(";",TRUE,IF(AND(C2>=Vacation!$A2,C2<=Vacation!$B2),Vacation!$C$2:$C$32, ""),"")

This stops all names and does not filter dates correctly, even though dates are filtered correctly, when the TEXTJOIN part of the formula is not used.

You can see my example here: https://docs.google.com/spreadsheets/d/1ZPV_wqKAah-zCz2mdxciQnb0ORfdDWa_ABu1o4eua8A/edit?usp=sharing

How to enable R in ExternalLanguage cell?

Mathematica 12.1 adds support for R in the ExternalLanguage cell. But this does not work out of the box.

enter the image description here

Very old Mathematica downloads RLinkRuntime-Windows-9.0.0.0 (R 2.14!).

enter the image description here

How to enable R on the ExternalLanguage cell?

google sheets: match the list string with the cell containing the string (Extracting city from company name)

Sheet A has a list of restaurant names from across the country:

Restaurant               | City
The Bar and Grill Tampa  | ...
Oklahoma City's Best Bar | ...

Sheet B is a list of all cities in the United States:

Tampa
Oklahoma City

How do I get the correct city completed in the City column on Sheet A? This shouldn't be complicated since I'm basically saying look at Sheet B, if Sheet A contains a City from Sheet B, then list the city on Sheet A. But I can't find a solution anywhere that works.

In a Google worksheet, I want a cell on sheet c to take a value on sheet b without taking the formula

You can use an array to extract data from one sheet to another.

= {b! A1: A} This will bring the entire column of sheet B.

Only for the value should you copy and paste only with values. This can be done with a recorded macro if the data is updated on sheet B.

Using {} to create arrays is a great way to import entire columns of data between sheets.