[Solved] Auto notification

Auto notification

Dear Expert,
Suppose,
Col-A                        Col-B                
 English                       80
Math                           70
Physics                        79
Chemistry                    60
Now what I want is:
Those subjects are below 80 Cell A10 will show the name of subjects e.g Math, Physics Chemistry need to study more (according to above data)

thanks in advance

Anwsers to the Problem Auto notification

Download Error Fixer (Free)

Hi,
Put this ARRAY formula in a cell, ARRAY enter it; see below for how, and drag down until it starts returning blanks.

=IFERROR(INDEX($A$1:$A$100,SMALL(IF($B$1:$B$100<80,IF($B$1:$B$100<>"",ROW($B$1:$B$100))),ROW(1:1))),"")
This is an array formula which must be entered by pressing CTRL+Shift+Enter
and not just Enter.
If you do it correctly then Excel will put curly brackets
around the formula .
You can't type these yourself.
If you edit the formula
you must enter it again with CTRL+Shift+Enter.

Cleaning your computer, components, and peripherals help keep everything in good working condition and helps prevent germs from spreading. You can't image how dirty the inside of your computer case can get. All the dust and dirt is going to prevent proper air flow and may even prevent the fan from working.

Recommended Method to Fix the Problem: Auto notification:

 

 

How to Fix Auto notification with SmartPCFixer?

1. Click the button to download SmartPCFixer . Install it on your system.  Open it, and it will perform a scan for your system. The errors will be shown in the scan result.

2. After the scan is finished, you can see the errors and problems need to be repaired. Click Fix All.

3. When the Fixing part is finished, your computer has been speeded up and the errors have been fixed

Related: Sticky Notes forget formatting on logoff The Charms bars minimise and exit bar in apps and the taskbar in apps sometimes does not appear Windows 8 1 Update system restore notification at startup Start Screen tiles does not opens and they disappears The Fn F9 key to Disable Touchpad does not work on Windows 8 1 upgrade for Asus laptop what happen all my stuff shows up as notepad The USB Printer HP Laserjet 1020 cannot be recognize after hot pluging Uninstall Windows 7 Speech Recognition does not appear in computer uninstall list unable to create new partition converting from basic volume to dynamic volume not supported The Windows Media Player does not open on by clicking the icons USB drive not accessible Web page display is not incomplete Using wiindows 7 w IE 8 what does c programdata appleservicetraydll module not found mean tbupdater dll not found When booting up Windows 7 getting error Windows could not start because the following file is missing or corrupt windows noot system32 bal dll The computer did not shut down properly,Kies error message Fatal Error object reference not set to an instance of object fatal error What is this and how do I fix it Lexmark Pro800 900 not printing forms correctly Mail Merge Word 2007 Mail Merge Recipients box not responding Most applications crash and will not run Network printer WiFi Kodak ESP 7 works from windows vista PC but not from Windows 7 64bit Laptop my email is sending out email from my contacts list that I am not aurthorizing How can I stop this mywinlocker s yo safe does not open My primary printer a Canon MP600 works fine on my HP Pc but will not respond to my aspire 1 notebook MS Office Word suddenly will not open My wireless printer will not print the bottom line of the border on a poster i designed in Word 2010 Why Help Microsoft Excel cannot create Pivot Table My workbook has suddenly become protected now I m opening in Excel 2007 not 2003 maps and graphics do not display Not abel to create new Partition from Unallocated memory Need to summarize data from one sheet into another using formulas HELP
Read More: How to Fix - Remote into my dad's iPad?,Solution to Error: Error Code: 80200053 (Can't install KB982,Troubleshooting:my shut down button for Windows 7 always has a orange shield with an ! indicating that an one upgrade is required, but it is never is performed. Why?,How to Fix Problem - can't login to advanced startup options due to inop key letter of password?Used on screen keyboard for regular use.?,Solution to Error: Windows 7 Errors with Windows Help and Support, Network Connection, and System Restore,Applying Computer Settings Taking a very long time in XP Pro,Hard Drive occasionally sounds like its racing.,why does my internet connection keep dropping?,IE9 Hangs loading MHT file,IE8 and yahoo mail