Support Board
Date/Time: Thu, 03 Jul 2025 05:09:06 +0000
Post From: Changing column titles within spreadsheet formulas
| [2020-04-22 21:21:59] |
| a Gem Tree - Posts: 60 |
|
I have created 40 different MA studies - So each study has a different column heading. I wanted to apply this formula to each MA - since the formula references the study's column heading at least 12 times, I would have to rewrite the column heading about 400 times. I'm not opposed to doing this, but I remembered (or dreamed) that Sierra had something to deal with this. I could have sworn that Sierra had this thing, where you could go into a formula, look up a sequence of characters, find all matching sequences in the formula, and then change that sequence (ie column heading) for all matching sequences in the formula. I may not be remembering things correctly, & if I'm not - It's no big deal if this isn't available. I'll just change it 1 by 1. Date Time Of Last Edit: 2020-04-22 21:25:30
|