1. C

    Return nearest date after finding match ID

    I have 2 sets of data. One contains ID# and dates . The other set contains same ID # and different dates. Each ID # occurs multiple times, but not equal number of times, in each spreadsheet. I want a formula to look for ID # match in the second spreadsheet and return the date that is...
  2. Y

    Finding Shortest Time Span within a Time Range.

    I've got a question in regards to a formula that I'm having trouble solving. Is there a way to find the times with the shortest time between them and then be able to calculate the time inbetween said times. I would normally not have trouble doing this (when the times are in different cells)...
  3. M

    How to extract a particular set of string from a given set of sting?

    I am trying to figure out how to remove all data [including opening parenthesis "("] which is appearing after the last occurrence of opening parenthesis "(" in a given string. Refer below example: <tbody> <colgroup><col><col></colgroup><tbody> RAW DATA OUTPUT ABC (P) (L) (30365) ABC (P)...
  4. J

    Macro to copy rows multiple times

    I have seen a number of similar threads on this subject, however I have a variation. I have a sheet with 211 rows, each row needs to be copied and inserted multiple times. The number of times it needs to be copied is in a cell within each row (Col G). So The first row has the number 14 in Col...
  5. Y

    Formula Help (times)

    Is there a formula that can be ran on these values to then return something similar to the sample table provided below. The objective of this formula wold be to break down minute by minute is there are 0,1,2, or more times overlapping. <colgroup><col width="80"...
  6. M

    Calculate difference between two times using Pivot Table Calculated Field

    Hi, I tried different steps two subtract two times (cell b-cell a) using calucated fieldd and output the total in cell c but my output is totally wrong. Could someone look into this for me. Much appreciated. Shall I upload sample file? Thank you
  7. J

    VBA to copy and paste range N times

    Hey, looking for some help with a code that will copy a range of data and paste x numbers of times depending on what value is selected. In addition I would need column A (starting in A8) reference how many times the data set was copied. Thanks in Advance Drop Down Box: B1 Range of Data...
  8. K

    Beginner help - making class assignment

    Hi, I feel there should be a way to automate this, I'm just not seeing it. I have a list of participants, each have chosen 5 out of 8 possible classes. Classes are offered multiple times over 2 days, 4 classes at a time. I have the class times and schedule. My goal is to assign 'students' to...
  9. R

    How to find the most SEQUENTIAL occurring numbers in 1 column

    I am doing lottery odds on excel for fun. So I am doing a 5 column lottery. I am trying to figure out in Column I (Labeled 4th Ball) How to highlight the numbers that show up in a row the most frequently and to highlight them a certain color. For example, rows 20-22 all have the number 15 so...
  10. O

    Date format Reordering

    Hi. Please see link to the relevant file, below: https://1drv.ms/x/s!AtIvkRgReIvwgRPV4fmLEL1-gjz- I have a problem that I can’t seem to solve. I have this list of times and positions, with the times in hh:mm:ss format. However, the times have the minutes and and seconds in the wrong...
  11. S

    Excel Formula - How Many Times a Value Appears

    Hi everyone, Have a request for a formula. In cell A10 I have a value of 1 Cell A15 I would have the formula that would do the following: I know the value 1 is in cell A20. I want to count how many times the value 1 repeated below cell A20 before the value changed. So in the example below...
  12. S

    excel match feature

    Hello there, I use countif formula to find out how many times in one year 8 numbers have matched. Usually 8 numbers match only once a year or maybe not. prize money for 8 numbers is 10k as above. But there many times 4,5 or 6 numbers match. For example to find out how many times 4numbers...
  13. W

    Selection.End(xldown).Select variable number of times

    In column A, I have strategically placed the value of x in specific rows. I use a macro that goes to column A and then executes selection.end(xldown).Select a certain number of times depending on which row I want it to land on. For example if I want it to select the third row with an x I use...
  14. P

    How to average numbers generated by formulas?

    <tbody> A B Formula in N Result of formula 05/28/2019 05:15 05/28/2019 05:00 =IF(A3="","",TEXT(TIMEVALUE(TEXT(A3,"HH:mm"))-TIMEVALUE(TEXT(B3,"HH:mm")),"hh:mm")) 00:15 </tbody> This has to be simple, and don't know why I'm unable to think of how to do this, but I need some help...
  15. B

    Formula Required If possible

    Hi All, Working on a spreadsheet and wanting to know if anyone can assist me with a formula to highlight fields based on inputted times. I currently have rows H - Y with times at 1 hour intervals. 0600 0700 0800 etc I would like rows F to be the start time and row G to be the finish time...
  16. N

    Counting # of times a stock reaches a certain price in a session/Probabilities

    How can I record # of times a stock reaches a certain number throughout the day? Currently I only have a function for when it is at that number it returns 1 and if not a 0. i need a running count. Basically I am looking to record the success of a tick fade play. When the $TICK reaches +1000...
  17. N

    Stock Market

    Hi, I need to count the amount of times a certain stock reaches a certain price. It is real time data. Also, how can i automatically record this each day? How can I set it to record at only certain times?
  18. H

    VBA to Repeat Task a Specific Number of Times

    Hi there! So I hope I can explain what i'm trying to do clearly. I have an input table where users input hours for a labor category (column) and a task (row). The user also has the ability to insert more categories (columns) and more tasks (rows). In order for the information to become useful I...
  19. A

    Paste x times

    Hi how can i copy a value and paste it lets say 10 times underneath with vba? Thanks, AAT
  20. K

    Help with Arrays

    Note: This was originally posted at https://www.excelforum.com/excel-programming-vba-macros/1274124-help-with-arrays.html I have not been able to get any responses to addressing this. My apologies if this doesn't make sense, I am new to using arrays and have been trying to research this but...

Some videos you may like

This Week's Hot Topics