Hello people!
I'm trying to write an Excel Function that grabs the data out of a neighboring cell in the same row. What is the proper function to do this? I've been searching for hours and cannot find it.
Thank you!!!
A:
Perhaps Offset would suit: http://www.techonthenet.com/excel/formulas/offset.php
Remou
2009-12-31 23:34:40
This looks like it would work but how do I set the 'reference' cell to the one containing the function?
Sharon
2009-12-31 23:36:30
In VBA? char char
Remou
2009-12-31 23:38:47
Not VBA, just in Excel (it's a cell function) - take a look at the offset parameters; range, etc etc etc. The range is like the "base" cell, but I need it to be relative to the cell in which the function is inserted. Do you know how to reference it "self". (like in jquery/js, you would just put 'this' as the range)
Sharon
2009-12-31 23:40:41
i don't believe that in-cell excel functions work like that. it's more absolute, where the cell references an exact other cell to grab data. however, excel does a lot of the legwork for you should rows/columns modify so that you aren't always updating your references.
Jason
2009-12-31 23:44:51
ok dang. thanks
Sharon
2009-12-31 23:46:27
+1
A:
If you're trying to grab info in column A and maybe multiply it by something in column B in your B cell you would do:
=A1*2
Is this what you're talking about? This seems maybe too straightforward...
EDIT Try this:
=$A1*2
and then drag the little square in the lower right corner of the cell down as many rows as you need.
Jason
2009-12-31 23:36:10