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

    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

Some videos you may like

This Week's Hot Topics