options

I want to set Iterations on my worksheet but when I click on File/Options I am immediately returned to my worksheet.

When I rt click a column or cell and set the format for time and date and enter [4-25] I get [1/13/1900 12:00:00 AM] in the address field and [4/25/19 0:00] in the cell. First, why are the options grayed out; they seem to be working otherwise and is there a way to get the program to plug in...

I have downloaded the add-in, extracted the add-in to the Add-ins folder, UnBlocked it and installed it in Excel. I have a menu option called "MrExcel HTML Maker". On that ribbon is one group called "Generate HTML (Specify Options)". The options listed are: All Formulas First Cell Only First...

Hi all, While I've performed simple Macro's in the past, the relative complexity of my current project has me a little stumped! I have created dependent drop-downs that display varying options of which users then score. I am wanting to paste these answers into the next worksheet, with the...

Hi, Please can someone help me? I have a userform called OPTIONS. I have 6 different options on the userform. What I would like is if an operator selects an option it counts the number of times that selection has been selected in a textbox on the same userform. For example: If...

Hi there, I have a spreadsheet that connects several slicers to pivot tables and their associated charts. Along with the data slicers I have a timeline connected to all of them as well. When a slicer selects one or more field options, other surrounding slicers will visually indicate which...

Does anyone know of a way to keep notes on what each step does in Power Query? When I write VBA, I write up a detailed explanation of what each line of code does so if anyone needs to modify it they can understand the method to my madness. The closest options I can find in Power Query are...

Hi, I have a cell that requires user input. I would like there to be a drop-down in that cell that would allow a user to select some potential options. However, if the options don't work for the user or they want something else, they would still be able to type in whatever they'd like without...

Windows 10 v1809 Excel 2010 I'm struggling to simply fill a column with consecutive dates for a month, ie Fri 1 Mar 2019, for some reason. I've done this many times before but, today, this just won't work properly. I've checked with Google but the links all same the same thing, ie type date...

I have 8 excel sheets (basically all quote sheets that have product listed with options that can be added on listed by category. I.e. Product lists are Truck, Car, SUV - Options Categories are - Radio, Interior color, Exterior color Then each category has multiple options to chose from I...

I'm using Excel 2016. I have always used Ctrl + F to find a number on a spreadsheet. Now, whenever I try to find a number on a spreadsheet (that I know is there) by using Ctrl +F, a dialog box pops up and states, "We couldn't find what you're looking for. Click Options for more ways to search."...

Hi Everyone, I am using Microsoft Office Professional Plus 2016 and Inoticed I am missing some features inside of Power Query. I came across some ofthe missing features while attempting to merge two tables. The merge button inthe queries button does not have the drop down feature to allow the...

Looking to sum a column of values based on: - Direction of service (options are North, South, Both, based on filter value in cell) - Journey (noted by OD) (starting location and final destination) (options are All or only one, based on filter value in cell) - Start time of journey (options are...

My present coding moves information completed on a UserForm to a Spreadsheet. Individuals may need to update the information submitted so if they submit another form, I require a search to happen by the PRI number and replace the old information with the new information. For example.... If the...

Hi, I've been using the following formula which is working fine for my current needs :- {=MAX(IF(ISNUMBER(CB:CB),IF(A:A="Set 107",CB:CB)))} I now want to add another criteria to this function after A:A="Set 107" to B:B="Ready" I've tried various options but am not getting the correct answers...

Dear Experts, I am wondering if there is a way to set up a Slicer to return records ONLY if they have ALL slicer options selected? For example - I don't want to see records that have slicer options 1 OR 2 OR 3 etc. but records that have slicer options 1 AND 2 AND 3 etc. ? Case Scenario...

Excel 2016. Hello Excellers. Here is the 'stupid question du jour'... is there any way to loop through the list of currency options using VBA? I'm referring to the options when you format a cell, click currency and then you get a long list of options (currency symbol and region). I'm wanting to...

Hi All First time poster, and very new to excel, so please be kind. :) This may be a simple question for most of you, but as I'm relatively new to everything in excel bar basic formulas, I'm struggling. Been googling this for hours and can't find an answer (or don't know how to word in...

I'm looking for a formula that will break out all values associated with a specific reference. Below shows a single reference ID but I believe I'll be using 2 for this project. Any help is GREATLY appreciated. ******** language="JavaScript"...

We receive updates from our supplier in the format below showing products we have ordered by stock number and the options we have chosen against each product in a // delimited format. So the data looks something like this except there are around 50 available options and typically around a dozen...