Search results

Thanks G! I managed to have a look(will work on it later over the weekend) Have send you message in your inbox!

Thanks! I shall wait for that I first tried to use Vlookup then Match+ Index etc.but somehow was not able to arrive at consistent result

Thanks G! How did you start to create code etc so that I can try it on own when I have time I am not a VBA/Macro guy so if it involves that I will not poke my nose further! Tha

Thanks G! I seem to get slowly Now need more of your inputs here! My actual working official file where I need to use has data for whole month working days (say for decemeber 1 to December 31st barring saturday/sundays). If I use your file..it doesnt shows full month data. I may have to edit...

Hi G, Thanks for reply. I started to do as you told. I opened your file "ShankarPQTranspose".xlsx but I get this error? Also, sorry if it sounds silly, can you guide me more on what exactly I have to do with this file and how to make changes using this file to my earlier posted files...

I can enter date manually in first column and drag( thats not a problem) and yes data in those five columns (actually there are more columns) should copy from original file corrosponding to that date Hope I am clear

Hi G, Yes, I am using excel 2016. Sorry I did not understood how to do it and make changes. I could find "New query" tab under "data" but after that I could not understand Could you please explain it in detail. I do not know much coding/VBA but will try to apply here with whatever I know

Hi, I need to copy data from other file for the days of month. However, when I use hyperlink and drag it down/left/right .it does not pick correct values. How to do this linking for all days? Attaching file with sample data and kind of output I want I need to copy data from "Original...

Hi, I need to copy data from other file for the days of month. However, when I use hyperlink and drag it down/left/right .it does not pick correct values. How to do this linking for all days? Attaching file with sample data and kind of output I want I need to copy data from "Original...

Hi, I need to copy data from other file for the days of month. However, when I use hyperlink and drag it down/left/right .it does not pick correct values. How to do this linking for all days? Attaching file with sample data and kind of output I want I need to copy data from "Original...

Thnaks, Can you please explain logic...may be breaking down bit so that I can understand in much better way..

@Rahul, Thanks, The issue here I cant modify two files (add rows/delete rows), so if I do not use column E and simply use formule,will it work? Secondly, I need to refer to other file if I reference to that , is it fine?

Anyone/Narayan, Would be grateful if you could type formulae for me to get output. I could not understand it

Hi, I have two excel files. and when I use Vlookup to copy values from one file (sample original file) to another (similar file) , its not working for duplicates. After checking, I see there are lots of duplicates and its picking first value. How do I put it to get all values ? I tried to use...

any one , please reply

Hi, I have below loan ammortization sheet. Now, the interest rate on the loan has changed from original (9.75) to (9.35) in Oct 2015. Can changes be made in same sheet so that I can see ammortization schedule with varying interest rates like Principal + interest (EMI) charged with 9.75 till...

Hi Sirbj7, Apologies for that! I will keep this in mind, thanks for telling me , Regards

Hi sirjb7, I understand your point , but this is what the desired output req is, I re-checked it with source.

@sirjb7 no..what i mentioned is correct only, what u wrote i also got the same one..but the correct output should be 10.20,10.30, 10.70 you see , for cell d22, we dont take any extra employee, but continue with existing one.. ell d22= here we opt to continue with employee of previous...

Can anyone help with excel conditions to answer this. please help me for sheet1 the link is http://speedy.sh/hG8h6/book1.xls I got the logic , but i am unable to frame excel code for this(this has been my problem most of the times), so here we go the total addition is =opening output+...

@hui sheet2, I got the logic..thanks Let me explain now sheet 1, I got the logic , but i am unable to frame excel code for this(this has been my problem most of the times), so here we go the total addition is =opening output+ output addition per month*output efficiency for that month...

@hui. please explain logic of sheet 2 ie D18: =IF(D$17>=$B3,$C18,0) I want answer in date(revenue start date) , i guess , what formula is showing is monthly sales quantity I will check for total addition one. and get back to you

Hi, Can anyone help with excel conditions to answer this..I have put two separate ques in same file, please answer both sheet1 and sheet2...the link is. http://speedy.sh/hG8h6/book1.xls thanks in advance

thanks a lot Hui, this is what i wanted..agains thanks a ton!

Hi, old chippy, hui, I am aware of this..but the thing is again I have to click on FX to get it..for example . If I type =V....all formulae with =v comes up..now if I want to get =varpa, I have to either type or click on Fx (next to varpa)..isnt something like this possible where I can scroll...