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

Is your sheet using simple Vlookups,also i have a dependency on months as well. YOur vlookup only use the Region n product but doesnt use which month's share to pick up(its by default picking values for aug07,how the formula is changed if i need to pick sep07 values or any other)). As per your for

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

just use the pivot table put the data in the row area and same in the data area also then go to field setting and change field to count_it will show you the the repeated item with the occurence --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at h

$$Excel-Macros$$ Excel Macros totaling like values

How do I create a macro in Excel that will count the number of like values in a cell? For Example: "how many people live in each city" in an excel spreadsheet of names and addresses --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.ex

$$Excel-Macros$$ Use of Array Formula or other method to create deduplicated list of text values?

Ladies & Gents: I’m an experienced excel user (10+ years) and have encountered a problem that I cannot figure out. I’m creating a tool where there is a free text area where the users will input a list of locations (up to 60 values that can repeat and are in no particular order - some cells can b

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

A2 =TEXT(A1,"MM/DD/YY") --> u will find date 11/4/2008 A3 =TEXT(A1,"HH:MM:SS AM/PM")--> u will find Time 5:51:00 PM Regards Harish Upadhyay On 11/4/08, vinu <[EMAIL PROTECTED]> wrote: > > > Hi All, > > I have a data like this in a single cell for eg A1 "11/4/2008 > 5:51:00 PM". > > I

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

Please find attached the file.. there are 2 ways it can be done and both the formulas are in the file.. Ajit From: excel-macros@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of ram bhagath Sent: Tuesday, November 04, 2008 6:27 PM To: excel-macros@googlegroups.com Subject: $$Excel-Mac

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

Dear Ram Use Pivot Table, it is simpler then vlookup Regards On Tue, Nov 4, 2008 at 11:57 PM, ram bhagath <[EMAIL PROTECTED]> wrote: > 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 di

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

Use below functions: For date: =TEXT(A1,"mm/dd/") For time: =TEXT(A1,"hh:mm:ss AM/PM")  A1 is the cell where the data (date and time) is stored. _ "There are known knowns. These are things we kn

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

Hi, Probably you cannot find any proper formula for your problem. Following function may help you. [tools->Macro->visual basic editor] will get you to macro editor [insert-> module] and copy paste the following function. You need to see how the function is used as formula in the attached file. '--

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

Hi, Check the attached XL to see if it does what you need. Regards - Dave. Date: Tue, 4 Nov 2008 18:27:22 +0530From: [EMAIL PROTECTED]: [EMAIL PROTECTED]: $$Excel-Macros$$ Pls help me.. Hi all,, I have attached the file, and explained the proble there only. I wanted to pick amount from ano

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

Hi Ram, Solution is attached herewith in EXCEL. Use of Pivot table may give you this solution. Regards, Hitesh Dhare +919824004308 New * Email ID: [EMAIL PROTECTED] From: excel-macros@googlegroups.com [mailto:[EMAIL PROTEC

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

Hi.. This is very easy. Just use the left function/right function to get the data from one cell. like.. A1 B1 C1 11/4/2008 5:51:00 PM=left(a1,9) =right(a1,10) On 11/4/08, vinu <[EMAIL PROTECTED]> wrote: > > > Hi All, > > I h

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

right click on cell and go to Format -> Protection tab.. if locked box is checked, cell will locked after protecting the sheet. If hidden box is checked, cell formula will be hidden (i.e. will not show in formula bar) after protecting the sheet. To lock a range, select your range and then go to 

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

Hi Vijender, Its not working.. I have attached the XL file below pls look into the same. The right/left function wont work as date is not in a text formate. Regards, Vinu. 2008/11/5 vijender kumar <[EMAIL PROTECTED]> > Hi.. > > This is very easy. Just use the left function/right function to ge

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

Chk attached file Regards Harish Upadhyay On 11/4/08, ram bhagath <[EMAIL PROTECTED]> wrote: > > 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. > > Reg