choose

Hi All, I did an Excel update for MAC yesterday and I am having a few performance issues. I am using version 16.9 and my question is, can I roll back to the previous version? I have office 360 and I went on the website to see if there was a list of versions that I could choose from but I was...

I really dislike the new SQL/Query menu systems in this latest version. Is this an addon? I don't suppose there's a way to use the old style? I'm not even sure how to save my connections.. I don't like how it loads a preview of the data, I just want to see a list of available columns in the...

I have 4 different charts to display on a page. I can only display one at a time due to the volume of data. A dashboard with all charts would be too small to read. I would like to use a drop down list to allow the reader to choose the chart to be viewed. I've worked with drop downs for lists...

Hi I would like ask how is possible to write macro which will open (create) some "box" or bracket with two possibilities. This two possibilities will be conected to different macros. Then when I will choose one option this box will disapear. On next time when I will activete this kind of...

Hi, I'm trying to create a drop down list with value changing in excel 2013. Basically the goal is when I choose an option from the list, it changes it into a number. The drop down list will be in a column that represents cities. I want to define numbers to the cities so when I go to a cell...

Hi everyone, I'm trying to create a drop down list with value changing in excel 2013. Basically the goal is when I choose something from the list, it changes it into a number. Is it possible? Thanks in advance, Liran.

Normally when I type out code, VBA auto-populates some information for me. For example, when I type me.txt, it will show me the fields that I can choose from. For some reason, it's not doing this anymore. Thoughts on what setting I need to adjust?

Hello, I have a code extracting values from a pivot table. My main filter is called INVESTMENT NUMBER in the pivot table. The information in that field is a short code in the format: XXXX.XX When I generate the pivot table, there can be dozens of numbers in that field, normally I choose the...

Dear All My data set is given below. I want to get the maximum value for "Package 1" highlighted in RED, BLUE and the middle column is just BLACK. So the output should be 0.69, 0.59,0.96. There are other packages too. The next one is Package 11+14, for that the answer I want should be 0.54...

For some reason I have 2016 excel. When I right click ribbon and choose Customize the Quick Access Toolbar. Then under Choose commands from: I select Macros the excel sheet stops responding. I am trying to add my icons for my macros and cant. I did restart computer but same problem. Anyone know...

We all know how CHOOSE Works eg. If I had month number and I wanted to convert them into Month name then I'd be using Choose ie. MonName=CHOOSE(Monno,"Jan", "Feb", "Mar", "Apr", "May" "Jun", "Jul", "Aug", "Sep", "Oct" "Nov" "Dec") But what my query is that if we were given month names and were...

Hi, I need some help with dropdown lists and populating cells based on index function. I have a sheet with tables of data and I would like to use two dropdowns (one to choose which set of tables & one to choose which table from the set). Based on what gets populated in the dropdowns, I would...

Hello All, I need a Yes or No message box (which reads: "TEST") If I choose Yes, then the program runs. If I choose No, then the program exits, and the program does not run. Thanks for the help excel 2013

Hi, Is there a function in inputbox that would let user choose 2 columns separately for comparative analysis? I can have 2 inputbox method that will pop up simultaneously but I want it just one inputbox that will prompt and can be editable until user will click on OK button. Or it can be a...

Hello, I'm having trouble correctly combining two Excel functions into one string. My Choose Function is operating correctly. I would like my formula to read: Choose(2010,2011,2012),IF(1=S, make it S, if not make it 0). Any help is greatly appreciated. CHOOSE Function...

A few weeks ago my Excel 2016 simply refused to make a new pivot table, but only if I select a new sheet. If I choose Existing sheet I am good, but if I choose new sheet Excel stops working and tries to recover my data but fails every time. Is anyone else having this issue? I can't find anything...

I just saw that someone used the option of using vlookup with choose nested inside it to look at fewer columns and look left. I know I've been told many times that index match is a great option for this because it is quicker and more efficient. Now, I am wondering which is more efficient if...

Hi all. I am using a CHOOSE function to locate the name of the correct month and "months ending" based on the number month I type in. On my "instructions" sheet, I type in numbers 1-12 in cell K1, and my CHOOSE function on another sheet locates that numbers and returns the month that it...

I have mutliple worksheets that have the same cloumns (date, item, description, status). Now I want a "master" worksheet from where i can view the data in all the worksheets if i choose. How can i achive this in excel. I am a programmer so I'm open to doing this in macros.

To be honest, I don't even know how to explain this fully in words, hoping the table will illustrate the dilemma. I have a data validation list in column F, with the appropriate selection made in cell E2 e.g. "white" in table 1. Table 1 <colgroup><col style="width...