$$Excel-Macros$$ Disable of print option in excel menu

[rajafs...@gmail.com]

Hi group, 

How to disable print option in excel menu, because i want to disable the menu 
function of print and i wants to provide a button for printing in excel


-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Help with replacing Application.FileSearch in macro

[Dave]

Hi Gurus,, 

I have the following macro that has been working fine for ages in 
Excel 2003 and now is giving me "run time error 445  Object doesn't 
support this action" in Excel 2010. I need help in fixing  this macro 
please.  I have read about the "dir" method & "Application.FileSearch" 
methods but it does not help as I am not a programmer. Thanks in advance.

Sub all_2010_pdf() 
Dim i As Long 
With Application.FileSearch 
.NewSearch 
.SearchSubFolders = True 
.Filename = "*.pdf" 
.LookIn = "\c:\temp\vba" 
.Execute 
For i = 1 To .FoundFiles.Count 
ActiveSheet.Hyperlinks.Add Anchor:=Range("A" & i), _ 
Address:=.FoundFiles(i), TextToDisplay:= _ 
Right(.FoundFiles(i), Len(.FoundFiles(i)) - _ 
InStrRev(.FoundFiles(i), "\")) 
Next 
End With 
End Sub 

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ userform is not opening

[santosh subudhi]

Hi Friends,

Need another help.

I am trying to upload a userform using combobox but it is not working.

Sample sheet is attached.

Regards
Santosh
santoshkumar.subu...@gmail.com

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Combobox.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Is there any carrer in excel.

[hanumant shinde]

Bhushan

If you are expert in anythign company is wating for you. Rob Bunce one of the 
gods in Excel whom i know. he works in our company UK Branch and if he resigns 
hahaha company will shut that process. you can guess how much he must be 
earning. i myself in Capgem and earning good money.(thanks to this group which 
REALLY changed my life) just excel wont work you will need to know VBA and you 
should know it VERY WELL. there is hell lot of openings in this field. 
everyweek 
you will get a call if you prepare you resume properly on the basis of VBA and 
bit of SQL. ppl normally underestimate excel but it has lots of power. but u 
have to know VBA. jus follow the thread in this group and you will love VBA. 
and 
there are ppl here Ashish, ayush ,paul, dave dilip pandey, just to name a few, 
who are just waiting a chance to help others. hats of to them. and most 
importantly founder of this group AYUSH JAIN. i owe you dude. :) let me know if 
i can help you by any means.





From: Bhushan 
To: MS EXCEL AND VBA MACROS 
Sent: Tue, 22 March, 2011 2:37:38 PM
Subject: $$Excel-Macros$$ Is there any carrer in excel.

Dear Expert,

1.     Is there any carrer in excel,This there good demand for excel
knowledge in reputed company.
2.     Is any scope in further growth as MIS.
3.     Is there any course or institute related to MIS.
4.     Because i am in MIS feild for prv 1.5 years the above question
have asked often to myself that i am not wasting the     time after MIS.

-- 
--

Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Re: Median/IF Forumla producing a #NUM Error ~ Help!

[Susan 1]

No need to answer I have the formula, thanks!
{=IF(ISERR(MEDIAN(IF($F$5:$F$17=4,$H$5:$H$17))),"No Minutes Done for This
Unit",MEDIAN(IF($F$5:$F$17=4,$H$5:$H$17)))}

On Thu, Mar 24, 2011 at 9:01 AM, Anderson, Susan wrote:

>  Hi ,
>
> Can you help me with the formula below? See Tab Mar 05, column AB or AC
>
>
>
>  It works fine for finding the median number but if it cannot find the
> criteria then it answers with #NUM error.  Do you know how I can rewrite the
> formula to replace the #NUM with “No Minutes Done for This Unit”
>
>
>
> {=MEDIAN(IF($F$5:$F$17=4,$H$5:$H$17))}
>
>
>
> Thanks for your help!
>
>
>
>
>
>
>
> Susan Anderson
>
> Admin Assistant II l Clinical Administration H4-483
>
> Office: 206-341-0183 l Fax: 206-341-0638 l Pager: 206-541-0588
>
>
>
>
>
>
>
>
>
> *From:* Susan [mailto:sunni...@gmail.com]
> *Sent:* Thursday, March 24, 2011 6:55
> *To:* Anderson, Susan
> *Subject:* FW: $$Excel-Macros$$ Median If Formula
>
>
>
>
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Dave Bonallack
> *Sent:* Thursday, March 24, 2011 2:00 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Median If Formula
>
>
>
> Hi Susan,
> =MEDIAN(IF(F5:F17=1,H5:H17))
> This is right, but it's an array formula, so you have to enter it with
> Ctrl+Shift+Enter
> When you do this, it gives the right answer.
> Regards - Dave.
>
>  --
>
> Date: Wed, 23 Mar 2011 14:39:36 -0700
> Subject: $$Excel-Macros$$ Median If Formula
> From: sunni...@gmail.com
> To: excel-macros@googlegroups.com
>
> Hi,
>
>
>
> See tab named Mar 05 in the attachment.
>
>
>
> I'm trying to get Excel 2007 to calculate the Median in data Columns H ,
> cells 5 through 17, but only if it meets certain criteria of Task done in
> Column F, cells 5 to 17.
>
>
>
> My formula which should work, is =MEDIAN(IF(F5:F17=1,H5:H17)), but the
> answer is wrong , 40
>
>
>
> but when I did a manual median formula =MEDIAN(H5,H9,H17) , of those cells
> in Column F that meet the criteria of "1", the answer is 55
>
>
>
> When I place in "" around =1 the formula doesn't work at all.  By removing
> the "" makes the formula work but it's not calcuating the median correctly.
>
>
>
> Any help with this would be excellent!
>
>
>
> ~Susan
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> ** CONFIDENTIALITY DISCLAIMER **
>
> The information contained in this e-mail may be confidential. IF YOU
> RECEIVED THIS IN ERROR, please call the Virginia Mason Privacy Officer
> through the Virginia Mason Operator at (206) 223-6600. Thank you.
>
> Patients: E-mail is NOT considered secure. By choosing to communicate
> with Virginia Mason by e-mail, you will assume the risk of a confidentiality
> breach. Please do not rely on e-mail communication if you or a family
> member is injured or is experiencing a sudden change in health status.
>
> If you need emergency attention, call 911.
>
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Macro to sum across columns and replace columns with calculated result

[ashish koul]

can you attach the sample data and headers you are using

On Fri, Mar 25, 2011 at 1:53 AM, 0 1  wrote:

> I have a spreadsheet with States as rows. For each State, there are 4
> columns of data for Year 1, then 4 more columns of data for Year 2,
> and so on. Each column represents a quarter for that year.
>
> For example:
>
> Column A lists the State
> ---
> Column B data for 1st quarter, 2000
> Column C data for 2nd quarter, 2000
> Column D data for 3rd quarter, 2000
> Column E data for 4th quarter, 2000
> ---
> Column F data for 1st quarter, 2001
> Column G data for 2nd quarter, 2001
> Column H data for 3rd quarter, 2001
> Column I data for 4th quarter, 2001
> ---
> etc.
>
> I would like to write a macro that, for each year:
>
> - sums the 1st and 2nd quarter and replaces the two columns with one
> column holding the sum
> - sums the data for the 3rd and 4th quarter, and replaces the two
> columns with one column holding the sum
>
> Resulting in:
>
> Column A lists the State
> ---
> Column B data for 1st+2nd quarter, 2000
> Column C data for 3rd+4th quarter, 2000
> ---
> Column D data for 1st+2nd quarter, 2000
> Column E data for 3rd+4th quarter, 2000
> ---
> etc.
>
> Any suggestions about how to go about tackling this?
>
> Thank you.
>
>  20032004
> State CountA CountB CountC CountD CountA CountB CountC CountD
>
>
>
> And so on for many year
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Macro to sum across columns and replace columns with calculated result

[0 1]

I have a spreadsheet with States as rows. For each State, there are 4
columns of data for Year 1, then 4 more columns of data for Year 2,
and so on. Each column represents a quarter for that year.

For example:

Column A lists the State
---
Column B data for 1st quarter, 2000
Column C data for 2nd quarter, 2000
Column D data for 3rd quarter, 2000
Column E data for 4th quarter, 2000
---
Column F data for 1st quarter, 2001
Column G data for 2nd quarter, 2001
Column H data for 3rd quarter, 2001
Column I data for 4th quarter, 2001
---
etc.

I would like to write a macro that, for each year:

- sums the 1st and 2nd quarter and replaces the two columns with one
column holding the sum
- sums the data for the 3rd and 4th quarter, and replaces the two
columns with one column holding the sum

Resulting in:

Column A lists the State
---
Column B data for 1st+2nd quarter, 2000
Column C data for 3rd+4th quarter, 2000
---
Column D data for 1st+2nd quarter, 2000
Column E data for 3rd+4th quarter, 2000
---
etc.

Any suggestions about how to go about tackling this?

Thank you.

  20032004
State CountA CountB CountC CountD CountA CountB CountC CountD



And so on for many year

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ discussexcel : TIP : Find the currently active cell

[Ayush]

A Quick Tip : How to find the currently active cell
http://www.discussexcel.com/excel-tips/excel-tips/findthecurrentlyactivecell

Regards
Ayush Jain

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Is there any carrer in excel.

[anandydr]

Hi,

Beside openings in MIS there are a lot of opportunities in back end
operations in Banking, Mutual Funds and Insurance organizations. More
importantly the knowledge of data analytics is what makes the use of
Excel as an important tool. A lot of companies look for professionals
with this skill set.
More important as an MIS executive you have worked on the same kind of
data set again and again. Somehow in analytics the kind of data that
you get keeps changing with the kind of project you are working upon.
So to improve your knowledge you can start working on VBA and Macros
to improve your chances of landing into a better job profile.

Hope that helps
Anand Kumar

On Mar 23, 2:43 pm, Bhushan Sabbani  wrote:
> Dear Sanjoy,
>
> Thank for the same.
>
> Warm Regards
> Bhushan Sabbani
> +91 98208 26012*
> *

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Re: How to prevent from duplication in one work book

[Muhammad Talal Akbar]

i m very thankful to u my dear for your this act of kindness.

but still i have problem. your solution is applicable only on one sheet not
on complete workbook.



plz help me out from this problem

regards

On Thu, Mar 24, 2011 at 2:46 PM, Bhushan Sabbani wrote:

> Dear Arya,
>
> Please find the below attached file.
>
> Pls let me know any problem in the file.
>
>
> Warm Regards
> Bhushan Sabbani
> +91 98208 26012
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Re: How to prevent from duplication in one work book

[Bhushan Sabbani]

Dear Arya,

Please find the below attached file.

Pls let me know any problem in the file.


Warm Regards
Bhushan Sabbani
+91 98208 26012


-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


duplication.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Re: Count of color fills

[Bhushan Sabbani]

your are welcome,


Warm Regards
Bhushan Sabbani
+91 98208 26012

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Excel Password Breaker Code...

[NOORAIN ANSARI]

Dear Experts.,

Please find & use below VBA code to break password in EXCEL

Procedure : Press alt+F11
  Insert-Module then Paste below code
  Press-F5 to run



*Sub PasswordBreaker()

  Dim i As Integer, j As Integer, k As Integer
  Dim l As Integer, m As Integer, n As Integer
  Dim i1 As Integer, i2 As Integer, i3 As Integer
  Dim i4 As Integer, i5 As Integer, i6 As Integer*

*  On Error Resume Next
  For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
  For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
  For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
  For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126


ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
  Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
  Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
  If ActiveSheet.ProtectContents = False Then
  MsgBox "One usable password is " & Chr(i) & Chr(j) & _
  Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
  Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
   ActiveWorkbook.Sheets(1).Select
   Range("a1").FormulaR1C1 = Chr(i) & Chr(j) & _
  Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
  Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
   Exit Sub
  End If
  Next: Next: Next: Next: Next: Next
  Next: Next: Next: Next: Next: Next*

*End Sub

*--
Thanks & regards,
Noorain Ansari

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Median If Formula

[Dave Bonallack]

Hi Susan,
=MEDIAN(IF(F5:F17=1,H5:H17))
This is right, but it's an array formula, so you have to enter it with 
Ctrl+Shift+Enter
When you do this, it gives the right answer.
Regards - Dave.
 


Date: Wed, 23 Mar 2011 14:39:36 -0700
Subject: $$Excel-Macros$$ Median If Formula
From: sunni...@gmail.com
To: excel-macros@googlegroups.com


Hi,
 
See tab named Mar 05 in the attachment.
 
I'm trying to get Excel 2007 to calculate the Median in data Columns H , cells 
5 through 17, but only if it meets certain criteria of Task done in Column F, 
cells 5 to 17.
 
My formula which should work, is =MEDIAN(IF(F5:F17=1,H5:H17)), but the answer 
is wrong , 40
 
but when I did a manual median formula =MEDIAN(H5,H9,H17) , of those cells in 
Column F that meet the criteria of "1", the answer is 55
 
When I place in "" around =1 the formula doesn't work at all.  By removing the 
"" makes the formula work but it's not calcuating the median correctly.
 
Any help with this would be excellent!
 
~Susan
-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
  

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Re: Count of color fills

[Nizamuddin sayyad]

Thanks Bhushan

On Thu, Mar 24, 2011 at 11:20 AM, Bhushan Sabbani wrote:

> Dear sayyad,
>
> Please find the below attached file.
>
> Pls let me know any problem in the file.
>
>
> Warm Regards
> Bhushan Sabbani
> +91 98208 26012
>
>
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Re: Count of color fills

[Bhushan Sabbani]

Dear sayyad,

Please find the below attached file.

Pls let me know any problem in the file.


Warm Regards
Bhushan Sabbani
+91 98208 26012


-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Colorfills.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ How to prevent from duplication in one work book

[Muhammad Talal Akbar]

my question is

i enterd the word "Akbar" in the sheet 1 and then i moved towards sheet 3
and there
i m again going to enter "Akbar" at this time excel notify me that i have
already entered the same word in sheet numer 1 at column - and row
-. and also vise versa


plz help me

regards

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Re: hello all, its very urgent;;;

[Sanjoy Nath]

great



On Wed, Mar 23, 2011 at 3:22 PM, Bhushan Sabbani wrote:

> Dear Vijay,
>
> Please visit the site http://chandoo.org there is great dashboard along
> with the tip and trick for preparing the same.
>
>
> Warm Regards
> Bhushan Sabbani
> +91 98208 26012
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Your Sincerely
Sanjoy Nath
Engineer
EOL Gurgaon
EOL/M/NZ/Engg.Dept.(Haryana Division)



 We prepare custom tools (Softwares) to prepare Autocad Drawings
 Of the Engineering Components.Some Of Our Clients Provide the
 Design Calculation Steps And Sample Drawings (Templates for Eg the
 Nuts , Bolts , Screws , Stair Cases , Patterns , Geometries , LandScapes,
 Layouting, General Engineering Components , Mechanical Engineering
Components,
 Civil/Structural Engineering Components,Architectural Components) to follow
 and to meet their standards and specifications.The Tools we develop are
 entirely customised and specific for clients  own requirements and
 they are not re distributed to others.

  Let me be precise regarding our job profile and what we can do for you
 Suppose you have to develop any design component repeatedly for different
projects
Only Some of its parameters are changing and you need the drawing for that
component.
you cannot prepare the block for that.Since even in the custom Block in
Autocad you
cannot controll all the parameters automatically and very few users in
Autocad can follow
the technicalities to handle the customisable blocks in Autocad.
On the Other hand , customisable blocks cannot decide the dimensions   by
themselves nor can
compute the design calculations.But And it takes a long time to develop the
drawings.
Moreover if there is any revision in the General Arrangement drawings or
Facilities,
the entire things need to change and you have to start from the scratch
again and
draftsman forget to change some of the dimensions or the BOQ values in the
tables
attached to the drawings.These things are ridiculous to your clients.
We can understand these issues since we are in the design/Detailing and
drafting industry
for last 10 years and have worked for more than 6 companies(Directly as
employee or in parttime)
 in 3 domains
(Piping,Architecture and Structural)
And now we have attained the expertise to develop the dxf files from
Excel/EXE Applications.
We can develop and provide the tools (EXE tools or Excel Files as you need
and as much you ask for)
to develop these drawings automatically.

   Suppose you want to develop the drawings of doors/Panels with some given
features many/some of
which will change every time from task to task or from revision to revision
or from project to project.
You have to revise the drawings and your draftsman/detailer will take 30
minutes to 1 hour to revise each of
these several components.We can save this valuable time for you through the
tools.
Moreover many a time it happens that you have to prepare the scaled drawings
from the data in STAAD pro
and you have to type the utilisation ratios and reactions beside the members
including the sizes also.
Have you ever calculated how much time you spend on that and how much
errorprone are these ??
We can help you in these matters also.
We can extract the data in tables/Dimensions in the Autocad Drawing to Excel
(With Automations)such that you can prepare the
BOQs easily.Suppose you have a drawing and the dimensions of some feature in
a certain layer.We can provide
tools to you which will read the data from your dimensions in specific layer
and will type them
in the excel format.And can prepare the drawings of some other feature from
the extracted dimensions.

We can develop the same kind of tools for Word ,STAAD Pro , Tekla , PDF ,
Excel Also which are applicable for
MIS purposes and the custom checking tools for word processing
industries/Quality control departments.
We have given you the examples with CAD and Excel Only.But we have expertise
in STAAD Pro ,TEKLA
PDF technologies also.We work in the digitisation works also.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com

Re: $$Excel-Macros$$ Help on condition and return value

[Ms-Exl-Learner .]

Try this…


=IF(ISNUMBER(FIND(" ",TRIM(B2))),LEFT(TRIM(B2),FIND("
",TRIM(B2))),IF(LEN(TRIM(B2))<>0,B2,""))

---
Ms.Exl.Learner
---

On Thu, Mar 24, 2011 at 4:20 AM, Jorge Marques  wrote:

> Hi guys, is there any way i can do to for example if a cell B2 has the
> following text "phillips LCD 32"" it returns philips to cell B1 but without
> extracting the character on the left, because if it gives me a OEM brand, i
> have to put the information corresponding by vendor and not brand. thx
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



--

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel