hi can anyone help me show formula in excel....let say
01258
74125
85644
74581
i got this number in one chart,i want use formula in excel to indentify outside from this number,answer is 3 and 9.
1) anyone can show me in excel what formula should i use
2) how use to colour in red
01258
74125
85644
74581
target number 5.this number must highlight in the box as example shown.
what formula should i use?
thanks in advance
From Malaysia, Semenyih
01258
74125
85644
74581
i got this number in one chart,i want use formula in excel to indentify outside from this number,answer is 3 and 9.
1) anyone can show me in excel what formula should i use
2) how use to colour in red
01258
74125
85644
74581
target number 5.this number must highlight in the box as example shown.
what formula should i use?
thanks in advance
From Malaysia, Semenyih
hi anyone can help me in excel. what formula have to use if
457812
852147
458561
147248
from the chart i want indentify ,outside number from the chart..
answer is 3 and 9
1) what formula should i use .please teach me.
2)from this chart i want target number as example shown below.
target number 5
457812
852147
458561
147248
when target number key in
should be red from the chart.
3)or the cell highlight red colour from the chart..
please teach me thanks in advance.
thanks for postting excel valuable format
but still cannot find the formula...can anyone help attach sample files in excel...
thanks
From Malaysia, Semenyih
457812
852147
458561
147248
from the chart i want indentify ,outside number from the chart..
answer is 3 and 9
1) what formula should i use .please teach me.
2)from this chart i want target number as example shown below.
target number 5
457812
852147
458561
147248
when target number key in
should be red from the chart.
3)or the cell highlight red colour from the chart..
please teach me thanks in advance.
thanks for postting excel valuable format
but still cannot find the formula...can anyone help attach sample files in excel...
thanks
From Malaysia, Semenyih
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
Advanced Excel 2003.pdf
152120-very-use ful-hr-manageme nt-software-bui lt-excel-psa-hr -manager-mainta in-payrrol-exce l-soft.zip
Competancy--exc el---mts___smts _289.xls