I am trying to get excel to sum only certain numbers in a range (one column) that is equal to or as close as i can get to a specified number. Example (trying to equal 10):
Range:
1
2
3
4
5
So I want excel to output that I need to add 2, 3, and 5 or 1, 2, 3, and 4 within this range to equal...
My excel spreadsheet has data for every tenth of a second for about an hour and a half; around 45000 cells. The data that was given to me has a flaw; when the hour gets past 12:59:59am it jumps back to 12:00:00 am. I need the hour to read 01:00:00am so that I can subtract the time intervals...
im having trouble running this subroutine. When it is finished it will be a loop that will find the maximum value in one column and then tell me the corresponding values in the next column every ten rows for 45000 rows. Right now I am just trying to get it to work for the first ten rows.
Sub...
