To All,
- Forwarded Message -
From: Aamir Shahzad
To: excel-macros@googlegroups.com
Sent: Wednesday, May 23, 2012 1:42 AM
Subject: Re: $$Excel-Macros$$ unable to use advance vlookup
I don't think so or any other group member can provide solution.
Regards,
Aamir Shahzad
On
Hi Group,
please tell How to create running time in excel sheet??
--
*Thanks & Regards*
*Pravesh Kumar*
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem,
Dear Satish,
Please try with ctrl+shift+Enter
=INDEX($N$4:$S$10,MATCH(E$4,$M$4:$M$10,0),MATCH($D7,$N$3:$S$3,0))
See attached sheet..
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Tue, May 22, 2012 at 11:11 PM, satish pn wrote:
> Mr. Rajan Verma
>
Please find the file
Hi all,
I have a task that I can achieve up to one point using vlookup but
afterwards I need to manually add rows or columns to update the data with a
new set of data. It is understood the from the first set nothing should be
deleted. Even if one row is empty from the first s
Hi all,
I have a task that I can achieve up to one point using vlookup but
afterwards I need to manually add rows or columns to update the data with a
new set of data. It is understood the from the first set nothing should be
deleted. Even if one row is empty from the first set is not present
I don't think so or any other group member can provide solution.
Regards,
Aamir Shahzad
On Tue, May 22, 2012 at 10:03 AM, LAKSHMAN PRASAD wrote:
> Plz see the attached file
>
>
>
>
>
> *From:* Aamir Shahzad
> *To:* excel-macros@googlegroups.com
> *Sent:* Monday, May 21, 2012 11:27 PM
>
> *Su
Hello Satish,
One way is VLOOKUP
E5, then copy down & across.
=IFERROR(VLOOKUP(E$4,$M$4:$S$10,MATCH($D5,$M$3:$S$3,0),0),"")
Regards,
Haseeb
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Ne
What output you want ?
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of satish pn
Sent: 22 May 2012 11:19
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Change in one Cell should le
No... it didnt work... :-(
On Tue, May 22, 2012 at 11:15 PM, Rajan_Verma wrote:
> ** **
>
> ** **
>
> Try this:
>
> ** **
>
>
> =TRANSPOSE(OFFSET(INDEX($K$3:$K$10,MATCH(C4,$K$3:$K$10,0),1),,1,,COUNTA($L$5:$Q$5)))
>
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM
Hello Deba,
FYI:
If you use "LD000" as constant this will add with each number, means when
gets 10-99, this will become, LD00010, when gets 100-999 will become
LD000100.
If you want to keep the format, "LD", 1-9 - LD0001, 10-99 - LD0010,
100-999 - LD0100, 1000- - LD1000, here is on
Try this:
=TRANSPOSE(OFFSET(INDEX($K$3:$K$10,MATCH(C4,$K$3:$K$10,0),1),,1,,COUNTA($L$5
:$Q$5)))
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of satish pn
Sent: 22 May 2012 11:11
To: excel-ma
Mr. Rajan Verma
Please find attached excel file for a small example.
On Tue, May 22, 2012 at 9:10 PM, Rajan_Verma wrote:
> Please send some sample data in Excel Worksheet
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@goog
Hello Amit,
Keep PO Bill & Party Bill on different tab, so can easily update it. See
the attached.
Addition: If you use Table format, formula will automatically insert, when
you enter a new data. Or use dynamic range to limit calculation range. If
you wish, you can also create a validation l
Please send some sample data in Excel Worksheet
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of satish pn
Sent: 22 May 2012 8:42
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Change in o
Hello experts,
I am trying to compile the data of various parameters as on every friday.
Various parameters will be in rows one below the other and date in column.
What i need now is, when ever i change the date (i want the drop down menu
for selecting dates, please note date keeps getting added
see if it helps choose product in yellow cell
On Tue, May 22, 2012 at 7:54 AM, pankaj gmail account
wrote:
> Thanks for quick response.
>
> Please find attached data.
>
> I donot want to use pivot table for this.
> this is just a new imagination can we do this in excel. Linked Drill down
> Charts
I have attached a sample file to show what i mean. I have managed to copy
the grouped objects from a single slide.
However the complication arrises when I have to copy and collate the
objects when they are on different slides.
i.e. if i want to copy object 1 and 2 from slide 1 and 9 and 10 from
Thanks Mr. Anil
You have almost solved my query. But I need it more dynamic. You have made
this formula cell specific and I need the formula which I can copy & paste
across all rows and it will give me result in one instant. Say for example,
if I will add same B/L no again at row 21, i won't get t
*Dear Anil and Experts,
The formula you have given was absolutely correct. Thanks once again for
the same. Thank you very very much.*
Thanks & Regards,
Deba Ranjan P
On Tue, May 22, 2012 at 3:53 PM, hilary lomotey wrote:
> Just add =if(b3<>"","LD000","")&if(b3<>"",counta(b$3:b3),"")
Just add =if(b3<>"","LD000","")&if(b3<>"",counta(b$3:b3),"")
On Tue, May 22, 2012 at 10:10 AM, Deba Ranjan wrote:
> *
> *Hi Anil Sir,
>
> Thats fine working, but i need in this look:- LD0001, LD0002,
> LD0003so on. Can you please do on this !! actually your attached file
> is fine working
*
*Hi Anil Sir,
Thats fine working, but i need in this look:- LD0001, LD0002,
LD0003so on. Can you please do on this !! actually your attached file
is fine working in serial numbers. Please i want the serial in LD0001,
LD0002so on. Please and thanks Anil sir, and other experts.
Thanks
21 matches
Mail list logo
