The app will quickly perform all math operations on your data. You can then pick any function from the Show results for drop-down list to see the needed calculation results. Sum – add all the cell values. Count – count the number of cells. Average – determine the average of the values. Min – see the highest number. Max – show the lowest cell value.
Hi All, first post here and have already used the search for some valuable advice and hope someone can be kind enough to help with the following: I need to create a drop-down (or a combo list) list based on a column in a separate worksheet (in the same workbook). The values in the column have many duplications, and I simply want the combo box to return a unique list. After trying this using various options like drop-down boxes, combo boxes etc it does not seem to work. A drop-down box will return a complete list (including all of the duplicates).
In addition the drop-down was linked to a cell and the value returned to the cell was a number based on the position in the list when what I actually wanted was the text. For example - my list in Worksheet 2: PETS Cat Dog Dog Cat Horse Rabbit. In Worksheet 1 if I choose 'Dog' from my Combo box (or drop-down) along with showing all of the duplicates it returns '3', instead of what I want 'Dog' and no duplicates. Can anyone point me in the direction of what else I could try? Hope that someone can help, please. If needs be more than happy to post a small file if it would be useful. I am using Excel for Mac and have both the 2004 and 2008 versions.
Using the 2004 at the moment though owing to the VBA and Macro support (not good taking this out of 2008?!). If needs be I would be prepared to switch to Excel for PC and have the 2003 version (just noticed how many times I have purchased this software!!) Many thanks in advance for any help, Mike. We process personal data about users of our site, through the use of cookies and other technologies, to deliver our services, personalize advertising, and to analyze site activity.
We may share certain information about our users with our advertising and analytics partners. For additional details, refer to our. By clicking ' I AGREE' below, you agree to our and our personal data processing and cookie practices as described therein. You also acknowledge that this forum may be hosted outside your country and you consent to the collection, storage, and processing of your data in the country where this forum is hosted.
Bottom line: Learn how to create cascading or dependent drop-down lists (also known as cascading validation) in Excel. This technique does NOT require named ranges. If you don't mind using named ranges then there are a few of the page with solutions that will be easier to implement. Skill level: Intermediate Functions used: OFFSET, MATCH, COUNTA, COUNTIF, INDIRECT Drop-Down (Data Validation) Lists Before we dive into dependent lists, if you are unfamiliar with drop-down lists in general (also known as data-validation lists), I strongly suggest you check out my and also. What is a Dependent Drop-down List?
0 kommentar(er)
