additional

Hello, I have a spreadsheet with several amounts of information I have a main header going on each page along with the first 2 rows of my data being repeated as well. Issue i am having is, when i go on to the second page and on, I keep getting additional rows being repeated also so again...

Not sure how to phrase this - can I create a single-cell formula that knows what month it is and adjusts accordingly? Over a two-year period, the project team needs to hold a total of 52 meetings (with guidance to have 2 meetings each month with an additional 4 whenever). My spreadsheet lists...

Back for more help Geniuses!! I am working on a form where the user has multiple options for adding additional lines via command buttons. The adding of additional rows of information is all but guaranteed. Further down the form I need to sum 3 separate cells for a grand total, but the row...

I need to add an additional IF statement to a cell where I already have an IF statement. I need to add an additional IF statement to the below that states if A31="Destination Handling" then set a minimum limit value of 100 and a maximum limit value of 550 to P31, otherwise, use the below IF...

I have a workbook with multiple sheets, but am only concerned with the first two; Product Inputs and Outputs. Product Inputs includes information such as item identification numbers, dimensions, weights, etc. Outputs then takes those numbers and calculates profit, overhead, and quantity we...

OK Formula returns value: =IF(J$1="F1",SUMPRODUCT(SUBTOTAL(109,OFFSET($F$11,ROW($F$11:$F$200)-ROW($F$11),)),J$11:J$200,$B$11:$B$200),IF(J$1="TGA",SUMPRODUCT(SUBTOTAL(109,OFFSET($F$11,ROW($F$11:$F$200)-ROW($F$11),)),J$11:J$200,$C$11:$C$200),0)) Not returning value when additional arguments are...

I've tried so many examples and ideas from this site but to no avail! It seems simple enough and I'm probably just missing something but what I'm trying to do is this: If partial text is found return true, for example: In A1 The quick brown fox jumps over the lazy dog. In A2 The user can enter...

currently i am using the below formula for in between range but i want add an additional column (type) for verifying how can it be done =VLOOKUP(G2,B:D,3,TRUE) <colgroup><col width="64" span="8" style="width:48pt"> </colgroup><tbody> TYPE FROM TO CLS TYPE DATA CLS AA...

Hi guys, this one got me stumped as well :confused: =SUMIFS(Football!AM:AM,Football!D:D,">="&$B$1,Football!D:D,"<="&$C$1,Football!A:A,">="&$F$1,Football!A:A,"<="&$G$1,Football!AO:AO,"<>nd") How would I modify the above formula to include the following two statements? Football!I:I,">1" OR...

Hi all! So, I'm both an idiot in regards to Excel and Forum posting (as this is my first foray in the latter). Basically, what I'm trying to do is this: If a hotel has multiple "Seasons" (example: high, low, shoulder) in any given year, this affects pricing. I have already run a master...

Hi, I need to combine SUMPRODUCT and IF statements. I searched prior posts and found this formula as an example. IT WORKS!! Thank you! =SUMPRODUCT(--($J$14:$J$33="service"),$K$14:$K$33,$Q$14:$Q$33) But now I need to add an additional IF statement: ($J$14:$J$33="service") AND...

What I am trying to have happen: I will have Student ID numbers in a column. Next to each ID number (the next column over) there will be additional info like "Paid" or "Not Paid". I will have students enter their ID number is a cell and I want excel to put the additional piece of information...

Hi, I have row data that contains serial numbers in the following format "-VPT0000017J". Due to the minus upfront excel thinks this is a formula and assigns an additional "=" to the front. All and all I get an end result of "=-VPT0000017J", which is then displayed as #NAME? making it impossible...

Hi, I am looking for a macro to update the data source automatically. This will also mean that the table range will increase with additional rows, sometime additional columns. Each month we receive 2 source data files which I save to our server for the given month. Both data files are saved...

Hello, I have been attempting to make a spreadsheet for my fantasy football league draft. In the spreadsheet, I have a searchable dropdown list which I constructed using this tutorial: How to create a searchable drop down list in Excel?. My data is taken from a dynamic web query, and my...

Excel 2012ABCDEFGHIJKLM1Using 2 additional helper rows to set band2JanFebMarAprMayJunJulAugSepOctNovDec3Inventory71535829307817682714414Lower Band Value6060606060606060606060605Upper Band Value7070707070707070707070706789Without using 2 additional helper...

Hi I am trying to write a code where if someone keys over a formula in a cell so it is now value, the cell is highlighted. This includes if the cell also is linked to any additional files. Any ideas? Thanks

Hi All, I have a little bit of a tricky situation. I have two worksheets. Sheet1 contains a file name with claim numbers like below: <tbody> <tbody> File Name </tbody> <tbody> Date Created </tbody> <tbody> AAAA File name with additional characters.doc </tbody> <tbody>...

Hi everyone, i have a problem, that makes me spend hours sorting but i am sure there is a way that can be done in seconds, it starts like this i receive a monthly report and the below two columns are in it, i need to validate all ticket numbers if they are available in the database or lets...

Hello, my workbook is set up to copy a sheet from another workbook into it. Someone will fill out a worksheet with their data, and someone else will use my program to work with the data. The form they fill in has a few spaces for "additional notes", ie, essentially any information that doesn't...