openoffice-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Johnny Rosenberg <gurus.knu...@gmail.com>
Subject Re: VLOOKUP vs Macros
Date Tue, 01 Oct 2013 14:11:14 GMT
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
> >> > >>> >
> >> > >>>
> >> > >>>
> >> > >>
> >> > >
> >> >
> >>
> >
> >
>

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