$$Excel-Macros$$ Pls help me..

Hi all,, I have attached the file, and explained the proble there only. I wanted to pick amount from another table by formula. I tried with vlookup i didnt get answer. Pls help me. Regards, Ram. --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials a

$$Excel-Macros$$ Need help for the below issue.

Hi All, I have a data like this in a single cell for eg A1 "11/4/2008 5:51:00 PM". I need date in A2 cell and time in in A3 cell. How to do it. Plz help me. Thanks in advance. --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.ex

$$Excel-Macros$$ Re: How to findout Duplicate items

Oops, error. Conditional format formula should be: =COUNTIF($A$2:$A$51,$A2)>1 Sorry - Dave From: [EMAIL PROTECTED] To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: How to findout Duplicate items Date: Tue, 4 Nov 2008 12:52:19 +0900 Hi, You can use Conditional format.

$$Excel-Macros$$ How to lock the cells.

Hello all, Could you pls explain me how to lock cells in the below scenario: - How to lock single cell - How to lock range of cells - how to hide the formula only for formula based cells. Regards, Ram. --~--~-~--~~~---~--~~ Visit the blog to download Excel tutori