LinkBack URL
About LinkBacks
=IF(INDEX(DataEntry!B:B,(ROW()*3)-7)<1,"",INDEX(DataEntry!B:B,(ROW()*3)-7))
It works well. Feels so brute; I get the feeling there might be a better way. If not ,that is fine too. Figure I'd run it by someone that feels like pondering a bit.
=IF(INDEX(DataEntry!B:B,(ROW()*3)-7)<1,"",INDEX(DataEntry!B:B,(ROW()*3)-7))
It works well. Feels so brute; I get the feeling there might be a better way. If not ,that is fine too. Figure I'd run it by someone that feels like pondering a bit.
You don't need the parentheses around your multiplication, but I don't think that's the type of advice you were looking for. I wouldn't criticize it because parentheses always remove any possibility of misinterpretation, but multiplication takes precedence.
I don't see any way to simplify this formula just by modifying the logic in the formula itself. I do see two alternatives. The best one is to create a named formula.
Go to Formulas, Name Manager. On the dialog box that comes up, click New. For the name, use DataValue. For the formula, use
Formula:
Please Login or Register to view this content.
I added $ to make this an absolute reference. Then change the formula in your cells to
Formula:Please Login or Register to view this content.
The second alternative is to add a "helper" column (let's say column C) with the formula
Formula:Please Login or Register to view this content.
Then your formula becomes
Formula:Please Login or Register to view this content.
It does simplify the formula, and would speed up performance in a very large spreadsheet, but helper columns have the drawback of taking up more space and cluttering the presentation, a particular problem if you are giving this to someone else to use.
(Self-deleted: misread question)
Last edited by XOR LX; 01-12-2014 at 11:00 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks