definition

  1. W

    excel macro

    excel problem definition has been described briefly in the below snapshot. https://www.dropbox.com/s/0v7duejb726laws/dear%20mumps.jpg?dl=0 Thanks & regards.
  2. V

    Excel file types - best describe

    Hi Team, Can any one best and simple describe me excel file types definition.. where user can easily understand the differences..
  3. M

    Editing SQL in excel

    Hiya, I'm looking for some help with SQL in excel. At work we are uning Excel 2016 and I am able to edit SQL code in the Definition tab, I've bought Excel at home to have some practice but pretty much the whole deifinition tab is greyed out, any idea why? I've connected to an example table in...
  4. S

    Identifying maximum values within a range of cells

    Greetings, I would like to identify a maximum value within a range of cells. I am currently trying the line below, but am not apply the correct syntax. What is the best structure to use for similar types of operations? Also, what rules surround the definition of the row and column...
  5. S

    Misbehaving Chart Data Sources

    This code is doing everything I want it to do, except the output is wrong. Specifically, when "chartstring" is defined, it is defined by the sheet "Summary" from a range spanning A2 to my desired column--but row 3 instead of 2 as is hardcoded into the definition! What's going on here...
  6. J

    Have a Month Drop down return a number value

    Hi, I have a drop down list defined in a sheet called 'List Box' which lists all the months Jan-Dec. I am referencing it in the main sheet as part of cell. I am wanting to return a number for the value selected for example 'March' returns a value of 03 when referenced in a function. This is...
  7. G

    Named Ranges changing unexpectedly

    I have defined three names that refer to 10 cells in different columns of a worksheet. For example Xn_Rev is defined as =Revenue!$F$27:$F$36 On another worksheet, I have created charts to display the values, and in the charts I refer to these names. I am finding that the names change...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top