Dear Muneer,
You can also use below formula in conditonal formating.
=WEEKDAY($A11)=6
On Wed, Aug 15, 2012 at 7:46 PM, ashish koul wrote:
> use this formula in conditional format
>
> =AND(TEXT($A2,"ddd")="Fri")
>
>
> On Wed, Aug 15, 2012 at 12:09 PM, vijayajith VA
> wrote:
>
>> use ths below
You can try this.
=COUNTIF(B3:B21,B3)>1
Regards,
Kuldeep Singh
Phone.: +91-120-4763789, Extn.: 789
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print this e-mail unless
you really need to.*
On Fri, Aug 17, 2012 at 12:00 PM, Amit Gandhi wrote:
> Hi
Dear Amar,
Please try it.
*=IF(ISERR(INDEX(INDIRECT($D$2),C4)),"",INDEX(INDIRECT($D$2),C4))*
see attached sheet.
On Thu, Aug 16, 2012 at 5:18 PM, amar takale wrote:
> Thanks to all very much.One question ask to all there are custom
> formatting then error will disappear in cell?Is it right? I
Hi Experts
If there is any formula which can calculate MOST REPEATED NO from a list?
Sample file attached.
Pls help me here.
Regards
Amit
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use con
Dear Amol,
Please Try it.*
Function Udf_sum(rng As Excel.Range)
Dim cell As Range
For Each cell In rng
If VBA.IsNumeric(cell) And cell.Value <> "" Then
Udf_sum = Udf_sum + cell
End If
Next cell
End Function
*
On Fri, Aug 17, 2012 at 11:32 AM, Amol J wrote:
> Hi experts, I need your help, I tr
Hi experts, I need your help, I tried myself but unfortunatly its not
working.
I need UDF to sum range.
1) first my range will be B4:E4 and
I am going to drag udf into columns to next range will be C5:E5,
Means when I will drag my udf function it will increase in range by
1column and 1 row
Hi experts, I need your help, I tried myself but unfortunatly its not
working.
I need UDF to sum range.
1) first my range will be B4:E4 and
I am going to drag udf into columns to next range will be C5:E5,
Means when I will drag my udf function it will increase in range by
1column and 1 row
Hi Hillary,
The main mistake you are doing is trying to play video from the site.First
save the required video or game to your PC. Then try embedding the videos
in Excel 97-2003 as explained earlier and it definitely works. I have
embedded many videos in excel.
Regards,
P.VIJAY KUMAR
--
Join
If using Excel 2007 and later can use this :
=IFERROR(VLOOKUP(F5,$B$4:$D$9,3,0),"")
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prince Dubey
Sent: 16 August 2012 10:53
To: excel-macros@googleg
1).Use Minimum Formatting
2). Save file in .xlsb
3). Set calculation Manual (Calculate formula whenever required)
4). Use name Ranges
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prince D
Please see the attachment
regards
prince
On Thursday, August 16, 2012 3:39:08 PM UTC+5:30, amar takale wrote:
>
>
>
--
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
Hi Amit,
I thinks if your data is too large then please try it operate by using
Arrays and dictionary objects In VBA.
regards
prince
On Wednesday, August 15, 2012 7:18:41 PM UTC+5:30, Amit Desai (MERU) wrote:
>
> Dear Friends,
>
>
>
> I need to work on huge data in excel 2007. Whenever I u
Hi Hilary,
i please try following step hop it will work for you.
1. Save ur work book in 2003-97 format
2.Go to developer tab->In ActiveX Control select last icon (right bottom
most(more control))->Add window media player->drop it on sheet
3.Click on design mode
4. Select the property of window
Karan Bhatia is banned.
-Ayush Jain
On Thursday, 16 August 2012 01:17:31 UTC+5:30, finu wrote:
> Please ban this user
>
>
>
> *From:* excel-...@googlegroups.com [mailto:
> excel-...@googlegroups.com ] *On Behalf Of *Ashish Pradhan
> *Sent:* 15 August 2012 20:24
> *To:* excel-...@googlegro
Hi RK,
i dont think there is such a thing, however I believe for such stuff you
have to build a model from scratch. if one knows exactly how these
processes run, then it can be built
On Thu, Aug 16, 2012 at 3:58 PM, RK wrote:
> **
> Hi Vijay,
>
> Thx. I had seen the website before writing in ou
Hi ,
do you want to download videos from youtube by html or via excel
On Thu, Aug 16, 2012 at 8:39 PM, Hilary Lomotey wrote:
> Hello Guys,
>
> kindly help out, am trying to embed a youtube video in excel but when i go
> thru the process the video does not download, i have also installed the
> b
Hi Vijay,
Thx. I had seen the website before writing in our group, however did not find
anything that could help me with my day to day financial accounting (journal
entries, ledgers, trial balances, P&L & Balance sheet.
Rgds,
Roopesh Kapur
E:roopesh.ka...@gmail.com
-Original Message-
Hi, Roopesh,
For Financial excel sheets you can visit www.exinfm.com which has about 100
free excel sheets catering fianancial topics.
Regards,
P.VIJAY KUMAR
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for vio
Hello Hilary,
To Get the video Loaded in in Excel 2007. First Save the file in Excel
97-2003 Version. Then in the properties of the embedded video you will get
a custom tab in which you specify the URL or the path of the video.Then
exit the design mode.Now you will have your video playing in Excel
Hello Guys,
kindly help out, am trying to embed a youtube video in excel but when i go
thru the process the video does not download, i have also installed the
below flash player and shockwave player but its wont load, pls see attached.
i went to developer tab
selected more controls
selected shock
Thanks for all your help dear friends..
Best Regards,
Amit
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of NOORAIN ANSARI
Sent: 16 August 2012 17:33
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Tips for working on huge data in excel 2007
Hi Everyone,
Does anyone have any excel workbook that can cater to end to end financial
accounting of a business.
Regards,
Roopesh Kapur
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use con
Hi Pravin,
Formula is not work I will try
On Thu, Aug 16, 2012 at 6:50 PM, Pravin Gunjal wrote:
> Dear Amar
>
> You may use the same formula
>
> =IFERROR(INDEX(INDIRECT($D$2),C10),"")
>
> *With regards,
>
> **Pravin Gunjal**
> *
>
>
> On Thu, Aug 16, 2012 at 5:18 PM, amar takale wrote:
>
>>
Do you want to average the LAST 5 years and the last 9 years from the LAST date
in col A as you add data to the bottom?
You need to give a complete explanation and EXAMPLES.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: amar takale
Sent: Thursday, August 16
Dear Amar
You may use the same formula
=IFERROR(INDEX(INDIRECT($D$2),C10),"")
*With regards,
**Pravin Gunjal**
*
On Thu, Aug 16, 2012 at 5:18 PM, amar takale wrote:
> Thanks to all very much.One question ask to all there are custom
> formatting then error will disappear in cell?Is it ri
and a complete explanation.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: amar takale
Sent: Thursday, August 16, 2012 3:40 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Chart Update Within Date Data Range
Hi dguillett Sir,
I will send
Hi Experts,
May i know the reason why my query has been not yet resolved? Any think you
want information from my side or what? I am sending again and again
requests to the experts please resolve it but no buddy is replying. Please
let me know the reason.
Thanks
Lokesh.M
On Sun, Aug 12, 2012 at 9
Homework?
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Kuldeep Singh
Sent: Thursday, August 16, 2012 2:08 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ [█ ▆ ▅ ▃ ▂★AVERAGEIF & AVERAGEIFS★▂ ▃ ▅ ▆ █]
Hi Experts,
What is the correct use of
Dear Noorain/ Amresh,
Thank u so much for great helping.
On Thu, Aug 16, 2012 at 4:21 PM, NOORAIN ANSARI wrote:
> Dear Rakesh,
>
> You can also set high priority of Excel exe file
> See attached screen shot.
>
>
> On Thu, Aug 16, 2012 at 4:15 PM, NOORAIN ANSARI
> wrote:
>
>> Dear Rakesh,
>>
>
Parvesh, Please share your workbook..
On Wed, Aug 15, 2012 at 10:59 PM, PRAVESH KUMAR wrote:
> Hi All,
> >
> >
> > please find attached file and solve my problem urgent.
> >
> >
> > Thanks
> >
> > Pravesh
> >
>
>
> --
>
>
> *Thanks & Regards*
>
> *Pravesh Kumar*
>
> --
> Join official facebook pa
You can do the following to speed up your workbook.
1). Save your file in .xlsb (Binary Format) to reduce size.
2).Remove unnecessary formatting.
3) Use Index Match instead of Vlookup()
4).Set Calculation Manual (Calculate only when required)
5).Use Name Ranges.
6).Sort you
Thanks to all very much.One question ask to all there are custom formatting
then error will disappear in cell?Is it right? I used index formula in my
sheet but it show reference.
I attached sheet here Pl see all.
On Thu, Aug 16, 2012 at 4:17 PM, Kuldeep Singh wrote:
>
> You're Great Noorain Sir.
Hi,
Please find attached file with example.
Regards,
Vijayendra
2012/8/16 Amresh Maurya
> check below link. i hope it will help you.
>
>
> http://www.xlninja.com/2012/08/15/average-averageif-and-averageifs-functions-in-excel/
>
>
> Reagrds
> Amresh
>
>
> On Thu, Aug 16, 2012 at 1:03 PM, amar t
You're Great Noorain Sir.
Regards,
Kuldeep Singh
Phone.: +91-120-4763789, Extn.: 789
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print this e-mail unless
you really need to.*
On Thu, Aug 16, 2012 at 4:12 PM, NOORAIN ANSARI wrote:
> Dear Amar,
>
> In
Dear Rakesh,
You can do the following to speed up your workbook.
1). Save your file in .xlsb (Binary Format) to reduce size.
2).Remove unnecessary formatting.
3) Use Index Match instead of Vlookup()
4).Set Calculation Manual (Calculate only when required)
5).Use Name Ranges.
Dear Amar,
In case of 2003 Version
You can also use..
=IF(ISERROR(VLOOKUP(F5,$B$4:$D$9,3,0)),"",VLOOKUP(F5,$B$4:$D$9,3,0))
Or
=IF(ISNA(VLOOKUP(F5,$B$4:$D$9,3,0)),"",VLOOKUP(F5,$B$4:$D$9,3,0))
On Thu, Aug 16, 2012 at 3:39 PM, amar takale wrote:
>
> --
> Join official facebook page of this f
check below link. i hope it will help you.
http://www.xlninja.com/2012/08/15/average-averageif-and-averageifs-functions-in-excel/
Reagrds
Amresh
On Thu, Aug 16, 2012 at 1:03 PM, amar takale wrote:
> Hi Amresh,
> Can you give example file.I also not understand what is different between.
> Than
Dear Amar,
Use Iferror before the desire formula.
you can use: =IFERROR(VLOOKUP(F5,$B$4:$D$9,3,0),"")
Thanks & Regards,
*Deba Ranjan P*
On Thu, Aug 16, 2012 at 3:39 PM, amar takale wrote:
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/di
--
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 Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will n
pls follow Group Rules.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
Regards
Amresh
On Thu, Aug 16, 2012 at 2:04 PM, srinivas wrote:
> Excellent Track record in Training & placing Freshers as ORACLE DBAs/APPS
> DBAs,
> Fresh batch starts fr
Hi ,
clear Unnecessary formatting.delete unused columns
save as file type in Microsoft Binary workbook.
i hope it will help you.
Regards
Amresh
On Thu, Aug 16, 2012 at 1:08 PM, Rakesh Kumar Sharma wrote:
> Dear Kuldeep,
>
> It's too large size
>
>
> On Thu, Aug 16, 2012 at 1:03 PM, Kuldeep
Dear Kuldeep,
It's too large size
On Thu, Aug 16, 2012 at 1:03 PM, Kuldeep Singh wrote:
>
> Hi Rakesh,
>
> Please Share a sample worksheet.
>
> Regards,
> Kuldeep Singh
>
> On Thu, Aug 16, 2012 at 1:01 PM, Rakesh Kumar Sharma <
> rakeshks@gmail.com> wrote:
>
>> Hi Experts,
>>
>> I have a sh
Hi Amresh,
Can you give example file.I also not understand what is different between.
Thanks for help
On Thu, Aug 16, 2012 at 12:52 PM, Amresh Maurya wrote:
> Hi ,
>
> it works like sumif and sumifs..
>
> we used it for find average value with criteria
>
> [image: Inline image 1]
>
>
> Regards
>
Hi Rakesh,
Please Share a sample worksheet.
Regards,
Kuldeep Singh
On Thu, Aug 16, 2012 at 1:01 PM, Rakesh Kumar Sharma wrote:
> Hi Experts,
>
> I have a sheet of 70MB. I am facing problem when using formulas & filters.
> It gets slow. I am using Excel 2010. Is there any way to prevent to bein
Save the file in .xlsb format
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Rakesh Kumar Sharma
Sender: excel-macros@googlegroups.com
Date: Thu, 16 Aug 2012 13:01:54
To:
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ How can i reduce file size of a Ex
Hi Experts,
I have a sheet of 70MB. I am facing problem when using formulas & filters.
It gets slow. I am using Excel 2010. Is there any way to prevent to being
slow process or any format where i can work on a reduced file size.
--
Regards,
Rakesh Kumar Sharma
Contact: +91-9971024741
--
Hi ,
it works like sumif and sumifs..
we used it for find average value with criteria
[image: Inline image 1]
Regards
Amresh
On Thu, Aug 16, 2012 at 12:38 PM, Kuldeep Singh wrote:
>
> Hi Experts,
>
> What is the correct use of AVERAGEIF & AVERAGEIFS. Kindly share more
> example with Excel Sh
Hi Experts,
What is the correct use of AVERAGEIF & AVERAGEIFS. Kindly share more
example with Excel Sheet.
Regards,
Kuldeep Singh
Back Office Executive (MIS)
Info Edge India Limited (naukri.com)
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (
48 matches
Mail list logo
