additional

  1. N

    Headers

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

    Formula: formula that bases total on current month throughout the year

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

    Referencing a cell where the row number will change

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

    Multiple IF statements

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

    Sorting/Filtering Tables Across Sheets

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

    Sumproduct with subtotal with filter

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

    Return true if partial text is found

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

    additional condition in vlookup

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

    SUMIFS with OR statement

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

    calculate additional fees based on multiple criteria!!!

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

    Sumproduct if

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

    If one cell matches a cell from a list....

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

    Convert #NAME? values to Strings

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

    Macro to update Pivot Source Folder

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

    Excel Formula Incrementing By One Randomly

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

    [VBA] adding a band to a line-chart programmatically

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

    Highlight cell where formula is overwritten

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

    Matching contents from one cell into another and displaying the contents back

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

    lookup and validation

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

    VBA Code to Count Number of Filled Spaces in Entry Form

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top