1. Z

    (=sheet!) drag horizontally, column increment issues

    Okay so I've been struggling with this for a while and I can't seem to formulate my question that great either, bear with me please. So, I have created an excel sheet that collects exercise data into columns extending for several weeks. In my data sheet I am trying to collect these data points...
  2. A

    Stopwatch Time Formula 1 second increments

    Hello, I am trying to list minutes:seconds in 1 second increments up to 90 minutes in Excel (example~ how long it took to complete a task in minutes:seconds) 00:01 00:02 00:03 ... ... ... 90:00 However, Excel only seems to let me format time in the sense of World Time hh:ss, so once I get to...
  3. J

    Row grouping increments

    I have a pivot table in which the first column looks like this: 1 2 3 4 5 ... 50 If I group them in increments of 5, I get the following: 1-5 6-10 11-15 ... 46-50 I would like to group like this: 1-5 2-6 3-7 4-8 5-9 6-10 ... 46-50
  4. T

    delete rows in increments based on values in a column

    Hello, I have a sheet (many sheets!) with 2 columns, 50001+ rows. Row 1 is column headers. Column 1 values are numbers in increments of 1 starting at 200. I need to remove groups of rows, in various increments, based on the value in column 1. For example, If the value in column 1 is between...
  5. E

    Checking for and incrementing a year in a date

    I have a column that contains mostly dates (and some column headers and blank spaces) in MM/DD/YYYY format. I want to automatically increment the year for all of the dates in this column. I know that the following code increments the year of one cell: =DATE(YEAR(A1)+1,MONTH(A1),DAY(A1))...
  6. S

    Macro to increase/decrease

    Hi, Looking for a macro that I can assign to a button which, when clicked, will add 1 to a value in a cell. So if B2=5 when I click the button, this increments by 1 thus B2=6. Thanks Lee
  7. D

    Excel's Inability to follow a pattern of adding 15 sec

    Anyone know why excel would shift increments on me? Basically I type a date and a time in a cell: 3/29/18 10:25:08 Then I type a date and time 15 seconds later in the cell bellow 3/29/18 10:25:23 I highlight both cells and hit the little black square to fill the column in till the end of my...
  8. earwig999

    Conditional Format based on increments

    Hi, is it possible to create a formula for a conditional format to recognise increments of £250,000 and highlight figures in the column which exceed them? <tbody> INCREMENTS of £250,000 E.g. 250000 234200 500000 310000 750000 400000 1000000 475000 1250000 501200 1500000...
  9. N

    ROUNDUP increments

    Is there a way to ROUNDUP in increments? For example, if A2 is 74 and I wanted the adjacent cell, A3, to round A2 to the closest foot, how would I do it?
  10. N

    Rounding Numbers that are decimals

    I hoping this is simple and makes sense so here goes! I am looking for a formula to round a number to the nearest .025. For example Cell A1 contains .0280 and I need to round it the to the nearest .025, in this case .030 as my results have to be in .025 increments.
  11. C

    re-indexing increments

    Hello - this is my first post on this forum ! I might not be an excel Master, but I do work a lot with it and on pretty complex formulas, but on this one I feel stuck, close to a solution that eludes me everytime :). I have attached a file with the data and the desired outcome. Basically I...
  12. S

    vlookup #N/A Problem: Lookup Value is a Formula Result

    Greetings, Been working this problem for hours, one worksheet referencing another with vlookup. Column A in both sheets contain times in 15 minute increments ws1: A3:A48 = time of day in 15 minute increments B3:B48 = various activities in text ws2: A3 is a dropdown with a specific time (6:00...
  13. V

    Averageifs help with large data range

    hi all i need some help finding averages with unique criteria range. i have to work out the average value between 7:00 - 10:00 and 15:00 - 19:00 for everyday of august the data usually comes out in 5 min increments but sometimes its not but i still need it included with closest too value...
  14. D


    Hi there I have a graph with a Y axis that goes from 0 to 100 in increments of 10. I would like to hide the y axis between say 20 and 50 so effectively the y axis shows 0 to 20 and then from 50 to 100. Is this possible?
  15. M

    Flagging increases in values when a certain criteria is met

    Hi all, I use this site often but I'm usually able to find a solution to my problem through your threads, but not this time so it's my first post. Essentially I have huge amounts of lab data and have been automatically generating a testing schedule from it using a small macro but most...
  16. J

    average in increments that aren't integers

    Hi, I need to average every 7.11111 cells in column A (from row 1 to row 192), then column b seperately and so on... (to column QB) (ie rounding to the nearest whole number of cells, so most will average the contents of 7 cells, but some will average the values of 8 cells) I also need to...
  17. P

    Algorithm formula to increase by 10, 100, 1000

    <TABLE style="WIDTH: 48pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=64><COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; HEIGHT...
  18. D

    calculating time with 1/4, 1/2/ and 3/4 of an hour increments

    Hello, Please help!!! We have a client who will pay using the 1/4, 1/2/ and 3/4 of an hour increments as follows: From the hour mark to 6 minutes = 0 time paid Over 7 minutes to 15 minutes = 1/4 hour 15 16 minutes to 30 minutes = 1/2 hour 30 30 minutes to 45 minutes = 3/4 hour 45 46 minutes...
  19. V

    Suming Increments of 4

    I have data for Quarter 1 thru Quarter 4 Q1-4 repeats increments of 4 for 900 lines I want a formula that when i drag it down will only sum increments of 4 As you can imagine when i do a sum it will do A1:A4 but when i drag down it will sum A2:A5 I want it to do A1:A4 then A5:A9

Watch MrExcel Video

This Week's Hot Topics

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