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

I have filters set up on two columns. I want to be able to link the two columns to where if a choose one choice in column A it will only give me certain choices to chose from in column b. I am trying to minimize the size of choices.

Hi, how can i make a dropdown column containing calender to choose date

Hello, I have an excel data where I update one row (with multiple columns) each week. During plotting, I go back every n weeks (n rows) to generate average plot of each of these columns. It is difficult to manually choose n rows everytime I update a new row. Is there a way to automate this so that once I update a new row, a plot is automatically generated going back n rows from this new row? Thanks!

is there any way to filter out two column data in a single formula and meanwhile calculate the total numbers of products in the second column based on filter applied on column one.? In this file I have to choose the month May and need to calculate the PF10 within this month.

I have a workbook with multiple sheets. One sheet has a list of situations that may occur in one column and a drop down menu with a blank or X in the adjacent column. If you choose X then the situation occurred. If you choose blank it did not. On a separate sheet within the workbook, in one cell, I would like to a string of only the situations that have X values chosen from the drop down menu (i.e. "Situation 1, Situation 2, Situation 5, Situation 8, etc."). I can't seem to get the formula correct. Any advice?

I need a formula to choose the cell that has the word pending and if not go to the next cell of choice until it shows pending

i have a 120 question excel sheet with 3 possible answers to each: YES NO N/A how do i set it so that they can only choose one of the answers for each question, disable the other 2 answers from being selected once a choice is made?

i want a to create a button that when clicked on you can choose a pdf file to embed into a single cell, i want to avoid colleagues choosing the insert.... object...method in excel

I have a 10000 rows and for each row I have a dropdown list from which I can choose, x, y ,z. Now I want to add a filter 2 rows above that 10000 rows that says, show: all, x, y, or z. I also want to prevent that my excel becomes to slow as this is the case with some vba code.

I am using excel solver to choose three out of 14 potential facility locations, based solely on transportation costs from 10 existing warehouses. My constraints are a limit on the number of monthly trips to two of the locations and I also have a couple sites that can't be serviced by certain warehouses. I am having trouble coming up with the min if formula to use.