Hi Ashish,
Just go through this link... you have good examples...
http://chandoo.org/wp/2008/11/12/using-countif-sumif-excel-help/
Thanks,
Raj
On Mon, Jul 29, 2013 at 8:41 PM, Prabhu Pinky wrote:
> Sumif - used to sum the range by checking single condition.
> Sumifs - used to sum the range by
Rekha,
Just try this code instead of or change it to And
With ThisWorkbook.Worksheets("Bex File")
Set rng = .Range("A1").CurrentRegion
rng.AutoFilter 15, "<>" & "*Chief Technology Office*", xlAnd,
"<>" & "*Desktop Platform*"
rng.AutoFilter Field:=25, Criteria1:="=
nks,
> Pavithra
>
> ---
>
>
> On Sun, Apr 14, 2013 at 3:58 AM, Rajasekhar Praharaju <
> rajasekhar.prahar...@gmail.com> wrote:
>
>> hi Experts,
>>
>> Need your help , as i could not club both sheets in new workbook.
>>
>> Tha
hi Experts,
Need your help , as i could not club both sheets in new workbook.
Thanks,
Raj
On Sun, Apr 14, 2013 at 12:02 PM, Rajasekhar Praharaju <
rajasekhar.prahar...@gmail.com> wrote:
> Hi friends,
>
> Please assist with Advance filter issue,
>
> i have created a macro
Happy birthday Noor have a delightful nd colourful moments a head.
On Jan 2, 2013 12:25 AM, "Umesh Soni" wrote:
> Happy birthday Noorain.. May All u r wishes comes true have a great
> Year Ahead.
>
> Regards,
>
> Umesh Soni
>
> On Tue, Jan 1, 2013 at 7:43 PM, wrote:
>
>> Happy b'day
done
On Sat, Nov 10, 2012 at 12:47 PM, vijayajith VA wrote:
> done
>
>
> On Sat, Nov 10, 2012 at 12:43 PM, Pravin Gunjal wrote:
>
>> Done.
>>
>> On Sat, Nov 10, 2012 at 11:40 AM, Ayush Jain wrote:
>>
>>> Dear group,
>>>
>>> I have created a small formula quiz to test your formula knowledge. Thi
Hi friends,
Please share the excel template of accounts payable if any one of u is
having.
basically i am planning to build up a template on accounts payable data in
excel for forecasting and analysis. and need your experts advise.
Please do share if any of you are having such stuff.
Thanks in
Congrats rajan for your threshold efforts..
On Wed, Oct 3, 2012 at 2:19 AM, Asa Rossoff wrote:
> I'm happy to see you recognized and honored for your continued great
> contribution Rajan.
>
> Asa
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.co
Ashish, any idea in this regards as already you have created in excel.
Thanks for your help in advance!!
On Sat, Aug 4, 2012 at 3:46 AM, David Grugeon wrote:
> You might do better asking PowerPoint questions on a Powerpoint forum. As
> its name indicates this forum is about Excel Macro
hi experts,
Need your expert advise.
please provide a vba code which copiesText frame box copied from excel and
then pastes it to ppt slide in bottom.
--
--
Thanks & Regards,
Rajasekhar.P
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Po
i just used this formula however how can i add iserror formula to this..
On Thu, Mar 8, 2012 at 12:29 AM, Rajasekhar Praharaju <
rajasekhar.prahar...@gmail.com> wrote:
> thanks one and all for your help..
>
>
> On Wed, Mar 7, 2012 at 7:14 PM, dguillett1 wrote:
>
thanks one and all for your help..
On Wed, Mar 7, 2012 at 7:14 PM, dguillett1 wrote:
> You didn’t show us your situation but, depending on your need you could
> use LOOKUP, vLookup
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>
> *From:* Ashish Bha
---------
>
>
> --
> *From:* Rajasekhar Praharaju
> *To:* excel-macros@googlegroups.com
> *Sent:* Fri, October 14, 2011 11:31:34 AM
>
> *Subject:* Re: $$Excel-Macros$$ Need help
>
> hi Paul,
>
> i am getting bug here,
ot;Done"
> End Sub
>
>
>
> *Paul*
>
> -
> *“Do all the good you can,
> By all the means you can,
> In all the ways you can,
> In all the places you can,
> At all the times you can,
> To all the people you can,
>
Good evening experts,
Please assist me in this concern i am looking for a excel macro which can
give details of folders and their respective size.
for example i have Main folder with name Excel with in the folder i have
many other sub folders, so i am looking for a macro which can list the sub
Thanks for sharing this mahesh and rajan
On Wed, Aug 31, 2011 at 11:36 PM, rajan verma wrote:
> Hi,
> I just use this
>
> Sub speak()
> Application.Speech.speak "Hellow EveryOne, Look I M speaking"
> End Sub
>
>
> On Wed, Aug 31, 2011 at 11:05 PM, Mahesh parab wrote:
>
>> Hi
>>
>> does any one a
Thanks a ton to one all really helped me alot in this concern.
On Mon, Jul 18, 2011 at 11:30 PM, Mahesh parab wrote:
> Hi
>
> For Vlookup you can use static Name range which is predetermined
> RANGE
> =SBUMapping!$A$1:$D$789
> OR
> dynamic Name range range which resize dynamically
> RANGE
>
> =O
hi,
I will be preparing the leaveplanner tracker report frequently .
i will colour the specific day when i am absent on particular day.finallyon
the end of the month
i will count the different colours and place the number.
Please provide the formula or vba macro to perform this activity.
than
1,J2))/2)
>
> On Wed, Feb 16, 2011 at 7:10 PM, Rajasekhar Praharaju <
> rajasekhar.prahar...@gmail.com> wrote:
>
>> hi ashish,
>>
>> Can you please help to find out how many mondays and saturdays are
>> present for the same above query.
>> 01/16/2011
hi ashish,
Can you please help to find out how many mondays and saturdays are
present for the same above query.
01/16/2011 to 02/16/20111
Thanks,
Raj
On Tue, Feb 15, 2011 at 12:46 PM, N Pradhan wrote:
> Thank you very much for the prompt reply Sir.
>
>
>
> - Original Message -
>
> *
hi please use this simple procedure
Excel Text to Column Command
The Text to Column command allows you to break text in one column into
several columns. For example, if you have LastName, FirstName in a column,
you can break the text into two columns—one containing LastName and the
other containi
hi ,
Please help in this concern can any one help in this concern i require this
computation using excel macro
below is the link which is coded in HTML. Which is working fine but i cant
use this link in my organisation so kindly can anyone help to build the
excel macro for this concern.
Thanks,
R
Hi,
I have an excel sheet and I want to filter for BLANKS in multiple columns
and provide comment of the other column. Can some one help me writing a
macro/add-on? expand »
Here each time the columns will not be the same, so it would be good if the
macro asks for the range and perform the act
Hi Friends,
I just wanted to share this differences between Excel 2003 and 2007.
Number of Rows and Columns
One of the main developments in Excel 2007 is that it allows more columns
and rows. For many users this may not be an issue - after all, the 65,536
rows and 256 columns provided by Exce
:49 AM, Rajasekhar Praharaju <
rajasekhar.prahar...@gmail.com> wrote:
>
>
> Hi ,
>
> Please help me in this concern,
>
> In this sheet i am trying to place vlookup for multiple fields yaar
>
> it should through the description and date in AG column basing on list of
Hi ,
Please help me in this concern,
In this sheet i am trying to place vlookup for multiple fields yaar
it should through the description and date in AG column basing on list of
activities.
but i should get this in horizontal basis..
can anyone plz help me in this concern.
for example
if on
Hi ,
In this sheet i am trying to place vlookup for multiple fields yaar
it should through the description and date in AG column basing on list of
activities.
but i should get this in horizontal basis..
can anyone plz help me in this concern.
for example
if one activity is performed twice whi
Congratts dilip
On Tue, Jan 4, 2011 at 12:34 AM, Vinod N wrote:
> Congratulations!! Dilipji...
>
>
> On Mon, Jan 3, 2011 at 3:31 PM, Ayush wrote:
>
>> Dear Group,
>>
>> I am very very very very happy to share a good news with you. One of our
>> dearest group memb
Congratulations Ashish, we wish you flamboyant future.
On Sat, Jan 1, 2011 at 4:40 PM, ashish koul wrote:
> welcome ayush, happy new year to you and everyone in the group...
>
>
>
>
> On Sat, Jan 1, 2011 at 1:37 PM, Ayush wrote:
>
>> Dear Group,
>>
>> I am very happy to announce th
hi Kalyan,
Use substitute function.
Please find the attached solution hope it helps you.
Thanks,
Raj
On Fri, Nov 26, 2010 at 10:55 AM, Kal xcel wrote:
> Dear Experts,
>
> I am facing a problem to extract characters from right of string.
>
> Please help.
>
> Thanks in advance.
>
> Kalyan
>
> -
Hi Muralidhar,
did u check the attached pivot solution
let me know if it is not apt then i will do v-lookup fucntion as u sent.
Thanks,
Raj
On Thu, Nov 11, 2010 at 12:49 PM, muralidhar e wrote:
> Dear all,
>
> This is urgent to me, plz suggest solution as early as possible.
>
> Warm Regards,
>
hello rakesh,
Only for this attached sheet do you have query or Prior chain mails as
well, then i think u can just use this formula for the attached sheet
replacing date
=A2+30
By adding 30days u are getting the answer...Please let me know if this
resolves your query or not.
Thanks,
R
Hello Muralidhar,
Instead of Vlookup you can use Pivot table it depicts good results.
Please find Attached is the solved sheet..
Let me know if you are looking for the same or anything else.
Thanks,
Raj
On Thu, Nov 11, 2010 at 11:02 AM, muralidhar e wrote:
> Dear all group members,
>
> I want
hi,
Check this website hope you will find the resolution
http://www.homeandlearn.co.uk/excel2007/excel2007s6p4.html
Thanks,
Raj
On Tue, Nov 9, 2010 at 11:19 PM, janet dickson wrote:
> Hello Excel Gurus,
>
>
> I encountered a challenge on using SUMIF FUNCTION. Help me on summing total
Conditional Formatting
You can use something called Conditional Formatting in your spreadsheets.
Conditional Formatting allows you to change the appearance of a cell,
depending on certain conditions. What we'll do is to colour the Overall
Averages on our Student Exam spreadsheet, depending on th
ble to devote that much
> time. :(
>
> Best Regards,
> DILIPandey
>
>
>
> On Tue, Oct 12, 2010 at 6:13 PM, rajasekhar praharaju <
> rajasekhar.prahar...@gmail.com> wrote:
>
>>
>>
>> -- Forwarded message --
>> From:
Pages" option
> you can assign the tasks to different individuals.
>
> Please explain further if you need some other solution.
>
> Best Regards,
> DILIPandey
>
>
>
> On 10/9/10, rajasekhar praharaju wrote:
> > could you please assist me in this concern .please
&
mif Formulas.
>
> Regards
>
> Sumit Vyas
>
>
>
> On Thu, Oct 7, 2010 at 10:25 PM, rajasekhar praharaju <
> rajasekhar.prahar...@gmail.com> wrote:
>
>>
>>
>> hi Excel Guru,
>>
>>
>> Please assist me in this concern .
>
hello friend,
Go to top left hand corner of excel click on office button--> excel
options---> then select the add ins by double clicking on it.
then click on manage option ---> go
Thanks,
Raj
On Thu, Oct 7, 2010 at 10:55 PM, SAJID MEMON wrote:
> Hi Experts,
>
> I want to know Add-in in ex
hi Pankaj,
Can you please tell what formula you are looking for.
Could you please express your query in brief.
Thanks,
Raj
On Tue, Oct 5, 2010 at 8:23 PM, Pankaj Kumar wrote:
> Hi, Experts Its urgent basis i need u r help, i have a Name list A-Z, I
> have sorting Name list A-Z in
hearty congratulations ayush, you really deserve it
Infact you are good encyclopedia for us.
Have a flamboyant future and delightful moments for ur future endeavors.
Regards,
Raj
On Sun, Oct 3, 2010 at 3:47 PM, Ayush wrote:
> Dear Group,
>
> I am proud to announce that I am aw
Hi friends,
Dear Adorable group... please share if any one of us are having excel
addin's . Moreover i am having query regarding the excel addin's.
Can any one suggest how to create the excel addins i just tried creating
this addins . but could not use properly.
Thanks for your help in advance.
Hi Santosh,
Send Your sample excel work book attachment for review.
i can help you in this concern, i recently got good solution in regards to
this concern.
my id is rajasekhar.prahar...@gmail.com
copy even the group as well.
Thanks & Regards,
Raj
On Sun, Sep 12, 2010 at 6:50 PM, santosh
Hi Santosh,
Send Your sample excel work book attachment for review.
i can help you in this concern, i recently got good solution in regards to
this concern.
my id is rajasekhar.prahar...@gmail.com
copy even the group as well.
Thanks & Regards,
Raj
On Sun, Sep 12, 2010 at 6:50 PM, santosh
hello,
Pankaj attached is the solution for your query, the formula u depicted or
used in that cell
is accurate where as all you need to do is to give a space as shown below
9:00 AM Give space like this for both intime and out time then as per
attached sheet u will have error free result.
Inca
learning campaign to one and all. let us continue to bridge excel
queries and learnings which helps us in enriching our potentials
simultaneously in turn help others.
Regards,
Raj
On Mon, Aug 30, 2010 at 6:06 AM, ashish koul wrote:
>
>
> On Mon, Aug 30, 2010 at 6:17 PM, rajasekhar
hello friends,
In my opinion " Excel is In built end-user automated application which saves
lot of valuable time by proper utilization of excel addin's and
formulas...
Regards,
Raj
On Fri, Aug 27, 2010 at 11:49 PM, Ayush wrote:
> Its a very handy tool for any data analysis and rep
Hi All,
Please assist in this concern i wanted to prepare excel macro where in i can
consolidate different excel workbooks data into
one excel workbook. so please send me if it is possible through vba macros.if
any one of the group is having the script or macro
for performing this activity please
Hi All,
Please assist in this concern i wanted to prepare excel macro where in i can
consolidate different excel workbooks data into
one excel workbook. so please send me if it is possible through vba
macros.if any one of the group is having the script or macro
for performing this activity please
Hi Pooja,
Just click on excel options.
dialog box with different options are displayed then click on trust center.
and enable option is seen just click on trust and save it and close the work
book .
then u can use the macro enabled workbook.
Regards,
Raj
On Fri, Jul 30, 2010 at 12:25 PM, Pooj
Hi All,
Myself rajasekher just require your valuable suggestion in this concern,
please advise the excel formular where in i can use and the words for the
value specified in excel. for example if the value in excel is 80
(numerical) ...
i need this 80(numerical) towords as eighty,..
hi friends,
i do have certain vba books will send you shortly.
Regards,
Raj
On Fri, Mar 26, 2010 at 2:37 PM, rajasekhar praharaju <
rajasekhar.prahar...@gmail.com> wrote:
>
>
> On Fri, Mar 26, 2010 at 1:26 PM, wrote:
>
>> Hi
>> I have this book but will have to
On Fri, Mar 26, 2010 at 1:26 PM, wrote:
> Hi
> I have this book but will have to find the cd.
>
> I will try and send it this weekend
>
> Thanks
>
> Amitabh
> --
>
> -Original Message-
> From: anandydr
> Date: Thu, 25 Mar 2010 21:19:13
> To: MS EXCEL AND VBA MACROS
> Subj
hi all please advise the how to find the row or coloum coloured cell . using
excell formula
i need to find the cell which is in colour.
cell colour should be known .
please help me out in this concern
Thanks in advance.
Raj
9966353510
On 6/26/09, Saravanan Anna wrote:
>
> Try =proper() comma
54 matches
Mail list logo