Re: $$Excel-Macros$$ Re: Help need to get multiple values by vlookup

I have registered thanks as well On Thu, Oct 25, 2012 at 11:06 AM, ashish damor wrote: > Dear Aamir, > > The registration is free and it does not take even 5 minutes to register. > > On Thu, Oct 25, 2012 at 10:52 AM, Aamir Shahzad > wrote: > > Dear Rajan, > > > > If you have file plz share with

Re: $$Excel-Macros$$ Re: Help need to get multiple values by vlookup

Dear Aamir, The registration is free and it does not take even 5 minutes to register. On Thu, Oct 25, 2012 at 10:52 AM, Aamir Shahzad wrote: > Dear Rajan, > > If you have file plz share with us, your required link want to register > first. > > > > On Thu, Oct 25, 2012 at 8:23 AM, Rajan_Verma >

Re: $$Excel-Macros$$ Re: Help need to get multiple values by vlookup

Dear Rajan, If you have file plz share with us, your required link want to register first. On Thu, Oct 25, 2012 at 8:23 AM, Rajan_Verma wrote: > Hi > > Download the file from here > > http://www.excelfox.com/forum/f12/vlookup-return-multiple-values-4/ > > Thanks > Rajan. > > On Wednesday, 24 Oc

$$Excel-Macros$$ Nice Chart

Dear Rajan, Excellent work buddy.Can you please mention the steps required to create a chart like that?Does it work with Excel 2007? Regards. P.VIJAY KUMAR -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for viol

Re: $$Excel-Macros$$ Help need to get multiple values by vlookup

Pl Share a sample sheet with us On Thu, Oct 25, 2012 at 9:52 AM, David Grugeon wrote: > It seems to me that sorting might be a better approach than a vlookup. > > Regards > David Grugeon > > > On 25 October 2012 14:15, Saravanan wrote: > > Hi > > > > I need this because need to know which are a

Re: $$Excel-Macros$$ Help need to get multiple values by vlookup

It seems to me that sorting might be a better approach than a vlookup. Regards David Grugeon On 25 October 2012 14:15, Saravanan wrote: > Hi > > I need this because need to know which are all the items belongs to one > value. By this values I can assign the items need to work. > > Thanks, > Sar

Re: $$Excel-Macros$$ Help need to get multiple values by vlookup

Hi I need this because need to know which are all the items belongs to one value. By this values I can assign the items need to work. Thanks, Saravanan. On Oct 25, 2012, at 12:13 AM, Paul Schreiner wrote: > Are you saying that your VLookup Value occurs in multiple rows in your table? > or th

$$Excel-Macros$$ Re: Help need to get multiple values by vlookup

Hi Download the file from here http://www.excelfox.com/forum/f12/vlookup-return-multiple-values-4/ Thanks Rajan. On Wednesday, 24 October 2012 22:51:01 UTC+5:30, saravanan R wrote: > > Hi xlts, > > Please help me, on how to get the all the associated items In the range > where it as more

Re: $$Excel-Macros$$ Excel Graph Problem

Thanks Rajan, But did you see the sample I sent with my original post. Is this possible with my data file? Regards Rashid On Tuesday, October 23, 2012 7:04:02 PM UTC+4, Rajan_Verma wrote: > You will get desired here.. > > http://www.excelfox.com/forum/f13/excel-dynamic-waterfall-chart-317/** > >

Re: $$Excel-Macros$$ Help need to get multiple values by vlookup

Are you saying that your VLookup Value occurs in multiple rows in your table? or that you want to return multiple values from the single match? Then.. what do you want to do with the results?   Paul - “Do all the good you can, By all the means you can, In al

$$Excel-Macros$$ Help need to get multiple values by vlookup

Hi xlts, Please help me, on how to get the all the associated items In the range where it as more than 1 lookupvalue. Thanks, Saravanan -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use conc

Re: $$Excel-Macros$$ Masking Password in input box *

Hello Again, Pls how to i combine the code below here to the code in this attached workbook (got it on the web) to achieve my desired results. Desired results being being able to password protect a sheet worksheet (just as the code below is doing only that its not masking the password). The attach

Re: $$Excel-Macros$$ Masking Password in input box *

Hello Pls see attatched file as example On Wed, Oct 24, 2012 at 4:45 PM, Hilary Lomotey wrote: > Thanks Ashish, > > one question do i paste the same code in the userform? how do i go about > it pls > > On Wed, Oct 24, 2012 at 3:17 PM, ashish koul wrote: > >> [image: Boxbe]

Re: $$Excel-Macros$$ Masking Password in input box *

Thanks Ashish, one question do i paste the same code in the userform? how do i go about it pls On Wed, Oct 24, 2012 at 3:17 PM, ashish koul wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (koul.ash...@gmail.com) Add cleanup > rule

Re: $$Excel-Macros$$ Masking Password in input box

use userform and textbox instead of msgbox and in text box choose * in passwordchar [image: Inline image 1] On Wed, Oct 24, 2012 at 8:44 PM, Hilary Lomotey wrote: > Hi Exxperts > > I got this code to protect a worksheet, which was exactly what i was > looking for only that entering the pass

$$Excel-Macros$$ Masking Password in input box

Hi Exxperts I got this code to protect a worksheet, which was exactly what i was looking for only that entering the password into the input box is unmasked so everyone standing by can see your password. can i get a code to mask the password input?. or better still another code to ask for passwo

Re: $$Excel-Macros$$ Highlight annual leave schedule of each staff for easy comparison

That's a start... but it doesn't have all of the days of the year. (you probably noticed that) Several years ago (10+?) I put together an attendance tracker for my supervisor. There were separate sheets for each individual in the department, then a summary sheet that displayed how many people were

Re: $$Excel-Macros$$ Highlight annual leave schedule of each staff for easy comparison

Hi Nice work, you can automate it through conditional formating. Rgds//Vabs On Wed, Oct 24, 2012 at 12:49 PM, Yahya Muhammad wrote: > Hi experts > > I want to compile the annual leave schedule of each staff in the > department in excel. The idea is to have all the schedule in one work > sheet,

Re: $$Excel-Macros$$ Query for applying the formula

Hi It could not be so. Check whether you have provided correct sheet name in your project sheet also.. Rgds//Vabs On Wed, Oct 24, 2012 at 4:05 PM, Kenil Gala wrote: > Hi all, > Pls help me solve my query. > I have written my query in the attachment . > > Thanks & Regards. > > -- > Join offici

$$Excel-Macros$$ Highlight annual leave schedule of each staff for easy comparison

Hi experts I want to compile the annual leave schedule of each staff in the department in excel. The idea is to have all the schedule in one work sheet, for easy comparison and to know the leave overlapping,if any, at one glance. Currently I am using the attached sheet, which I think, can be modif