Dear Group member,
I wrote small macro which works fine.
But when I run macro it shows all action i.e everything ishappening in
front of user which I dont want .
I want that when I run macro Worksheet should be steady and all actions
should happen at backend.
How to do it please let me know.
Is th
Hi,
No questions on this forum..
Can some body share some good stuffs..
Rgds//Vabs
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like P
Don, I apologize for a delayed response, your response was shuffled my
"junk" mail, and I had overlooked it. I appreciate you looking at my request.
I'm not a programmer, so you are right on, I often do things the hard way, not
knowing the easy way. Let me re-think the request and better
use this
IF(COUNTIFS(A:A,A2,B:B,B2)=COUNTIFS(A:A,MAX(A:A),B:B,B2),"Active","Deactive")
drag it down
On Thu, Oct 18, 2012 at 11:18 AM, Manoj Kumar wrote:
>
>
> Dear Expert.
>
> Please help me..
> File attached below..
>
> Regard
> Manoj
>
>
> --
> Join official facebook page of this forum @
>
His logic is that all people who are listed against the latest date
are active there and wherever else they appear.
People who are not active on the latst date are inactive
Regards
David Grugeon
On 18 October 2012 16:55, Vabz wrote:
> hi
>
> what is logic, i am not able to get it.
>
> Please ex
Hi Haseeb,
Thanks for your mail. this is really help me. but I have some point which
can make it more effective and efficient.
- Department code will be written automatically.
- and , another point is, If any employee salary is going in two
percentage(%) (as in sonu),we do not need to w
below formula also can use with C+S+E
=IF(MAX(IF($B$2:$B$17=B2,$A$2:$A$17)) wrote:
> Thanks
>
>
> On Thu, Oct 18, 2012 at 1:05 PM, Vabz wrote:
>
>> Hi
>>
>> PFA..
>> Cheers..
>> Rgds//Vabs
>> On Thursday, October 18, 2012 12:32:21 PM UTC+5:30, Manoj Kumar wrote:
>>
>>>
>>>
>>> -- Forwar
Hi
You can do that with simple Vlookup function.
Rgds
On Thursday, October 18, 2012 3:25:30 PM UTC+5:30, Manoj Kumar wrote:
>
> Hi,
>
> I want to know if coll "A" Data found in Coll "C", it found the value of
> Coll "A". using sumproduct..
>
>
> On Thu, Oct 18, 2012 at 3:08 PM, Vabz > wrote:
>
Hi
Then you are getting correcr answer, try Multiplying 1 with Text Value eg.
1 x V5/A & G-040 results in to #VALUE!.
You can get values only data is non text one.
Rgds//Vabs
On Thursday, October 18, 2012 3:25:30 PM UTC+5:30, Manoj Kumar wrote:
>
> Hi,
>
> I want to know if coll "A" Data found
hi All,
I have generated the html and saved in D:\user\test\tst_1.html
Again i am using one macro to attach that file in mail, but cant able to
attach the html file in mail.without attachment the mail program is working
fine.
kindly do the needful.
On Wed, Oct 17, 2012 at 3:00 PM, Vignesh S R wr
Hi
What exactly you are trying to do.
Rgds//Vabs
On Thursday, October 18, 2012 3:05:31 PM UTC+5:30, Manoj Kumar wrote:
>
> Dear Expert,
>
> please help tell me i am doing something wrong in this formula..
> A B c Store ID Store ID V5/A & G-199 #VALUE! V5/A & G-016 V5/A &
> G-016 #VALUE!
Thanky very much for great guidelines for me.This is very useful for
solution
Thanks again..
On Thu, Oct 18, 2012 at 1:20 PM, Asa Rossoff wrote:
> Sparklines in-cell charting was added as a native feature in Excel 2010,
> although it is not as sophisticated as the addin you are using
Thanks Paul Schreiner . Thank u very much.
Cheers...
REgards
Gawli Anil
On Wed, Oct 17, 2012 at 12:22 AM, Paul Schreiner wrote:
> first: a little "Group Etiquette":
>
> Being in the United States, I'm in a different time zone than many people
> who participate in these forums.
> Therefore, whil
Sparklines in-cell charting was added as a native feature in Excel 2010,
although it is not as sophisticated as the addin you are using.
I am not an expert on the add-in, in fact, it looks great, but I have never
used it.
For help on the proper way to use it I recommend you check the manual
Thanks
On Thu, Oct 18, 2012 at 1:05 PM, Vabz wrote:
> Hi
>
> PFA..
> Cheers..
> Rgds//Vabs
> On Thursday, October 18, 2012 12:32:21 PM UTC+5:30, Manoj Kumar wrote:
>
>>
>>
>> -- Forwarded message --
>> From: Manoj Kumar
>> Date: Thu, Oct 18, 2012 at 12:29 PM
>> Subject: Need fo
Hi
PFA..
Cheers..
Rgds//Vabs
On Thursday, October 18, 2012 12:32:21 PM UTC+5:30, Manoj Kumar wrote:
>
>
> -- Forwarded message --
> From: Manoj Kumar >
> Date: Thu, Oct 18, 2012 at 12:29 PM
> Subject: Need formula to update status
> To: excelvb...@googlegroups.com
>
>
> Dear Exp
Dear Asa,
Actually I want to sparklines also piechart,barchart in single cell in
excel 2003 (I Used this version) So I will try it to export only certain
chart.There are any option in excel 2003 for sparklines,piechart,barchart
in single cell then I will not try to export chart from other file
Rega
-- Forwarded message --
From: Manoj Kumar
Date: Thu, Oct 18, 2012 at 12:29 PM
Subject: Need formula to update status
To: excelvbacli...@googlegroups.com
Dear Expert,
Please Find the attachment..
Please provide me a formula to update status in coll "F"
Regard
Manoj
--
Join o
18 matches
Mail list logo
