feature

@ Admins/Mods, if this is not a right place to post a request, kindly delete this post. Age old Data Validation List in excel needs update. Feature like Search as you type/Filter List as per typed characters/Search Suggestions/Auto complete should be there. Google Sheets has this feature since...

I realise I am a little out of date Excel-wise as I have spent the last year and a half on Excel 2010 and found the Save Workspace feature incredibly useful (this after **** near 20 years of never having touched it before). As far as I can see it has been removed in later versions (I'm now...

Hi, Hoping someone can help please, Does co-authoring in excel online (document is stored in office one drive) support cell protection? Id like different users to have specific access to parts of the spreadsheet. But from what I can see this feature doesn't seem to work when editing the...

I have a list of data made up of four columns, Element, Feature, Attribute, Life Expectancy, an example would be fire access & security systems(Element)>cctv system(Feature)>recorded(Attribute)>25(Life Expectancy). Each one of the columns is related to the previous one, so if I was to select...

Hi everyone- I’m looking to develop a formula that used a two-factor formula to find results that will be listed out in one cell. Here is a snapshot of a file I have created: https://imgur.com/a/4Kc4tZN Along the top are a list of services. Along the left are a list of features...

Many questions: 1) Does this option behave differently in different versions of Excel? 2) Does it matter whether it is on Window 7 or Windows 7 or should it behave the same on both 3) Microsoft Help only explains the feature but offers no assistance on how to permanently deselect it by using...

Is it possible to highlight the entire row if 1 cell equals a specific value using the Conditional Formatting feature built in?

Hi, Q1- I want to add the 5-month stock & calculate the average stock. |I used consolidate feature in sheet 7 but "Item Description" & "Whse" field does not come in the field. Kindly tell me how to do that with consolidate feature & different function or which one will be easy. I gather all...

I am currently trying to paste some financial data from awebsite into Excel. However, each time I paste it even when I highlight a numbercells I wish the data to be displayed in horizontally it proceeds to paste itvertically. This is a very basic question but I am new to using Excel and I...

Hello everyone, My target is to generate the data filled in yellow. Basically: there are certain tests to be performed at certain dates (Table 2), and there are features that will take the results of the tests only at specified dates (Table 3), and a table saying which test is relevant to what...

Hi is this something I need to learn or these are old excel. I am using excel 2013. In the article below, the author said it is an old feature: "In Excel, it is possible to create a pivot table where data comes from several worksheets. It's an old feature, but still useful. The process starts...

=IF(Checklist!B27="","",VLOOKUP(A176,Features,2)) I have the above formula on my worksheet A176 has the value Feature 10. The Named Range is the following; <colgroup><col width="72" style="width: 54pt; mso-width-source: userset; mso-width-alt: 2633;"> <col width="64" style="width: 48pt;"...

I am trying to set up a formula using maybe the MOD feature in excel to show break downs for pay-out spots (Golf Tournament) for this example 1st thru 7th position. Total amount of money is $4,680 Finishing 1st 2nd...

Hi, I have received some data in a very odd format and need to parse it into something more usable. Column A contains Unique IDs (Product Codes). Each Product will have one or more features, denoted by an Identifying Feature Code. However, the data is formatted so every potential...

Greetings! I'm currently using excel 2016 in the office previous versions had a feature where you can view changes made to cells on a separate sheet. This would issue the user's name, date, time and cell number change but I don't see feature on the worksheet. Would anyone know where I can find it?

Hi, I have excel files. There are different sections in this file. There are different features under each section. Unequal weights are available for these features. The sum of each section is 10. However, if there are no features under a section, the weight of the non-features needs to be...

Hi, I’m trying to return a value from a large static table that includes a number of different parameters. <tbody> Feature 1 Min| Feature 1 Max| Feature 2 |Value 0.1 A 1 0.1 0.2 A 2 0.2 0.3 A 3 0.1 B 4 0.1 0.2 B 5 0.2 0.3 B 6 </tbody> Here’s an...

You can arrange your file in excel by using hyperlink, so when you click it the file will open. But if you share your excel through other device and want to open the file from that device, it won't open. Don't worry, you can embed the file so you can from other device by using this way : insert...

Column “A” has over 1000 rows of data. Is there a simply way to divide those rows evenly across 4 columns (B, C, D AND E)? Similar to using the column feature in Word.

I have to use excel in conjunction with some other software consequently I am always hitting the save button on excel. With my other software it saves all of my work automatically roughly every 5 seconds. I really love this feature. Does excel for mac 2016 have this feature it would really...