advice

  1. M

    Sumproduct - Returning #value

    Hi, As I deal with lots of data with multiple identfiers in my cost models I generally use Sumproduct and have done for some time. I have an issue though which i think I have identified as one of the labels in the Sumproduct formula that returns the #value. Formula is...
  2. X

    Hotkey to switch between sheets? - Simple Question!

    Hi there,I'm trying to work out what the Hotkey is to switch between sheets in excel.For example there is Alt+Tab for switching between windows, Ctrl + Tab for switching between open internet tabs, surely there must be a way to switch between sheets in Excel too, right?Thanks in advance for any...
  3. J

    Looking for a tip/shortcut..

    I am working with a number of (weekly) tabs within Excel and find myself going back through these tabs to look at information. So say I am looking at 'Bricks' (column B) which has a code of 025 (column A), is there a way of making all the tabs locate this cell without me have to scroll to the...
  4. R

    Chart Advice

    Office/Excel 2007 Would like to create a chart comparing: -average attendance as a # over 7 year period (which declined) -membership as a # over 7 year period (which increased significantly) -with % of members attending over same 7 year period (which declined significantly) Not sure what type...
  5. M

    Sorting Info from a WS to multiple Worksheets..

    So, I use to be a lot better with Excel, but it's been quite some time, and I'm in Dire need of help. Here's the issue: I have a spreadsheet with 12,000 contacts in it (name, email, phone number, country, industry, etc etc). The sheet is kind of messy, and I want to clean it up. One way thing...
  6. X

    Auto resize specific collumns

    i want to make collumns 1-14 And 16-32 To Automatically resize to fit in any additional text added (E.G. collumn 17 currently has 144 in most collumns, but am wanting to change one to 1475963 which will not all be shown in that cell, I want to cell to automatically enlarge to beable to show it...
  7. X

    Not enough conditional formats

    I recently tried to create conditional formatting for the following If cell = CB turn Yellow Black text bold and itallic If cell = S/Lit turn Bright Green Black text bold and itallic If cell = NI turn Gray 40% Black text bold and itallic If cell = email turn Aqua Black text bold and itallic If...
  8. X

    Advice on a formula please

    Hi there, Im pretty new to using formats on databases so I hope you can give me some simple advice, if it gets too tricky though I have a techy I can speak to. Here's what I'm trying to do In column AC I have a date column And in AE I have a comments column And in each row I have a...

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