please see if this helps...
On Fri, Jan 4, 2013 at 6:43 PM, jocky Beta wrote:
> Hi Anoop,
>
> There is No formula in the attached sheet, :(
>
> On Fri, Jan 4, 2013 at 5:27 PM, Anoop K Sharma wrote:
>
>> Hi Jocky,
>>
>> Please find attached with solution.
>>
>> Regards,
>> Anoop
>> Sr. Developer
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 wrote:
>
>
> Dear Seniors,
>
> kindly find attached vlookup query, I want get output thru
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 a
ttachment. 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
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
On Fri, Sep 6, 2013 at 8:54 PM, Kartik Dale 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
>
> 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:R
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
comes automatically. Like I apply data validation on team and select
powerteam I want all the employees along with their productivity and
qualit
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
:* 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 Al
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 @
https://www.facebook.com/
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 wrote:
> thnx
>
>
> On 12 October 2013 22:34, SUDHIR VERMA wrote:
>
>> Dear Experts,
>>
>> How to edit edit in Define Name Function after applicable.
>
hi.
Plz find solution using vlookup with choose.
regards,
Ashwani
On Mon, Oct 28, 2013 at 1:36 AM, Kashan Abbas wrote:
> plz find attached .
>
> --
> Date: Sun, 27 Oct 2013 21:27:29 +0500
> Subject: $$Excel-Macros$$ Look up Names from Contacts Sheet & Display Name
>
Hi Noorain,
plz send me the files at ashwani.agniho...@gmail.com
thanks...
On Wed, May 30, 2012 at 10:48 AM, Anirban Roy wrote:
>
> Noorain Bhai,
>
> Please send it to me, I'll be thankful to you.
>
> With Best Regards
> Anirban
>
> --
> FORUM RULES (986+ members already BANNED for violation
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
*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.
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
verma*
>
> *+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:* $$Exc
*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.
>
> O
"ffffff"
> .Display '\ .send
> End With
> Set olApp = Nothing
> Set olMail = Nothing
> End Sub
>
>
>
>
> On Mon, Jul 2, 2012 at 8:08 PM, ashwani agnihotri <
> ashwani.agniho...@gmail.com> wrote:
>
>> *Someone please help me on
20 matches
Mail list logo