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

2015-12-14 Thread Alan Walsh
the places you can,At all the times you can,To all the people >>> you can,As long as ever you can.” - John Wesley* >>> - >>> >>> -- >>> *From:* Alan Walsh >>> *To:* excel-macros@g

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

2015-12-04 Thread Alan Walsh
y 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* >> - >> >> -------------- >> *From:*

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

2015-12-02 Thread Alan Walsh
> > -- > *From:* Alan Walsh > *To:* excel-macros@googlegroups.com > *Sent:* Wednesday, December 2, 2015 11:00 AM > *Subject:* Re: $$Excel-Macros$$ Excel lookup function > > Correct, but the row with the matching station name

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

2015-12-02 Thread Paul Schreiner
er you can.” - John Wesley - From: Alan Walsh To: excel-macros@googlegroups.com Sent: Wednesday, December 2, 2015 9:25 AM Subject: Re: $$Excel-Macros$$ Excel lookup function Forgot to answer.  "list of reject descriptions"Is th

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

2015-12-02 Thread Alan Walsh
n,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* > - > > -- > *From:* Alan Walsh > *To:* excel-macros@googlegroups.com > *Sent:*

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

2015-12-02 Thread Paul Schreiner
, December 2, 2015 9:25 AM Subject: Re: $$Excel-Macros$$ Excel lookup function 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

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

2015-12-02 Thread Alan Walsh
t; >> >> >> *“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-02 Thread Alan Walsh
- > > -------------- > *From:* Alan Walsh > *To:* excel-macros@googlegroups.com > *Sent:* Tuesday, December 1, 2015 1:25 PM > *Subject:* Re: $$Excel-Macros$$ Excel lookup function > > ok as simple as I can make it. > > On

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

2015-12-01 Thread Paul Schreiner
ay, December 1, 2015 1:25 PM Subject: Re: $$Excel-Macros$$ Excel lookup function ok as simple as I can make it. On the first sheet I have a list of reject descriptions, across which is populated the number of rejects per shift.(see above) The second sheet is is from a sql query that returns the

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

2015-12-01 Thread Alan Walsh
ok as simple as I can make it. On the first sheet I have a list of reject descriptions, across which is populated the number of rejects per shift.(see above) The second sheet is is from a sql query that returns the rejects in descending order. (so the second sheet is not in the same order as the

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

2015-12-01 Thread Paul Schreiner
I'm not sure what you're "looking up"?? Your sample data is: | Station Name | Mon Day | Mon Night | Tue Day | Tue Night | Wed Day | Wed Night | Thur Day | Thur Night | Friday Day | Friday Night | | Station 18 (Vaccum) | 276 | 363 | 231 | 146 | 54 | 175 | 172 | 180 | 208 | 238 | | Station 12 Heigh