options

I have had this issue for awhile and can't seem to fix it. When i have table set up I will occasionally enter data on the next row outside of the table. The table auto expands as it should. However, i later realize that i don't need the new data i entered and delete. In order to make sure my...

Dear All, I have a file created by an external in which the toolbar is hidden. I have no options to bring it back. Do you have any ideas. Thank for he support. regards Klaros

I have a Combo Box on a User Form with a dynamic items list (gathers the item list from a spreadsheet based on active cell value when the user form activates). How can I make it so that the user must choose one of the options from the Combo Box (no manual typed entry)? IF manual typed entry...

Good afternoon everybody I have a very large table (14000 rows) of contract data, an extract of which I've simplified here. Each row in that table has a contract identifier ("ID") which may or may not be unique, depending on the complexity of the contract. Within each row, there may or may not...

=INDEX(F$44:F$79,SMALL(IF($S$44:$S$79=$S$42,ROW($S$44:$S$79)-ROW($S$44)+1),ROWS($A$1:A1))) It is possible change above formula in section =$S$42 to options biger and smaller at the same time (for sample >$S$42-3 and <$S$42+1) Both below are obviously not working...

Hello guys, I've written some VBA to control some checkboxes but it's causing an issue that I can't quite get my head around fixing and was wondering if anyone here had any ideas. So basically I have a stacked bar chart. I have a list of options (about 20) that can be individually clicked to...

Hi, I am getting a #N/A error with the following formula: {=INDEX(INDIRECT($B$25),MODE(IF(INDIRECT($B$7)=$B$2,IF((--ISTEXT(INDIRECT($B$25)))>0,MATCH(INDIRECT($B$25),INDIRECT($B$25),0)))))} $B$25 = 'Sheet1'!$K$2:$K$1137 Text categories with three different options (R, S and K)$B$7 =...

I am trying to create a form in excel. With certain questions the user can select multiple options. For instance: What type of fruit would you like? (I used an active x combo box for this) No Fruit Apples Oranges Pears Grapes I want the user to be able to pick multiple options at once...

Hi all, I hope this is possible, what I am building is a skills matrix, which will have an X in a cell, if someone is trained in a set task. What I would like to know is that, when someone logs on, by supplying their employee id, zbc123, it looks in the list for their name and then see's what...

Hi all, today I have observed strange thing, while writing code I usually see just one workbook ( Thisworkbook - with excel icon) under VBA project. I don't know what happened now I can see two workbook ( thisworkbook and Output workbook). it seems sheet got convereted into workbook. Is...

Hi there I'm not sure if this is possible or not to do in Excel. Is it possible for me to set up my printing options first and then run a macro to print out the data that I have chosen before hand. I could have chosen only a selection or the whole worksheet etc. I know that I can record a...

Hi, Ive only been working in Access for a week so please be gentle :) This will probably be a silly question but here goes..... Im trying to create a search filter using a combo box in my access form. I have a table with multiple records. One of the table fields is called 'report type'...

I need the percentages of values where it is greater than or equal to 0, however, for each column the value is different and to get the values I have used an index match formula so all cells have a formula which is causing the issues. So far I have tried...

Hello, I have a Column with 1, 2 and 3. The number of 1s, 2s and 3s can vary. Also there are 6 combination Options in which they can appear, grid below. I need to insert Rows after last 1 and last 2. If the result is only 3 Option F below I need to proceed with the next step. <tbody> Options...

I have a nested IF OR formula, but both of the criteria to evaluate has the same result. My formula is: <colgroup><col width="64" style="width: 48pt;"> <tbody> <colgroup><col width="64" style="width: 48pt;"> <col width="76" style="width: 57pt; mso-width-source: userset; mso-width-alt...

I have a file that is taking longer and longer to insert/delete/move cells/columns/rows now up to at least 10 minutes EVERY SINGLE TIME! I have tried absolutely EVERYTHING that I can find and am at my wits end. I started from scratch to create a budget model that would provide forecasting...

Hi, Very small issue but it annoys me...if I type a password in correctly, a new book opens, which I then have to close. I can't see anywhere in options to disable this...can it be (disabled)?

Hi, I would like to sign up for an ideally inexpensive online course covering Excel dashboards. There seem to be lots of different options including quite a long list on Udemy. Is anyone please able to recommend a good online course? Thanks!

Hello All, I have a site i am going to and it contains 2 drop downs. The selection of the first drop down triggers the options available in the second drop down to change. for example: drop down 1 could be Blue Red Green if blue is selected then drop down 2 will be A B C if green D E F...

I have a data matrix which has order information running vertically, and cost options running across the top. If the order has the option then it shows the optionvalue in the corresponding cell, otherwise it is blank. On a separate tab using the following formula I am able to do a count foreach...