asap

  1. S

    Average groups of numbers within a larger group

    I have a large group of numbers in a column. I would like to average those numbers in groups of 7. So average the first 7, average the 2nd 7, and so on down the whole list. Is there a way to do this without manually selecting each group to find their average? I have Kutools and ASAP utilities...
  2. L

    ASAP utilities

    Hi All, Have tried to install newest version of asap utilities. Does not display on tool bar. When I go Tools>>Addins>>Browse and select the asap utility it says it is not a true addin?:confused: Any suggestions? Forgot to mention I use Excel 2003 but I have Excel 2013 on computer. The ASAP...
  3. S

    searchable database

    need to create a searchable database for website which has lot of photos please help me ASAP thanks
  4. I

    CONCATENATE till Blank Cell - Kinda need help ASAP :(

    Dear Excel Genius, First, I would like to apologize for this urgent question. I will have a meeting in few hours and I would need this part of VBA for my Report. This question probably has been asked... and asked... but... im kinda stuck somehow... Dim i As Long i = Range("F" &...
  5. P

    How to keep the excel window 'Always on Top'?

    Hi, We decided to automate the ASAP Utilities' Functions through our code. I believe we don't have a decent choice but SendKeys. So as SendKeys has a global nature in sending the keying events across applications, It is better if we have a total control on the active window. Is there a way to...
  6. S

    Troubleshooting Complex Nested If and If Functions

    I'm having an issue with my nested if function. What I would ideally like to do is to compare 2 cells against a confidence interval percentage. So, if cell A is 5% higher than cell B I want my function to create a label the next cell as "Higher" and if its 10% higher than to be labeled as "Much...
  7. S

    Need someone to make Excel SpreadSheet for me

    I am an Instructor and do classes that have there own profit and loss per day. Also for different companies. I want a spreadsheet created for me where I can enter company name and info and expenses (both total and per student), along with profits per student and total, plus a profit calculator...
  8. P

    should be simple...but

    i am on a tight deadline and after weeks of crunching data i would hate for this task to fall apart over simple formulas. i need to know if i can select 1 column and subtract the value in another column from it, and have the total displayed in a seperate column. the only trick to this is that...
  9. P

    I have a very specific question about excel, please help!

    I am trying to combine the VLOOKUP and the IF functions in a different kind of way...I made this formula, and in theory it should work..buuuuut..in reality it doesn't. this is my formula...I want it so that if in the cell G2 there is a certain name of a company then the result will be just...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top