raised

I'm scratching my head with this conundrum I have two similar reports that mine the same data which lists transactions. In my first report I have a column which shows the date of the last invoice raised to a customer: {=max(if(Retailer=A1,InvDate,"None"))} In my first report, if there...

help please, I'm trying to write a formula in the cells in yellow which will 1. in column D count the total number of unique POs ("purchasing documents") raised which fall under Group A (cell B5) and are within the range B7 to C7. 2. in column G sum the total of POs raised, it is ok to count the...

I'm trying to write a formula to work out future potential monthly revenue based on contract start dates and their associated payment terms and value... hopefully someone can assist The input cells would be: Column V from cell V12 is the contract monthly value Column W from cell W12 is the...

Morning, Afternoon or Evening All, Now i am not sure if this is in the right area but it is based around excel. I currently have a excel file which is designed to work on a touch screen where a user scans in a serial number then touches different pictures to highlight issues with a product...

Hi, Am hoping that you guys can help. I am looking for a formula that shows if cell c8= Smart and cell j8 time is less than 4:00:00 them put Met SLA but if j8 is over 4:00:00 put Failed SLA and if C8= Customer raised ticket or Public raised ticket and j8 is uner 0:30:00 put Met SLA and if J8...

Hi everyone, Fairly new to Excel so apologies if this is a simple question! I'm looking for a formula to highlight a cell based on the date within another cell e.g. <tbody> Date Raised Follow Up Required 12/11/2017 Yes 30/11/2017 Yes 26/11/2017 No </tbody> If the line has been 'open'...

Need help setting up thermometer chart Goal to raise: $4000 (Cell B1 Raised so far" $2000 (cell B2) % raise: 50% (Cell C3) Thermometer chart to show 50% or thermometer adjust as % changes in cell C3. Any idea how to do this? I need to have one scale shows % raised and I need secondary scale...

I have 3 columns - Job No, Date Raised, Fee On a summary sheet I want to find the minimum Job No that has a Date Raised greater than a set date and less than a set date. I'm trying to return the lowest job number in any given financial year. Hope that makes sense

Hey guys! Been busting my head trying to do something in Excel; but haven't been able to reach a satisfactory procedure. So here's the case, on bullets: 1) We have to open a fund to handle our investments. Each fund has a cost of $15,000 for opening, and each one can handle twenty investments...