excel-2007

  1. E

    Trying to nest formulas/put them all in one cell but keep getting "too many arguments" error?

    Hi I been working on this on and off for nearly 5 hours straight and when I look at the it everything just all blurs into a mess so I would be very grateful for a fresh perspective or pair of eyes.? I am trying to combine the three formulas below in to one so that they are in the same Cell...
  2. L

    How to calculate total quarter wise

    :laugh:
  3. N

    Dynamic named range using a range within a range

    I have the following worksheet: A B C D E +-----+-----------+---------+--------+-------------+ 1 |FALSE|Lot ABC123 |Product 1|Used qty|remaining qty| +-----+-----------+---------+--------+-------------+ 2 |TRUE |Lot ABC321 |Product...
    • Nox000
    • Thread
    • dynamic range excel-2007 excel-formula excel-vba
    • Replies: 0
    • Forum: Excel Questions
  4. S

    I want to create a drilled down list of VPs for a set of managers matching with a provided list of VPs in excel.

    What i need to do is - 1. I have a base data sheet(Data) with user id(col D), Username(col F) and Reports to(col I) data of all employees. 2. i have a set of unique managers and their ids in a sheet X. 3. In sheet Y i have a list of selected managers and their ids which are not in sheet...
    • SayantaniB
    • Thread
    • excel & vba 2010 excel-2007 excel-vba excel-vba-mac macro code
    • Replies: 0
    • Forum: Excel Questions
  5. Z

    After any sheet moved out creating a new workbook, all macros assigned to the buttons in the old workbook automatically refer to the new workbook

    The rare and strange problem is observed only on one particular computer with Windows 7 Pro and Excel 2007. Let me try describing it step by step for better understanding. Step 1 There is a workbook test.xlsx. There are 3 sheets in it. There is a button Button 1 in the sheet Sheet1. The...
  6. N

    Excel 2007: If Match Found, Return Worksheet

    <TBODY sizset="0" sizcache06131772706928872="1943"> I have a spreadsheet with 2 worksheets. <CODE> 1 worksheet1 has 1 column of names "Smith, Bob" 1 worksheet2 has multiple columns of data, including the name.</CODE></PRE>I'm trying to find a formula that will find the names from...

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