("*Station 18 (Vaccum)*") but not getting solution?
>
> Note: Don't use Lookup function if your list not in ascending order. Use
> Vlookup function with exact match by using wildcard.
>
> Regards,
> Pawan
>
>
> On Tuesday, 1 December 2015 20:53:42 UTC+5:30,
Any luck with a solution on this Paul?
regards Alan
On Fri, Dec 4, 2015 at 7:18 PM, Alan Walsh wrote:
> Hi Paul
>
> Is this impossible to do using just excel?
>
> Alan
>
> On Wed, Dec 2, 2015 at 6:31 PM, Alan Walsh wrote:
>
>> Correct
>> On 2 Dec
Hi Paul
Is this impossible to do using just excel?
Alan
On Wed, Dec 2, 2015 at 6:31 PM, Alan Walsh wrote:
> Correct
> On 2 Dec 2015 17:02, "Paul Schreiner" wrote:
>
>> Are you saying that the SQL query returns:
>>
>> Reject counter for Zone 0, Station 12
sence)
>
> ??
>
>
> *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*
> -----
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:*
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, A
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*
>
nk we need more detail to help properly.
>
>
> *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 peo
Hi All
problem description. I have an excel sheet that i update manually. I want
to update automatically.
Here is what I have, A list of faults in a column, across each row is the
day and night shift, Monday to Friday.
see below.
Sheet 1
Station Name Mon Day Mon Night Tue Day Tue Night Wed Da
