starts

  1. L

    page fields/Alt+D+P

    Hi is this something I need to learn or these are old excel. I am using excel 2013. In the article below, the author said it is an old feature: "In Excel, it is possible to create a pivot table where data comes from several worksheets. It's an old feature, but still useful. The process starts...
  2. M

    "Start from" function

    Hello everyone! I am a beginnerin using Excel and have the folowng question. I havea dynamic row. I want to enter a formula into the cell which will connect it to the other cell with the year. For example, what to do if I want to make the cell change its value in case the connected cell is...
  3. S

    Add cell in one column result in different column

    Hello, I need help with VBA code inserting sum of cells in column R in to column T which are separated by two empty rows. values in column R starts at row 2. Here is an example: <colgroup><col><col></colgroup><tbody> Column R Column T 258.05 567.42 309.37 426.19 930.44...
  4. D

    Continue Formula until certain cell reached

    Hi - I have the following code; Dim lastRow As Long lastRow = Cells(Rows.Count, "D").End(xlUp).Row Range("X2:X" & lastRow).FormulaR1C1 = "=SUM(RC[-3]:RC[-1])" Is there a way to amend or add to this code so that the SUM formula starts in row 2 of column X and continues down, but stops as soon...
  5. D

    Nested IF Statement Resulting in #NAME?

    I have a formula that is partially working. There are multiple IF statements nested, and the first two actually perform correctly. Once I get into a couple of layers it starts to result in #NAME?. When I click on the various statements within Excel it seems to work through the logic correct...
  6. W

    convert cells

    Hello Excel guru's, I need to convert the text data in an excel sheet to a fixed length number. For example: Emp# ALY/5632 = 41021345632 In this example, output always starts with "4". A=10, Z=35 etc / is removed can I do this in one extra column? Thanks!
  7. ironsides

    2 macros needed

    starts line 19 if col M =>1, SUM col AM also COUNT thanks ironsides
  8. T

    Excel VBA Extracting Data from Table to an Array

    Im trying to extract the color index of cells in a table in a spreadsheet into an array using a VBA macro. The indexing I have for my for loop is offset as in the count starts at column 2 and row 4, but the array begins at 0,0 or 1,1? Is there a way to enter this info using such a for loop? Thanks
  9. A

    Counting activity by week

    I hope this will not be too difficult to explain but this is a tough one. I have 3 columns, A, B & C and each column has about 10 rows. Each cell is formatted to be a date. So for example, the rows are broken down into weeks, so the first 10 rows will be week 1, the next rows will be week 2...
  10. P

    How make code dynamic (I think)

    On a spreadsheet I have the names of five columns that contain the title of Product Codes, Product Description, Dozens per case, Cases per pallet and UOM(Unit of Measure). As of now, on my user form, I have a combo box that the user will select the product, a command button, and a text box. The...
  11. kelly mort

    Clear cell Contents if condition is met

    I need a script to clear contents of cells in a range that may contain values less than 1. The data starts from A7 and I am clearing from the range D7 to N7 down to the last used row. Thanks Kelly
  12. A

    Add a 1 in a cell based on a date range

    Hello, I am trying to figure out the formula for the following: Starting in G2 I want to add a 1 when the dates in C2 and D2 are within the range of G1 and continue on for each cell down and across. The formula I have now does that. However, I cant figure out how to make a formula where: Add a...
  13. kelly mort

    Vba code to add and copy data needed

    I have three data tables. Two of them are sitting on a single sheet and the other is on a different sheet. I am adding from the two tables from the single sheet and pasting the result to the Sheet2 table. Table 1 starts from G4 to O104 and Table 2 starts from P4 to X104. Then table 3 starts...
  14. B

    Intersection of two data ranges.

    <tbody> Elevation A Elevation B Elevation C Elevation D 24 32 31 35 15 20 25 30 </tbody> I have two ranges of elevations (Elevation A and B and Elevation C and D) and I need a formula to determine if the two sets overlap. For example, Elevation A starts at 24 and ends at 32 and...
  15. K

    Autofilter from selected Range - VBA CODE

    Hi , I have the code Sheet2.ActivateSheet2.Range("B5").End(xlToRight).Select Range("B5").End(xlToRight).AutoFilter Field:=Range("B5").End(xlToRight), Criteria1:="IT6" however, it does not seem to work. My aim is to select the last coloumn with data and this always starts from row 5. So I...
  16. P

    =if() function is not working like it should be

    Any formula that starts with =if() doesnt work. What should i do?
  17. L

    Splitting phone numbers out into different cells

    Hello! Bit of advice needed as I'm running out of hair to pull! I have a column which contains a landline number, a mobile number, or in some cases both. I need to strip these out into separate columns. The common identifier for each example is the word at the start of the cell. If the cell...
  18. M

    Formula for Per diem (Counting Specific Time and Days).

    Hi everyone, I´m new here and I hope someone can help me. English is not my native language but I have seen a question similar to mine that was posted in 2010. So, I'll give it a try, and if I make mistakes please forgive me :pray: I am trying to generate a travel calculating formula for...
  19. A

    Macro which keeps running

    I need a macro which keeps running at the backend...whether I do anything on system or not, it should perform some activity in excel till the time I want. I need a button that starts that macro and when I want to stop that then i press again a button to stop the macro. Please help.
  20. M

    Is it possible to link a cell value to a name range in Excel?

    Hi All, Is there a formula that if the last cell in a range is A6545, that it can return 6545 as a value in another cell. Secondly, if that is possible, can I link that cell value, which in the above example would be 6545 to a named range. So, the range always starts from A1 and ends in A...

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