Get instant live Excel expert help to learn how to use Choose function in Excel
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
Suppose I have a drop down list. What can I do that will help me update the different columns depending on what i choose from the drop down menu.
Solved by O. W. in 22 mins
the Data worksheet:
a. Create an Excel table with the recently imported
data.
b. Pick a style with the styles group to format the table
(choose a style that shows banded rows, i.e., rows
that alternate between 2 colors).
c. The style must highlight the field names in the first
row. These are your table headers.
d. Ensure NO blank cells are part of the specified data
range.
e. Ensure that Header Row and Banded Rows are
selected in the Table Style Options Group Box. Do
NOT check the Total Row.
Solved by C. L. in 12 mins
I have 2 sheets. One sheet with the demographics of contractors. eg. Company A, Hispanic, Male. In the second sheet I would like to be able to choose the company from a drop down menu (listing all companies) in column A and have columns B and C automatically populated with Hispanic and Male.
Solved by A. Y. in 17 mins
Submitted sheet with this question have separate sheets. There are QAD inspectionStock reportData entering sheet etc. • QAD inspection to be used as a Data entering sheet, as a separate Date Wise. • If someone need to entering the data, he needs to choose date from “Inspection done Date “column. • Due t
Solved by K. C. in 18 mins
Click cell C21, start an index in excel, and select the first argument list option.
e. Choose the Responses range for the Array argument.
f. Click the Row_num box and nest a MATCH function. Select cell B21 for the Lookup_value and
cells A3:A28 on the Mailings sheet for the Lookup_array. Click the Match_type argument box
and type 0.
g. Click INDEX in the Formula bar. Click the Column_num box and nest a second MATCH function
to look up cell D3 on the Mailings sheet in the lookup array A3:D3.
h. Click the Match_type box and type 0
Solved by C. F. in 22 mins
I choose "list" on the data validation window. Next, I press F3 to introduce the source, but the F3 key is not working. It just changes the brightness of my screen instead. Please help me with how to get the F3 key to work.
Solved by A. F. in 21 mins
I made a spreadsheet to compile data for 2 different types of scenarios. The first is the Task, these are customers sent from CS Reps (Customer Service Reps) to my team (Sales Reps). You can see what I am looking to track. The second group of data are the HOUSE ACCT phone in orders transferred to Inside Sales. You also see what I am looking to track from this. I put together grids with data validation to more easily choose reps and outcomes but i know that you guys can do something much nicer and more efficient. On the side you will see October totals. These are the totals that to have incorporated for each month as they accumulate.
Solved by Z. Y. in 25 mins
Hi !
I have a table on excel and I have to realise this instruction:
4.1.3. Display the averages of each column
• Click Total cell (D10), a drop-down list appears, proposing several types of calculations:
• in the drop-down list, choose Average
I do not have any drop down list when I click on the cell D10.
Could you please help me with that ? (on the enclosed excel file, I am referring to the disease sheet)
Maxime.
Solved by M. F. in 21 mins
Trying to make a line graph, it won't let me choose x-axis and y-axis
Solved by A. S. in 11 mins
I'm trying to create a Pivot table from multiple tables but I don't see the option box that allows me to choose to analyze multiple tables.
Where can it be?
Solved by B. H. in 21 mins