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

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

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

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

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

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

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

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