$$Excel-Macros$$ Need :: IBM web content manager at Mooresville,NC

2016-08-11 Thread alan james
Please reply* alan_ja...@visionisys.com <alan_ja...@visionisys.com> * *Hello,* Hope you are Doing Good. This is Alan James from Visionisys Inc Please take a look the Job description given and let me know if you are interested reply with your most updated resume .. Job

$$Excel-Macros$$ Need :: AEM Admin at Plainsboro NJ

2016-08-10 Thread alan james
Please reply *alan_ja...@visionisys.com <alan_ja...@visionisys.com> * *Hello,* Hope you are Doing Good. This is Alan James from Visionisys Inc Please take a look the Job description given and let me know if you are interested reply with your most updated resume .. Job

Re: $$Excel-Macros$$ Re: Excel lookup function

2015-12-21 Thread Alan Walsh
Hi Pawan =VLOOKUP("*Station 18 (Vacuum)",F3:G21,2,FALSE) It just equates to N/A, have tried the asterisk on both ends. regards Alan On Wed, Dec 16, 2015 at 5:11 PM, Pawan Yadav <pwnyadav...@gmail.com> wrote: > Hi Alan, > > Can you provide the formula which you are

Re: $$Excel-Macros$$ Excel lookup function

2015-12-14 Thread Alan Walsh
Any luck with a solution on this Paul? regards Alan On Fri, Dec 4, 2015 at 7:18 PM, Alan Walsh <alandeswa...@gmail.com> wrote: > Hi Paul > > Is this impossible to do using just excel? > > Alan > > On Wed, Dec 2, 2015 at 6:31 PM, Alan Walsh <alandeswa...@gmail.co

Re: $$Excel-Macros$$ Excel lookup function

2015-12-04 Thread Alan Walsh
Hi Paul Is this impossible to do using just excel? Alan On Wed, Dec 2, 2015 at 6:31 PM, Alan Walsh <alandeswa...@gmail.com> wrote: > Correct > On 2 Dec 2015 17:02, "Paul Schreiner" <schreiner_p...@att.net> wrote: > >> Are you saying that the SQL query ret

Re: $$Excel-Macros$$ Excel lookup function

2015-12-02 Thread Alan Walsh
Forgot to answer. "list of reject descriptions" Is that the column titled "Station Name"? Yes then: the SQL query returns the rejects in "descending order". that's descending order by COUNT, not description? Yes Regards alan On Wed, Dec 2, 2015 at 9:12 AM, Alan

Re: $$Excel-Macros$$ Excel lookup function

2015-12-02 Thread Alan Walsh
Correct, but the row with the matching station name has extra text in it. Regards Alan On 2 Dec 2015 14:42, "Paul Schreiner" <schreiner_p...@att.net> wrote: > so now, you have an array of data. > > and a query that returns a station name and number. > > so what

Re: $$Excel-Macros$$ Excel lookup function

2015-12-02 Thread Alan Walsh
you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > > -- > *From:* Alan Walsh <alandeswa...@gmail.com> > *To:* excel-macros@googlegroups.com > *Sent:* Wednesday, December 2, 2015 11:00 AM > *Subject:* Re: $$Excel-Macros$$ Excel lookup function >

Re: $$Excel-Macros$$ Excel lookup function

2015-12-02 Thread Alan Walsh
; *Paul* > - > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley*

Re: $$Excel-Macros$$ Excel lookup function

2015-12-01 Thread Alan Walsh
will remain the same. i thought this would be simple to do. I thought all i had to do was look for the station name from the first sheet and find that text within the array of the second sheet (lookup_vector) and the result_vector would give me the number of rejects for that shift. Sounds easy no? Alan

$$Excel-Macros$$ Excel lookup function

2015-12-01 Thread Alan Walsh
this could be done in VB, but I am not that well up on VB. even now when i run the lookup function i set my lookup value to "*Station 18 (Vaccum)*" It did not work. the Astrix is for wild card yes? any help on this would be deadly Alan -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)

$$Excel-Macros$$ Re: Astrology Software in Excel!!!

2015-07-03 Thread Alan G.
Hello my friends, I am currently looking for an excel spreadshseet that can help me calculate astrolgical positions I hope that you can lend me a hand Regards On Saturday, May 30, 2015 at 9:59:38 AM UTC-7, Jan Schotten wrote: Yes there are on the yahoo groups of the swiss ephemeris there are

$$Excel-Macros$$ Problems Comparing New Line Character in Strings

2012-04-29 Thread Alan
anyone else run into this? I tried to do some Google searches, but no luck in finding answers to this problem. Thanks, Alan -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent

Re: $$Excel-Macros$$ VLOOKUP function

2010-10-10 Thread Alan
). Alan On Oct 9, 10:57 pm, Shreedar Pandurangaiah shreedar.panduranga...@gmail.com wrote: Hi Alan, The third part of the formula, where you've put $E:$E has to be replaced by either 1 or 2(since your table array is just D and E column). Thanks, Shreedar

$$Excel-Macros$$ VLOOKUP function

2010-10-09 Thread Alan
, and A4. The VLOOKUP functions in cells B2, B3, and B4 show the following results: B2: #VALUE! B3: second entry in the table, same as in A3 B4: the correct lookup value. This does not make any sense to me, based on the examples I have seen. What am I doing wrong? Thanks, Alan

$$Excel-Macros$$ Runtime error 1004 application-defined or object-defined error

2010-05-17 Thread Alan
into Excel cells. It works fine on another document, but not on this particular document. However, the debug statements I inserted prior to this (see code below) output fine. Anyone have any idea what might cause this? Thanks, Alan Public Sub Extract(WordApp As Object