Support Board
Date/Time: Sun, 24 Nov 2024 22:37:16 +0000
Post From: Spreadheet programming question: stumped can anyone help?
| [2013-12-01 08:03:12] |
| enemyspy - Posts: 306 |
|
ok so I have indexed dates from a spreadsheet study to a standalone sheet, made a formula that assigns various tags for each row of the standalone sheet based on conditions of the previous rows in the sheet. Now I need to to match those tags back to a column in the original spreadsheet study and have them placed in the row of correct time stamp. Here is a visual example: standalone sheet Time|Tag 5 1 11 2 15 3 17 4 32 5 45 a 47 b 49 c Original Study Time|tag 1 2 3 4 5 1 6 7 8 9 10 11 2 12 13 See I am having trouble figuring out a formula to match the tag from the non sequential indexed time stamps back to the correct row of the original sequential time of the study. I initially tried to work something out with Index match combo but was unsuccessful. Does anyone have a formula that could work for this? Any help will be recieved with undying gratitude. Date Time Of Last Edit: 2013-12-01 08:10:07
|