multiple parameters

  1. C

    Help with Google Sheets Formula

    I'm working on a tax sheet for personal use in Google Sheets. The hard thing is that the tax rate has been different for the last three years, making it hard for me to make the correct formula. I have two tabs in the sheet - Main sheet (showing taxes and tax rate - Tax calculation sheet The...
  2. R

    Help summing based on two columns

    Hi all. Thanks in advance for any help. I need to sum information in a new table based on the values in TWO columns in another table that may have duplicates of those two columns. Looking at the tables below, I need a formula in the “Paid to Date” column in Table 2 that will give me the totals...
  3. A

    INDEX and MATCH formula help - can't get range to expand, and trouble with multiple criteria

    At my new job, I inherited a spreadsheet that displays features on our product orders. The order specs are uploaded into a tab name DATA in the file, and the spreadsheet on the main tab looks up items on the DATA tab and then marks X in the field on the main tab when it finds a match for that...
  4. H

    Parameters from a column for Excel query

    I am trying to run a query in excel where I can use a column from a different sheet to pull the data I need. In excel I run a query and pull the follow fields (plus some): <tbody> Account Number Effective Date System Next Pmt Date Payment Amt 123456 2/17/2017 IVR 3/13/2017 $200.43 254684...
  5. D

    Passing Multiple Parameters to 2 tabs in excel workbook for querying data using ODBC connection

    Hello Guys, Apologies in advance if this is a repeated question, i think i did a quick search and was not able to find perfect answer for what i am looking for. I am pulling the data to excel using ODBC connection (procedures) . I was able to successfully get the data by passing the necessary...
  6. E

    excel query table with SQL IN() multiple value parameter

    Hi, I am looking for a way to insert a single column range as a parameter to an excel query table parameter. I know, the ? mark is a parameter and it prompts u to select a cell where the parameter value is. --- Tried to set a formated string into a cell, like 'param1', 'param2' , "'param'...
  7. C

    Vba for deleting bill of material data for purchased parts

    Mr. Excel, I am attempting to find/write some VBA code for looking at a manufacturing Bill fo Material for a finished product, and deleting any Bill of Material Lines below purchased parts. Assuming the "Line#" heading below is in cell A1, can you help me with some VBA code for this? The...
  8. N

    SUMIF with multiple parameters

    I am working on a project where I need to track the totals, but some of my parameters are not numerical, giving me the #VALUE! error... how can I get around this? For example, this is the information I am working with... LINE 11 | LINE 12 COLOR | MOLD | CASES | MOLD | CASES Antique | 1101 |...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top