formula help

Hey there, Basically I have a tedious routine process that I think can be simplified by having excel do it for me in a formula. Only issue is that I'm not too great with these. Any help would be greatly appreciated!! The process is as follows: I receive a spreadsheet everyday with many...

Hi, Can any one explain how to convert an excel content to html form which will help to code in macro. Ragrds, VK

Hi all, I have the following fields of data: A2 'values': (shows the value 'low', 'mid' or 'high) B2 ' ratings': (shows a value rating of between 1-5) I need a formula to populate the %'s in the table below, based on the rating and value. I.e. If Rating is 1 and value is 'low' show 0, if...

Network Days & IF StatementsHi Guys, I hope you are all having a great friday I was just wondering if anyone could help me combine the power of Networkdays and IF Statement so currently I have a start Date In A1 and End Date in B1 then either AM,PM Or Full in C1 with the days total in D1...

I am needing to calculate holidays that I can use as part of the workday function. I used the following formula for Thanksgiving but need help understanding what it is doing so I can calculate these other holidays. =DATE(C2,11,1)+21+CHOOSE(WEEKDAY(DATE(C2,11,1)),4,3,2,1,0,6,5) --C2 is the...

Hello. I need help creating a formula to compare and look for items between sheet1 and sheet2 below. Sheet1 is a report I can run to see what lines currently exist in our system. Sheet2 is an example of what the monthly invoice looks like. I need to determine what the line numbers are (from...

Hi, I am working on combining a list based on an unique Account ID's. But the formula needs to be case sensitive. I have tried the following formula but continue to get an error no matter what I do. I have never used an index formula before so this might be an easy fix that I am just not...

Hello, Is there a way to setup an excel formula to provide a day outstanding number? I need it to do the following: Subtract Date requested from todays date unless date responded is filled in. Thanks in advance, Grahfchart

Can anyone help with this formula? Its beyond me, but I have been told it can be achieved with Excel, I need a formula that I can input information to a specific job number, so when i change between jobs the information is store individually to the specific job number not sure if this a pivot...

Hello, I am trying to find a formula that will find the difference between two columns but ignore negative numbers in any of the columns. Column A ("Gross Reserve") is a reserve for an insurance claim (the amount we expect to pay) and Column B ("Amount Paid") is the amount we have actually...

Hello, I have a series of names and values assigned to each of these names. I need to add "all" the values assigned to the same name and post this total in each of the rows. Please see the example below - I have to add all the values from Line amount and Tax amount for each contact and input...

I am trying to summarize available inventory for certain projects in a new document. I have used SUMIFS to total the number available using three criteria: Species (Column D in my inventory document and column A in my summary document), Zone (Column A in my inventory document and column C in my...

I need a countif function involving certain items and date range. I figured out the first one but the next one and two after are giving me trouble. I have the first part of it where it draws the first item but help with the section. I need a countif function where the range is list of dates...

Hello, Thank you very much in advance for any help you can provide. I REALLY appreciate it! I am looking for a formula that will calculate the values that currently appear in column D below. Specifically, I need the formula to calculate the total number of current group members with whom each...

I have 2 columns of data. The left column is whether the individual has good or bad behavior. The right column is whether the individual had a positive or negative experience in the emergency room. I have this formula below, which tells me if the one individual had both bad behavior AND a...

Hey there, I am trying to understand how to create a formula that would pull what I currently have in the Input Cells automatically when I update the other spreadsheets. The cells will change as I update, but I still want it to give me the sum for what I am asking for. For instance, on the...

Hello, I am using a table that contains these three columns. I want to be able to identify them as individual records (1,2,3...). Separate line items could have the same value for two columns, but one of these three columns values will be different (bottom row of example). I am going to be...

Hi everyone, Today i gave my MOS Exam 77-420 : Excel 2013. i scored 980/1000. overall the exam was easy. i got 100% in all objectives except 90% in 'Applying Formulas & Functions'. I know where i did wrong. But i still can't figure out how to solve that problem because of which i couldn't score...

Long time lurker of this forum, so I already owe many thanks but I have one issue I wasn't able to find... Have a Pro-Forma I made which has months (in text) in the 3rd row and cumulative cash flows in the 50th row. What I would like, is to get a formula which dynamically returns what month I...

Hi, I've read the previous posts however none have really been able to fix the problem I'm having. I have a shared spreadsheet that colleagues use daily (MAILBOX LOG), however I want a master spreadsheet that will pull data from each worksheet withing the MAILBOX LOG worksheet. The current...