Troubleshooting:original cell location (identity)

original cell location (identity)

I need to know which cell from a nested if has transmitted data to a given cell -- so I can use the location of the original cell (the one which provided the orginal data) in a formula.
I am confident this will be easy for some of you out there.

Solutions to the Problem original cell location (identity)

Download Error Fixer for Free Now

If the choices are in a single column or row, you could use the Match Function
 
=Address(match(B5,A:A,0),1)
where B5 has the nested if function returning a value found in only on row in column A.
--
Regards,
Tom Ogilvy

Windows Recovery - Totally Fix All Errors including original cell location (identity)

• Click on the Start button on the Taskbar.
• Type "System Restore" (without quotes) in the Search box and hit Enter or,
• Click on System Restore (when you see System Restore pop up  in the list of search results).
• Make sure the "Recommended restore" radio button is checked on the restore utility window.
• Click on Next and follow the instructions given.

Note: There is the option on the restore utility to select "Choose a different restore point". Unless you have a specific reason to select a different date and time than what Windows recommends, just select the recommended option stated in the steps above. If you choose to select another one, follow these steps:

Click on that desired date and time, and Windows 7 will perform a scan for any affected programs in that restore point.

Once completed, click Next and follow the instructions given.

Once you have selected the restore point, your system will start the restoring process, after which you will have to restart the system.

Another Safe way to Fix the Problem: original cell location (identity):

 

 

How to Fix original cell location (identity) with SmartPCFixer?

1. Download Error Fixer . Install it on your system.  Click Scan, and it will perform a scan for your computer. The errors will be shown in the list.

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

3. The Repair part is done, the speed of your computer will be much higher than before and the errors have been fixed. You can also use other functions in SmartPCFixer. Like dll downloading, windows updating and print spooler error repair.

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,Troubleshoot:After waking from sleep, program windows are located off screen,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.?,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