Wednesday, December 25, 2013

Excel: How To Reference Cells in Other Worksheets

For an Excel formula that needs to reference a cell in a different worksheet in the same workbook, use the following format for your formula.


SheetName!CellAddress (Precede the cell address with the worksheet name, and follow it with an exclamation point).

Note: For worksheet names that include one or more spaces, you will need to enclose it in single quotation marks. The following is a formula that refers to a cell on a sheet by the name of Monthly Sales:

=B4*’Monthly Sales’!A12
- See more at: http://www.tech-recipes.com/rx/1604/excel_how_to_reference_cells_in_other_worksheets/#sthash.4lmJrLfM.dpuf

Wednesday, December 18, 2013

While restarting network service my name servers in /etc/resolv.conf got vanished

While restarting network service my name servers in /etc/resolv.conf got vanished in CentOS

[root@Hostname ~]# /etc/init.d/network restart
Shutting down interface eth0:  Device state: 3 (disconnected)
                                                           [  OK  ]
Shutting down loopback interface:                          [  OK  ]
Bringing up loopback interface:                            [  OK  ]
Bringing up interface eth0:  Active connection state: activated
Active connection path: /org/freedesktop/NetworkManager/ActiveConnection/3
                                                           [  OK  ]


Solution:
While troubleshooting i noticed the box have "NetworkManager" installed. I removed it

[root@Hostname ~]# yum remove NetworkManager
It helped me to solve that issue.