help me

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...

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...

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...

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...

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...

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)...

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...

<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...

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...

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...

<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.

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...

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...

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...

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...

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...

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...

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...

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...

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...