Support Board

Date/Time: Wed, 24 Apr 2024 16:55:08 +0000

[User Discussion] - Spreadheet programming question: stumped can anyone help?

[2013-12-01 08:03:12] #1 [Go To First Post]
enemyspy - Posts: 304
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

To post a message in this thread, you need to log in with your Sierra Chart account: