help me

  1. J

    Macro Button Not Working Properly for Other Users

    Hi all, I created a workbook to keep track of issues with my software which contains all of our tasks. I then created a separate spreadsheet in another workbook to keep track of everybody’s issues to get a feel for how much bandwidth they had. To do this, I created a table in their separate...
  2. M

    Index and Match Help needed

    Hello, I am trying to put together a yearly calculator, and would like a formula to calculate my total from year beginning to year end. Below is a small sample of data. I'd like each group to show a total number when queried against the year column since I need to calculate total ACD Calls...
  3. M

    VLOOKUP removing HYPERLINK

    Hi y'all, I'm trying to put together an error response calculator with hyperlinks and having a little trouble The links live in column b beginning at row 5 and below along with error codes in column a. For example, <tbody> 23456789 Shortage of Data </tbody> B2 is where I would like the...
  4. A

    How to create a mail merge with excel - Help?

    Hey, I am wanting to create an invoice for the customers which have placed an order with my system, the invoice will be created on Microsoft word, and printable. It should contain the data from a specific sheet called "All_Orders" in my spreadsheet. How would I create a mail merge between these...
  5. K

    Keeping Blank Columns when applying a slicer to a table from PowerPivot

    Hi, I have searched everywhere and cannot seem to find an answer to this issue. I have a couple of pivot tables built from a powerpivot query of a database on one of our servers. These tables are showing similar information so i have applied a couple of slicers, such as owner and business...
  6. K

    Calculating difference between dates and times

    Hi guys, I am trying to calculate downtime between two dates. Taking the first as example: Outage started on 1st and ended on 19th. Now Between 1st and 19th, I only want to calculate outage from 10:00 to 20:00 (support hours). Taking the second row as example - clearly on sunday (5th Oct)...
  7. P

    Run-Time Error '438' - Object doesn't support this property or method

    Hi, I'm getting a Run-Time Error '438' when trying to sort some data. I've read some of the previous forums hinting at a compatibility issue between excel 2003 and 2007, but that isn't the case here. The sample code is as follows (A few lines may look wired b/c I was testing out ways to...
  8. D

    Array Formula with multiple criteria

    <br> I have been using this array which works. But now I want to introduce multiple criteria.<br> {=MIN(IF($X$2:$X$3550=B3,$AA$2:$AA$3550))}<br> <br> This formula returns the min date from AA if X and B have the same file number. What I also want to introduce is column Z which is a status...
  9. C

    Create a multiple nested IF statements

    Hi there, I am new to this forum (1st Post) and also new to excel. I am currently doing my bookkeeping course and i am stuck on a question and need some help. The exercise asks me to create a multiple nested IF statements (with the average function nested in the IF statement) in column F to...
  10. C

    For each... in doesn't loop properly

    Hi everyone, this is my first post so I apologize in advance for any mistakes I can make posting. Here's my problem: I wrote a macro to loop through a range of cells and then, if the cells' value is more than 0, to copy the cell and the adjacent ones to another sheet. The problem is that it...
  11. E

    how to skip empty cells

    <tbody> 33 K 60 L K 77 L 68 J </tbody> HI everyone i am using this formula =IF(D4>70; "J"; IF(D4<50;"K";"L")). Do you have any suggestions what to do with the empty shell?i have the letter K appear when what i want is to jump the empty cell.
  12. C

    Search multiple cells for keywords, and display a result based on which word is found

    I have found the formula below which half applies to my problem. This displays the correct word, depending on whether cell A1 contains that exact text only (cat, dog or mouse). =VLOOKUP(A1, {"Cat","Purrs";"Dog","Barks";"Mouse","Squeaks"},2,0) However I want it to display purrs, barks or...
  13. L

    Indirect function help

    Hi all I am using the following function to return a value form another worksheet. There will be there will be X20 versions of the same thing repaeted X52 times, as it is part of a calculations page returning values for various things over a year. to speed up my writing and help allow for...
  14. E

    Looking for options to resolve performance issues in Shared Workbook

    Here's the situation: I've got an XLSM workbook in a shared network folder which is a trusted location. It's a shared workbook used by up to 7 different users at any given time; Office versions include 2007, 2010, and 2013. The workbook is slow to open, save, close, and run the macro...
  15. C

    Excel similarities and differences to SAS/SPSS

    Okay, so I currently work in the financial profession, and through this I discovered my knack for/love of MS Excel. I feel very confident in my abilities having built several financial calculators and models that many members of my office use and enjoy. My problem is that I'm moving and I'm...
  16. A

    Help with saving a Final date with logic statement

    I have a workbook that is titled "Results". It has 2 columns that I need help with, a 'status' column (B) and a 'finalized date' column (C) Column B is the 'status' column: Formula: ('[May Database]Summary'!$B$1) The May Database B1 column is a dropdown with options "In Progress" and...
  17. E

    Splitting one document to many and saving to pdf

    Hey Guys, I was wondering if there is a way to accomplish this in VBA? I have an excel document that I use mail merge to create a bunch of different reports. After completing the mail merge I want to be able to save each individual file as a pdf. Currently I am using this to split the pages...
  18. A

    need help with a VLOOKUP formula

    i need help with some formulas for this sheet i need to create basically what i want the sheet to do is to locate the names in column 1 who have value greater than x in column 2 and then reflect it into a new tablet now i'm very open minded like if there will have to be several sheets or if...
  19. M

    Updating cell ranges Dynamically

    Hi All. I am working with an excel document that will be updated periodically, with additional information being input from time to time, which will expand the amount of cells in the current database. I have a pivot table which needs to be updated, and needs to include all the information...
  20. A

    Find and Replace bug - Can not look in values

    Hi everyone! First time poster here, I do apologise if I contravene any forum rules. I am having trouble with missing aspects of the Find and Replace function. The Find function allows me to look in Formulas, Values and Comments, but the Find and Replace function only allows me to look in...

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