outputs

I a table with 6 different input scenarios and need to return 4 different outputs depending on the input. The table data is all dates and I would like to fill the Status column with one of the following outputs. No-Value Complete On-Time Past-Due An example of the scenarios in the table...

I've been asked to produce an automated report from Sims, a school MIS in the UK, that gives our schools exclusion data for the Trust KPI but I'm really struggling with one aspect. I've designed the report to run straight from Sims and put a link to a version with anonymised data in...

I'm hoping someone can help me. I have a 100 inputs and 100 outputs I populate column A with inputs and column B with outputs. Column C will contain data that will match to one cell in column A I want Column D to populate with the corresponding output from Column B. Is there an easy way to...

Hi, i have this code for finding last used row in a table: Sub LastTableRow() lrow = Range("Table5").Columns(1).Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row Debug.Print "lrow :" & lrow End Sub This works great except for when the table has no data it outputs this...

Hi i have the following formula =INDEX($F$28:$F$1000,MATCH(H9,$H$28:$H$1000,0)) which finds match in H28:H1000 and outputs corrosponding value in F Column However if there are multiple matches of H9, it always outputs first value Is there a way to output them all ? Array needed i think Any...

Hi all, I am a new member here but I have visited this forum before to look for helpful solutions. Sadly, I cannot seem to find a thread for this one: my date and time picker outputs not dates but numbers albeit not random, and I do not know how to make it display real dates. When I pick...

Hi, I am new to Excel VBA abd have been stuck in this problem for quite some time now. I am required to read (n) number of test cases with (n) number of inputs and display the outputs through a button macro in developer ribbon. I'm looking to write a function to accomplish this and any help...

Hello, I'm a newbie in Excel VBA. I have a task assigned where I need to read the inputs from a excel file,like reading of different test cases and paste the outputs(after formulas and all applied) in different sheet everything through a VBA. I don't have a JSON data or a URL to read the data...

I have a dynamic range (sheet 2 column d) called "category" that is used as the source data for a data validation drop down list (sheet 1 column e). The dynamic range consists of 2 types of data (inputs and outputs). Over time this range will grow as the user adds rows for new 'inputs' or...

Hi I am trying to combine this statement "The report was approved on " with today's date automatically Formatting required is The report was approved on 11 March 2018 I have tried using the CONCATENATE function as follows =CONCATENATE("This report was approved on ",TODAY()) however it...

Good day, I have a question that is got me a bit stymied. What I am doing is find the earliest and the latest date. The MIN formula is done completely different to the MAX formula. What I don't understand is why I cannot use the same formula for both Scenarios. If swap the formula's around I get...

Hello, I like to think I'm fairly proficient at Excel, but this has really stumped me. I've tried searching, but I'm not really sure what I'm asking for. Basically I have a sheet with a number of formulae spread across it, with numerous inputs and formulae leading on from each other. What I...

Hi all, I am trying to create a formula (see below) whereby it reads an entire range of data and outputs "YES" or "NO". Is the IF formula suitable for this purpose? =IF($B$4:$B$19="YES","YES","NO") Thanks.