sunwordelite
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...
[IMG]https://www.citehr.com/images/misc/progress.gif[/IMG]

From Malaysia, Semenyih
Sumalathas
Just check wheather the attachement is any use to you.
From India, Bangalore
Attached Files (Download Requires Membership)
File Type: xls EXCEL_Formulae01.xls (1.48 MB, 198 views)
File Type: xls Excel Dictionary.xls (1.14 MB, 225 views)

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.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.