Get instant live Excel expert help to learn how to use Choose function in Excel

I have fix some Conditionla formatting in Excel cells and fix the different Colour. But when i choose one colour with filter , it's picked also some cells of other Colour.

I am making a quoting workbook for window coverings (like blinds and shades). It is based on inch measurements. Based on the width/height measurements it will give a price based on a price grid. There are multiple products to choose from in a drop down list, and each product has its own price grid. Example: if a honeycomb shade is selected and the measurements are 36x60, I want to be able to input that into the workbook and have it look up the correct price automatically. The price grids are arranged in 6 inch increments, so if the measurements fall in between two columns or rows, it defaults to the larger value. Help?

I am working on an assessment rubric template. The criteria being scored all have different weights, (ex 1, 5, 8, 10). Within the rubric you can receive full credit, (score = weight *1), partial credit (score = weight *.05), no credit (score = weight *0) or you can be unable to assess (no score), in which case the number of possible points should be lower. I am having a difficult time setting this up, so that the assessor can choose between these options (full credit, partial credit, no credit, unable to assess) at each different assessment.

Each client can choose 4 consultants, each consultant can choose 2 clients. The upper table shows which consultants each client choose. The lower table shows which clients each consultant choose. I want to use vlookup and functions to get result in Column G, the result of which consultant are not matched for each client. For example, for A client, A chose 1,2,3,4, but the lower table shows, consultant 1 chose A, so 1 is matched to A, however, A chose 2, but 2 didn't pick A, so 2 appeared in Result (not chosen). After this is solved, I want to compute how many times consultant chosen, how many times they are repeats in the lower table.

Hello, I need help ultimately creating a dependent excel workbook where I can filter through results that are dependent on others. In this document, you can see that I have 'Practice Network' and 'Provision' in the first row. I really just want to take this template and turn it into something I can filter. If I choose a certain 'Practice Network' (for ex/ Enterprise) then I want all of the provisions (for ex/ Provision #: 13001) to show up and then all the information for those provisions to become available. If there are multiple provisions in a Practice Network then I want all of those provisions to show up. I am attaching the excel.

I have several cells programed with "IF" functions in commissions, I now need to program a cell to choose the cell that has a number in it and have that dollar amount show up in the cell. I can do the first cell but don't know how to add the other cells. =IF(I24=FALSE,I24=TRUE,I24)

I need Column d,e,f to auto populate when I choose a drop down in b and a drop down in c

Using the data provided in this worksheet create a Pivot Table that answers a manager's question “Which salesperson sold the most in any particular month.” A manager wants to click on the Pivot Table and choose a month and have the name of that person appear with his or her amount for that month.

I need a formula that sums a row, based on a certain (dynamic) set of criteria, requiring it to choose a row based on another set of criteria to look for the first criteria. Essentially: SUMIF(index(match(set of rows, type,0),sum criteria, sum area)

To update the graph, table & reporting period, once I choose different week from the dropdown list