Re: $$Excel-Macros$$ Help in Excel

2011-03-09 Thread Mahesh parab
Hi this link will help u http://office.microsoft.com/en-us/excel-help/how-to-look-up-a-value-in-a-list-and-return-multiple-corresponding-values-HA001226038.aspx On Wed, Mar 9, 2011 at 4:07 PM, Rajiv Kumar wrote: > > Dear Sir. > > > Please Experts I have duplicates data from one column so how

$$Excel-Macros$$ Extracting address from a file

2011-03-09 Thread CAN
First of all, thank you for all the help that I received so far. You guys are great. Today I have the following problem. I have a file where all the data is on column A. The data is listing the name of a person in row 1, in row 2 and row 3 it list the address. from the sample below I like to

Re: $$Excel-Macros$$ Please help on Excel.

2011-03-09 Thread ChilExcel
sorry, use this formula in data validation =CONTAR.SI ($C$2:$C$30;C2)=1 2011/3/9 ChilExcel > Hi > > use this formula in data validation > > =CONTAR.SI($C$2:$C$30;C1)=1 > > > > chilexcel > > > Visita ; http://sites.google.com/site/chilexcel/Home > Visita ; http://www.youtube

Re: $$Excel-Macros$$ Please help on Excel.

2011-03-09 Thread ChilExcel
Hi use this formula in data validation =CONTAR.SI($C$2:$C$30;C1)=1 chilexcel Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 2011/3/8 Rabindra Thapa > Dear all, > > > > I have one attach file where I am keeping the serial pipe number b

Re: $$Excel-Macros$$ Re: very urgent

2011-03-09 Thread Jorge Marques
Here you have a simple pivot table excel. just play a little with the pivot table field list to undestand the concept. 2011/3/8 Jim > Hello, > I'm assuming that you are trying to understand pivot tables. There > are some great videos on www.youtube.com. > > Search for: excel pivot table >

$$Excel-Macros$$ Help in Excel

2011-03-09 Thread Rajiv Kumar
Dear Sir. Please Experts I have duplicates data from one column so how do complete data from duplicate with vlookup and any more... Plz find attc. -- *Thanks & Regards * *Rajiv Kumar * *Mawana Sugar Works, Mawana * *Mo.No: 09027414899* -- ---

$$Excel-Macros$$ Help in Excel

2011-03-09 Thread Rajiv Kumar
-- *Thanks & Regards * *Rajiv Kumar * *Mawana Sugar Works, Mawana * *Mo.No: 09027414899* -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldaily

Re: $$Excel-Macros$$ OT

2011-03-09 Thread Paul Schreiner
Yeah, well... I get that way too... Sometimes things just NEED to be said! I use several strings for testing, depending on what I'm testing for.. I get tired of "this is a text string", so I use whatever happens to float to the top of the mind puddle... (muddle?) Most are misquotes from movies, a