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 Tue, 01 Oct 2013 14:21:51 GMT
Same Err:501.  I'll post up more in the office.

On 10/1/2013 8:11 AM, Johnny Rosenberg wrote:
> 2013/9/30 John Meyer <johnmeyer@pueblocomputing.com>
>
>> Still doesn't work.  Back to the drawing board.
>>
> Exactly what does your current formula look like and what error message do
> you get? Still 501?
>
>
>
> Johnny Rosenberg
>
>
>>
>> On Mon, Sep 30, 2013 at 2:32 PM, John Meyer
>> <johnmeyer@pueblocomputing.com>wrote:
>>
>>> Derp, just saw that.
>>>
>>> Thanks.
>>>
>>>
>>> On Mon, Sep 30, 2013 at 2:01 PM, Johnny Rosenberg <
>> gurus.knugum@gmail.com>wrote:
>>>> 2013/9/30 John Meyer <johnmeyer@pueblocomputing.com>
>>>>
>>>>> Sorry, that e-mail got sent off too quickly.  I'm trying this formula
>>>>>
>>>>> =COUNTIF(INDIRECT(ADDRESS(1,3,1,,"Bonuses")).$E$1:$E2000,A2)
>>>>>
>>>>> C1 contains the name of the worksheet ("09-27-13") and I'm trying to
>> use
>>>>> it.  However, it keeps giving me an err:501.
>>>>>
>>>> Hint 1:
>>>> Use the builtin help and search for 501. It will take you to the error
>>>> codes. 501 means something like ”invalid character”. In this case it
>> seems
>>>> like you use ”,” instead of ”;” as parameter separators. I thought
that
>>>> there was a setting for that somewhere, but now I can't find it, so I
>>>> guess
>>>> that is a LibreOffice feature, but I'm not sure. I used LibreOffice for
>> a
>>>> couple of years but I am back with Apache OpenOffice again, since
>>>> LibreOffice was way too unstable for me. It actually destroyed one of my
>>>> spreadsheets but Apache OpenOffice fixed it for me, that's why I'm back…
>>>> :D
>>>>
>>>> Anyway, replace those commas with semi-colons and I think it will work.
>>>>
>>>> Hint 2:
>>>> If you are working with a big formula and it doesn't work, hit Ctrl+F2
>>>> (select the cell that you are working with first) and you are able to
>>>> study
>>>> your formula a little better. For instance you can see sub values by
>>>> placing the cursor on different places in the formula. That way it's a
>>>> little easier to find WHERE the error is.
>>>>
>>>>
>>>>
>>>> Regards
>>>>
>>>>
>>>> Johnny Rosenberg
>>>>
>>>>
>>>>>
>>>>> On Mon, Sep 30, 2013 at 1:22 PM, John Meyer
>>>>> <johnmeyer@pueblocomputing.com>wrote:
>>>>>
>>>>>> =COUNTIF(INDIRECT(ADDRESS(1,3,1,,"Bonuses")).$E$1:$E2000,A2)
>>>>>>
>>>>>>
>>>>>> On Mon, Sep 30, 2013 at 1:18 PM, John Meyer <
>>>>> johnmeyer@pueblocomputing.com
>>>>>>> wrote:
>>>>>>> So I guess I'm doing something wrong here.
>>>>>>>
>>>>>>> =COUNTIF(INDIRECT(ADDRESS(1,3,1,,"Bonuses")).$E$1:$E2000,A2)
>>>>>>>
>>>>>>> Returns an Err:501.
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> On Sun, Sep 29, 2013 at 10:59 PM, Coreurus <coreurus@aol.com>
>> wrote:
>>>>>>>> <
>>>>>>>> ----- Original Message --(Start-looking-by-there)
>>>>>>>> From: John Meyer >
>>>>>>>> To: <users@openoffice.apache.org>
>>>>>>>> Sent: Saturday, 28 September, 2013 04:40 PM
>>>>>>>> Subject: Re: VLOOKUP vs Macros
>>>>>>>>
>>>>>>>>
>>>>>>>>> I sent that a little too soon.
>>>>>>>>>
>>>>>>>>> The title refers to the fact that I was looking into
another
>>>>> solution.
>>>>>>>>> the sales sheet for each day is broken down with the
following
>>>>>>>> information:
>>>>>>>>>
>>>>>>>>> Date, EmpID
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> Currently, what I am doing is separating them by date.
>>   However, I
>>>>> was
>>>>>>>>> thinking a much less cluttered solution would involve
pulling
>> the
>>>>> date
>>>>>>>>> from the bonus calculation field and then doing either
a VLOOKUP
>>>>> with a
>>>>>>>>> count or Macro.  Where would I start looking if I wanted
to do
>>>> either
>>>>>>>>> one of those solutions?
>>>>>>>>> Back to searching for the answer.
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>> ---------------------------------------------------------------------
>>>>>>>>> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
>>>>>>>>> For additional commands, e-mail:
>> users-help@openoffice.apache.org
>>>>>>>>
>>>


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org


Mime
View raw message