Re: $$Excel-Macros$$ Look up Names from Contacts Sheet Display Name in an other sheet named call history.

2013-10-27 Thread ashwani agnihotri
hi. Plz find solution using vlookup with choose. regards, Ashwani On Mon, Oct 28, 2013 at 1:36 AM, Kashan Abbas kashanabbas...@hotmail.comwrote: plz find attached . -- Date: Sun, 27 Oct 2013 21:27:29 +0500 Subject: $$Excel-Macros$$ Look up Names from Contacts

Re: $$Excel-Macros$$ DEFINE NAME FUNCTION

2013-10-12 Thread ashwani agnihotri
can also use ctrl+F3 as shortcut key to open name manager and make the changes by clicking edit On Sat, Oct 12, 2013 at 10:54 PM, SUDHIR VERMA newinex...@gmail.com wrote: thnx On 12 October 2013 22:34, SUDHIR VERMA newinex...@gmail.com wrote: Dear Experts, How to edit edit in Define

$$Excel-Macros$$ Material on dashboards

2013-10-05 Thread ashwani agnihotri
Hi, Does anyone has good book/video links on dashboards. Please forward me the details. Thanks in advance. Regards, Ashwani -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @

Re: $$Excel-Macros$$ Query on Dashboard(urgent)

2013-10-03 Thread ashwani agnihotri
for this. ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *ashwani agnihotri *Sent:* Wednesday, October 02, 2013 7:20 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Query on Dashboard(urgent) ** ** Hi All, I have attached

Re: $$Excel-Macros$$ Query on Dashboard(urgent)

2013-10-02 Thread ashwani agnihotri
Hi All, Any update on this? Regards, Ashwani On Wed, Oct 2, 2013 at 7:20 PM, ashwani agnihotri ashwani.agniho...@gmail.com wrote: Hi All, I have attached an excel for reference I want to know if I can create a dashboard werein if I select a team , the rest of the data about the team

Re: $$Excel-Macros$$ Urgent- Query on lookup

2013-09-06 Thread ashwani agnihotri
, Please find attachment. Just drag the formula in F column if you need it. Regards, Kartik On Fri, Sep 6, 2013 at 11:03 AM, ashwani agnihotri ashwani.agniho...@gmail.com wrote: Hi, I have a query. I have two table named original and other. Now I want to look up for ID,s and check

Re: $$Excel-Macros$$ Urgent- Query on lookup

2013-09-06 Thread ashwani agnihotri
Hi, Can someone please help me with this? Regards, Ashwani On Fri, Sep 6, 2013 at 3:19 PM, ashwani agnihotri ashwani.agniho...@gmail.com wrote: Thanks for reply guys , but the output I was looking was that if the lookup table has ID 121 with Status as “ Ok” but in original table ID 121

Re: $$Excel-Macros$$ Urgent- Query on lookup

2013-09-06 Thread ashwani agnihotri
On Fri, Sep 6, 2013 at 8:54 PM, Kartik Dale kartik.1...@gmail.com wrote: Please find attachment, hope this is the result you are looking for. If i understood wrongly please let me know in breif Regards, Kartik On Fri, Sep 6, 2013 at 3:19 PM, ashwani agnihotri ashwani.agniho...@gmail.com

Re: $$Excel-Macros$$ Urgent- Query on lookup

2013-09-06 Thread ashwani agnihotri
Hi, I just realized that if i can search the values of table 2 in table 1 it will work for me i am not concerned with status now .. for ex...i want to search all the values( 121, 123, 124 ) present table 2 in table 1 ...please let me know the formula Regards, Ashwani -- Are you =EXP(E:RT)

$$Excel-Macros$$ Urgent- Query on lookup

2013-09-05 Thread ashwani agnihotri
Hi, I have a query. I have two table named original and other. Now I want to look up for ID,s and check for mismatch in the status in both table. For ex- If 121 is there in lookup table with status ok but the status of 121 in original table is active I should be able to detect the mismatch I

Re: $$Excel-Macros$$ VLOOKUP (CHOOSE) QUERY - URGENT HELP REQ.

2013-07-16 Thread ashwani agnihotri
hey plz go through this link for better understanding of using choose with vlookup.. http://www.myonlinetraininghub.com/excel-vlookup-to-the-left-using-choose On Tue, Jul 16, 2013 at 5:20 PM, Ashish Kumar kumar.ashish...@gmail.comwrote: Dear Seniors, kindly find attached vlookup query, I

Re: $$Excel-Macros$$ Need Help for formula

2013-01-04 Thread ashwani agnihotri
please see if this helps... On Fri, Jan 4, 2013 at 6:43 PM, jocky Beta jocky6...@gmail.com wrote: Hi Anoop, There is No formula in the attached sheet, :( On Fri, Jan 4, 2013 at 5:27 PM, Anoop K Sharma aks.sharm...@gmail.comwrote: Hi Jocky, Please find attached with solution. Regards,

Re: $$Excel-Macros$$ Query on Email via macro

2012-07-02 Thread ashwani agnihotri
*Someone please help me on this its important* On Sun, Jul 1, 2012 at 10:17 PM, ashwani agnihotri ashwani.agniho...@gmail.com wrote: i just want to send a mail with a subject plz check to the email address in column C for the rows in column B which i mark as done. On Sun, Jul 1, 2012 at 10

Re: $$Excel-Macros$$ Query on Email via macro

2012-07-02 Thread ashwani agnihotri
, Jul 2, 2012 at 8:08 PM, ashwani agnihotri ashwani.agniho...@gmail.com wrote: *Someone please help me on this its important* On Sun, Jul 1, 2012 at 10:17 PM, ashwani agnihotri ashwani.agniho...@gmail.com wrote: i just want to send a mail with a subject plz check to the email address

Re: $$Excel-Macros$$ Automatic Email from Excel

2012-07-01 Thread ashwani agnihotri
*guys does anyone has any opinion on this problem??? * On Fri, Jun 29, 2012 at 9:19 PM, ashwani agnihotri ashwani.agniho...@gmail.com wrote: Hi, I have a query..suppose i put some thing in column B and i have mail id in column C i want to sent the mail on that ID. In the example given

$$Excel-Macros$$ Query on Email via macro

2012-07-01 Thread ashwani agnihotri
Hi, I have a query..suppose i put some thing in column B and i have mail id in column C i want to send the mail on that ID. In the example given below if i enter done in column B a mail should be send on address entered in column C ABC ram sham

Re: $$Excel-Macros$$ Query on Email via macro

2012-07-01 Thread ashwani agnihotri
* *+91 7838100659 [IM-Gtalk]* ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *ashwani agnihotri *Sent:* 01 July 2012 9:49 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Query on Email via macro ** ** Hi, ** ** I

Re: $$Excel-Macros$$ Automatic Email from Excel

2012-06-29 Thread ashwani agnihotri
Hi, I have a query..suppose i put some thing in column B and i have mail id in column C i want to sent the mail on that ID. In the example given below if i enter done in column B a mail should be send on address entered in column C ABC ram sham

Re: $$Excel-Macros$$ MACRO

2012-05-29 Thread ashwani agnihotri
Hi Noorain, plz send me the files at ashwani.agniho...@gmail.com thanks... On Wed, May 30, 2012 at 10:48 AM, Anirban Roy excelanir...@gmail.comwrote: Noorain Bhai, Please send it to me, I'll be thankful to you. With Best Regards Anirban -- FORUM RULES (986+ members already BANNED