1. K

    Toolbar in excel not visible

    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
  2. M

    Limit Combo Box Selections / Custom Error Message

    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...
  3. T

    VBA consolidation of data

    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...
  4. Jan Kalop


    =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...
  5. M

    VBA to Check/Uncheck Checkboxes

    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...
  6. R

    MODE Array with Criteria - #N/A Error

    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 =...
  7. C

    Best way to set-up this form

    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...
  8. R

    Display options on form based on cell values

    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...
  9. MUKESHY12390

    Multiple workbook under one workbook

    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...
  10. P

    Printing macro

    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...
  11. F

    combo box question

    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'...
  12. F

    countif/countifs ignoring blanks

    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...
  13. V

    If and Else If to Insert Rows basis various Conditions

    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...
  14. D

    Nested if or function

    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...
  15. H

    Excrutiatingly slow insert/delete times using table and defined names

    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...
  16. Mazbuka

    Incorrect password input opens new blank workbook

    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)?
  17. G

    Excel Dashboard Course

    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!
  18. N

    drop down from IE object

    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...
  19. P

    Countif with index match where multiple columns match

    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...
  20. A

    Pivot Table - "For empty cells show:" Option Not Working

    Hi everybody - I'm trying to replace blank cells in a set of data with 0 in order to utilize the Pivot Table functions. For some reason I cannot get this option to work. I've simply clicked on Pivot Table Options - checked the "For empty cells show:" box and entered 0. I'm stumped as to why this...

Some videos you may like

This Week's Hot Topics