openoffice-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From John Meyer <johnme...@pueblocomputing.com>
Subject Re: VLOOKUP vs Macros
Date Sun, 29 Sep 2013 18:55:43 GMT
Thanks for that, I will be sure to try that out when I get back to the
office.  I've heard the Indirect and address method mentioned before, but
didn't have a practical example of how to use it.


On Sun, Sep 29, 2013 at 12:04 PM, Andrew Douglas Pitonyak <
andrew@pitonyak.org> wrote:

>
> =ADDRESS(1, 3, 1,, "sheet1")
>
> returns
>
> SHEET1.$C$1
>
> =INDIRECT(ADDRESS(1, 3, 1,, "sheet1"))
>
> returns whatever is stored in the cell referenced by SHEET1.$C$1
>
>
> On 09/28/2013 11:30 AM, John Meyer wrote:
>
>> I have a spreadsheet with a number of worksheets.  The first worksheet
>> has the bonuses for employees in this format
>>
>>
>> ID, Sales Agent, Sales For Date, Bonus for Date, Sales for Date(N), Bonus
>> For Date (N). . .
>>
>>
>> The rest of the spreadsheets are each named for the date of sales that
>> they contain.  They are in the same format as the column header for Sales
>> For Date.
>>
>>
>> I set up each row like this
>>
>> ID static, Agent name static, =COUNTIF(*staticdateworksheet***
>> !ColumnWithIDFirstRow:**ColumnWithIDNthRow,**Firstcolumnrowiamin),**
>> BonusCalculation
>>
>>
>> What I'd like to do is change that formula around to resolve the sheet
>> name by the first row of the salescount ID (i.e. if It's 9-27-2013 it would
>> pull up 9-27-2013, 9-28-2013, etc.).  Is this possible?  It's not a
>> pressing issue, I'd just like to see if it could be done.
>>
>> Thanks.
>>
>>
>>
>> ------------------------------**------------------------------**---------
>> To unsubscribe, e-mail: users-unsubscribe@openoffice.**apache.org<users-unsubscribe@openoffice.apache.org>
>> For additional commands, e-mail: users-help@openoffice.apache.**org<users-help@openoffice.apache.org>
>>
>>
> --
> Andrew Pitonyak
> My Macro Document: http://www.pitonyak.org/**AndrewMacro.odt<http://www.pitonyak.org/AndrewMacro.odt>
> Info:  http://www.pitonyak.org/oo.php
>
>
> ------------------------------**------------------------------**---------
> To unsubscribe, e-mail: users-unsubscribe@openoffice.**apache.org<users-unsubscribe@openoffice.apache.org>
> For additional commands, e-mail: users-help@openoffice.apache.**org<users-help@openoffice.apache.org>
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message