$$Excel-Macros$$ Re: How to hid formula in a cell or sheet

go to Format Cell -Protection - click on Hidden Check Box - OK then Tools - Protection - Protect Sheet - Enter Password Regards Harish Upadhyay On 10/29/08, vinu [EMAIL PROTECTED] wrote: Hi All, Could you pls let me know how to hide and unhide only formula in a particular cell or a

$$Excel-Macros$$ Re: Concatenate

Thanks a lot!! On Oct 30, 8:26 pm, Ajay Varshney [EMAIL PROTECTED] wrote: =A1 B1 TEXT(C1,HH:MM AM/PM) Use the above forlula On Thu, Oct 30, 2008 at 11:19 AM, vinu [EMAIL PROTECTED] wrote: How to concatenate the below one. A1=India B1=Bangalore C1=12:10Am Thanks in advance.

$$Excel-Macros$$ Re: how to activate double click

Thanks a lot!! On Oct 31, 1:03 am, Sumeet Jain [EMAIL PROTECTED] wrote: Try going to Tools - Options - Edit. On left hand side under Settings, you would see the option Edit directly in cell. Enable it by putting a tick mark and say ok. Now, you should be able to double click directly into the

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

Hello All, Could you pls help me out in the below issue. I have 50 amounts in a single column, those are repeated amounts. I would like to know which are all repeated amounts by highlighting or something like that. Thanks -- Vinu (¨`*.*´¨) Always `*.¸(¨`*.*´¨) Keep (¨`*.*´¨)¸.*´ Smiling!

$$Excel-Macros$$ Re: Concatenate

=A1B1TEXT(C1,HH:MM:SS) Regards Harish Upadhyay On 10/29/08, vinu [EMAIL PROTECTED] wrote: How to concatenate the below one. A1=India B1=Bangalore C1=12:10Am Thanks in advance. Vinu. --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at

$$Excel-Macros$$ Re: Number ranges in a cell

Your question is not quite clear. Make it more understandable. Akhilesh On Thu, Oct 30, 2008 at 8:28 AM, Amanda [EMAIL PROTECTED] wrote: I have a spreadsheet I would like to upload with the column in question - how do I upload it? --~--~-~--~~~---~--~~

$$Excel-Macros$$ To get information from a specic cells base don multiple conditions

In the below data my aim is to get information from a specific cell based on a specific conditions. In the data sheet you can see tables for different regions say atlanta and also different product names under them and their shares in different months Ex:Suppose i want to know the share% of

$$Excel-Macros$$ Autofilters in VBA

I want that i write a code which filters the data say A on field target_group. Ex- i give the criteria in code as target_group='PSY' and i get that filtered list say B in another worksheet or a temperory memory. After that I'll again filtered the list B on the field date ex: (date=7/1/2006 and

$$Excel-Macros$$ Find Date Macro

Hi, I am trying to create a macro that searches for a specific date in a sheet with many dates. I would like a textbox to come up and ask what date to look for. After inserting the date in the text box up I get an error. Do you know what I need to change to get it to look up the date that was

$$Excel-Macros$$ Date search for inputbox

Hi, I have a sheet with many dates and I am trying to find a specific date after which it should prompt information to be but next to the date. I run a macro that brings up a inputbox and ask for the date but then it is unable to find the specific date. I am not sure what I need to change below

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

Use below code. Sub DupFinder() Dim r As Range, t As Range Cells(1, ActiveCell.Column).Select Range(Selection, Selection.End(xlDown)).Select Set t = Selection For Each r In t v = r.Value If Application.WorksheetFunction.CountIf(t, v) 1 Then r.Interior.ColorIndex = 3 End If Next End Sub Select