Need some help
 

Im totaly new in excel so i really need some help.
Dont even know what function i need to use.

I have 8 columns.
The first column is a counter
The 7 others contains codes for faults on 7 different channels that get
theres value from manual input.
The codes has a value and from all this i get a graph. Count/points.
Now i need to know when criterion is met and mark the count in the
graph some way.

Fault codes:
A
B1-B13

For example:
Criterion 1 to be met: Fault B1 or fault A

Criterion 2: One individual channel B1 or two channels with B1 or
one channel with A

Criterion 3: One individual channel B2 or four B1

The criterion is judged by row. So when it find a row that match one of
these i need that
count to be marked in the graph and then that criterion is set and not
needed to be checked no more.

Hope i make some sense.


--
Moffe
------------------------------------------------------------------------
Moffe's Profile: http://www.excelforum.com/member.php...o&userid=30594
View this thread: http://www.excelforum.com/showthread...hreadid=502440

Need some help
 

Really could need some help here.
If i have 3 columns and whant to check the last 2 columns for "A" or
"B" and when that turns upp i whant it to report the content of
column1. Then stop.
Anyone have any ide what functions i need to use?


--
Moffe
------------------------------------------------------------------------
Moffe's Profile: http://www.excelforum.com/member.php...o&userid=30594
View this thread: http://www.excelforum.com/showthread...hreadid=502440

Need some help
 

Hi Moffe,

Moffe Wrote:
Really could need some help here.
If i have 3 columns and whant to check the last 2 columns for "A" or
"B" and when that turns upp i whant it to report the content of
column1. Then stop.
Anyone have any ide what functions i need to use?

Sorry I can't help with your graphing question but would recommend that
for future questions you put them in separate posts with a more
meaningful title. For the above...

I've assumed that when checking for "A" or "B" this will be the value
of the cell & not just one character within the cell's value.
Enter this into D1 & copy it down as many rows as required:
=IF(OR(B1="A",B1="B",C1="A",C1="B"),A1,"")

I'm not sure what you mean by the "then stop" - if it means that you
only want to see the value of column A appear in column D for the first
row that an "A" or a "B" appears in columns B or C, try entering this in
row 2...

=IF(AND(ROW(D2)1,COUNT($D$1:D1)=0),IF(OR(B2="A",B 2="B",C2="A",C2="B"),A2,""),"")

(*note *this will only work from row 2 downwards)

hth
Rob Brockett
NZ
always learning & the best way to learn is to experience:


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=502440

Need some help
 

Ill try to explain better, sorry.
Its for a test of ink printers with 7 nozzles/channels.
2 times a day tests prints are made and a print count are noted.

The first column contains the print count.
And then 1 columns for each individual channel.

I whant the function to go row by row to give me the first time each
criterion is met for a test print and then report on what print count
that happend.

The criterion is for 1 row (test print), not total.

Sorry for bad english and if i make no sense at all.


--
Moffe
------------------------------------------------------------------------
Moffe's Profile: http://www.excelforum.com/member.php...o&userid=30594
View this thread: http://www.excelforum.com/showthread...hreadid=502440

Need some help
 

Ill try to explain better, sorry.
Its for a test of ink printers with 7 nozzles/channels.
2 times a day tests prints are made and a print count are noted.

The first column contains the print count.
And then 1 columns for each individual channel.

I whant the function to go row by row to give me the first time each
criterion is met for a test print and then report on what print count
that happend.

The criterion is for 1 row (test print), not total.

Sorry for bad english and if i make no sense at all.


--
Moffe
------------------------------------------------------------------------
Moffe's Profile: http://www.excelforum.com/member.php...o&userid=30594
View this thread: http://www.excelforum.com/showthread...hreadid=502440

Need some help
 

Ill try to explain better, sorry.
Its for a test of ink printers with 7 nozzles/channels.
2 times a day tests prints are made and a print count are noted.

The first column contains the print count.
And then 1 columns for each individual channel.

I whant the function to go row by row to give me the first time each
criterion is met for a test print and then report on what print count
that happend.

The criterion is for 1 row (test print), not total.

Sorry for bad english and if i make no sense at all.


--
Moffe
------------------------------------------------------------------------
Moffe's Profile: http://www.excelforum.com/member.php...o&userid=30594
View this thread: http://www.excelforum.com/showthread...hreadid=502440

Need some help
 

Great
Im starting to get somewhere now thanks to you.

One question.
In the =IF(OR(B1="A",B1="B",C1="A",C1="B"),A1,"")
can i search for part of the codes?
For example: When theres a dot missing i set M and then the number of
missing dots (M2). I whant it to search for any sort of missing like
M*.
How do i do that?

Thank you very much for your help broro183.


--
Moffe
------------------------------------------------------------------------
Moffe's Profile: http://www.excelforum.com/member.php...o&userid=30594
View this thread: http://www.excelforum.com/showthread...hreadid=502440

Need some help
 

Hey Moffe,

Yes, it is clearer with your second explanatory post. Unfortunately
your question is beyond my knowledge, I'm still learning too - I'll
have a go at answering it tomorrow but I'd recommend looking up the
word 'sumproduct" as one of these functions would probably be much
tidier & more efficient than what I can offer tomorrow.

wrt "One question.
In the =IF(OR(B1="A",B1="B",C1="A",C1="B"),A1,"")
can i search for part of the codes?
For example: When theres a dot missing i set M and then the number of
missing dots (M2). I whant it to search for any sort of missing like
M*."

Yes, you should be able to. Instead of "OR(B1="A"," etc use
"OR(left(b1="M",1)"...
Or another option may involve the "find" function but I'm not familiar
with using this function (try the help file).

I'm off to bed but will have another look tomorrow & see how you're
going - good luck,
Rob Brockett
NZ
Always learning & the best way to learn is to experience...


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=502440

Need some help
 

I put every fault code in the OR(
Maby not good coding but it works.

So now i only have some problems left:

Criterion 2: One individual channel no more then M1
No more then 2 channels can have M1

Criterion 3: One individual channel no more then M2
Total of M=4


--
Moffe
------------------------------------------------------------------------
Moffe's Profile: http://www.excelforum.com/member.php...o&userid=30594
View this thread: http://www.excelforum.com/showthread...hreadid=502440

Need some help
 

Didnt get that to work but i found another way to find part of words.
=IF(COUNTIF(B1:C1;"*M*");A1;"")
So now i can search my M1-M13
BUT
Is there a way to get another criteria in to that code? like to search
for another code too.


--
Moffe
------------------------------------------------------------------------
Moffe's Profile: http://www.excelforum.com/member.php...o&userid=30594
View this thread: http://www.excelforum.com/showthread...hreadid=502440

Need some help
 

Hi Moffe,
Sorry you have had to talk to yourself, this is tough for me too but I
have figured out a few possibilities:

Criterion 1
{=IF(OR($B4:$H4=$O$1,$B4:$H4=$O$3),"criterion met","not met")}

Criterion 2:
{=IF(OR(COUNTIF($B4:$H4,$O$1)0,COUNTIF($B4:$H4,$O $2)=2),"criterion
met","criterion not met")}

Criterion 3:
{=IF(OR(COUNTIF($B4:$H4,$O$2)0,COUNTIF($B4:$H4,$O $3)=4),"criterion
met","criterion not met")}

Note:These are arrays (symbolised by the curly brackets) so they need
to be entered using [ctrl+shift+enter] & assume that column O contains
a list of the fault codes.
- replace the sentences in my formulae with references to the print
count column.

I don't know how bullet proof these are but they seem to all work when
I gave them a quick test.
Good luck
Hth,
Rob Brockett
NZ
Always learning & the best way to learn is to experience...


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=502440

Need some help
 

Amost got it now.
Im only need the last one to count the number of M´s and not
"M-codes".
It does that now: "IF(OR(COUNTIF($B8:$H8;"*M*")=4......"
I neet it to separate M1 and M2. Now it allow 4*M2 and thats 8 M´s.
Other than that everything seams to work now.
I appreciate your help. Thanks.


--
Moffe
------------------------------------------------------------------------
Moffe's Profile: http://www.excelforum.com/member.php...o&userid=30594
View this thread: http://www.excelforum.com/showthread...hreadid=502440