Need feedback

All,

I sincerely thank everyone for taking your time out and reading my blog posts.It gives me immense motivation to come and post every day.

This is started as a general ledger for making myself accountable and keep me focused on objective technical analysis. It has helped me in my objective. Initially it remained as a private blog but after constant push from friends and critics I made it open to all. If you are using this blog then please use it as a reference only.

At this stage I would like to know from you as how useful these posts are and how I can make it better to help you. Hence I need you constructive feedback to shape it well. This can help me as well in my analysis.

Request everyone to leave a feedback or drop me a mail with your feedback.

Thanks a lot for your support.

Excel - How to search a cell value in a table?

Problem statement:
Suppose I have a excel sheet with a column {column A} with some set of data. Another  {Column B}with some set of data. Now I need to confirm whether the data in first column/cell exists anywhere in the second column. If it exists then indicate it by the data of the first column/cell or a Yes or No confirmation in an adjacent cell.

Solution:
I have tried the following combination in excel 2003 {ex. in column C}

=IF(ISNA(VLOOKUP(A2,$B$2:$B$600,1,FALSE)),"N",A2)


Why can't I use vlookup to achieve this? - Ans: I do not know :-) I have tried it but could not make it work.

Making the choice right

Someone sent me an interesting link on "If You Don't Prioritize Your Life, Someone Else Will"

Highlight :
"A 'no' uttered from the deepest conviction is better than a 'yes' merely uttered to please, or worse, to avoid trouble." So said Mahatma Gandhi, and we all know how his conviction played out on the world stage. But what is less well known is how this same discipline played out privately with his own grandson, Arun Gandhi.

Read more from the original place

MS Excel: Get contents of last cell in a range that has data in Excel 2010/2007/2003/XP/2000/97

This is a bit tricky and the formula that you need to use will depend on the types of data that you have in the range. Details I found it in the following link:

http://www.techonthenet.com/excel/questions/last_value.php