I have a pivot table with a large number of filters - let's say 10.
In many situations, combinations of filters results in no data.
Is there a way that when one or more of the filters are set, the other
filter options are limited to choices (including ALL) where data would
exist?
--
Dear Amit,
Save your excel file with .xlsb extenstion...
On Fri, Aug 19, 2011 at 10:30 AM, Amit Desai (MERU) amit.de...@merucabs.com
wrote:
Dear All,
** **
I have an excel sheet of about 700 rows column till AZ. Because of the
using formula the same is functioning very
Dear Noorine
The file is not attached.
Tariq
On 18 August 2011 17:36, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
Always welcome dear
On Thu, Aug 18, 2011 at 4:36 PM, karunanithi ramaswamy era_...@yahoo.com
wrote:
Dear NOORAIN ANSARI,
THANK YOU VERY MUCH FOR YOUR FUNCTION. IT WORKS
Dear team,
Kindly help me in this regards
--
J.Gaurav
Operation Manager
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join
Dear Jayendra,
Please use below formula see attached sheet..
=TEXT((C2+D2)-(A2+B2),[H]:mm:ss)
--
Thanks regards,
Noorain Ansari
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Fri, Aug 19, 2011 at 1:28 PM, jayendra gaurav
jayendra.gau...@gmail.comwrote:
Dear
Dear Tariq,
I have attached Excel sheet in trailing mail.
--
Thanks regards,
Noorain Ansari
http://noorain-ansari.blogspot.com/
On Fri, Aug 19, 2011 at 11:14 AM, Tariq Aziz tariqkh...@gmail.com wrote:
Dear Noorine
The file is not attached.
Tariq
On 18 August 2011 17:36, NOORAIN
Very Very thanks for the kind help u reduce my work drastically
Thanks once again
On Thu, Aug 18, 2011 at 9:31 PM, Daniel dcolarde...@free.fr wrote:
Hello,
** **
This document provokes no error. See result from row 13 downward on sheet
“Feuil1” of the attached workbook.
** **
Great Noorain,
*Best Regards,*
*Venkat *
*Chennai*
*
*
On Fri, Aug 19, 2011 at 2:45 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Jayendra,
Please use below formula see attached sheet..
=TEXT((C2+D2)-(A2+B2),[H]:mm:ss)
--
Thanks regards,
Noorain Ansari
OMG!!! Thank you so much! Thats Perfect
On Aug 18, 10:56 pm, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
Pls see attached sheet if it help to you
On Fri, Aug 19, 2011 at 7:34 AM, Bob bobandrich...@comcast.net wrote:
I have a checkbox on Sheet1, When checked I want it to shade
Dear Sirs,
anybody please help regarding FIFO method in Ms Access 2003. Please see the
attachment. I want the fifo method will continue automatically in Ms
Access. I have mentioned only one scripts but there could be more than 100
scripts
Thanking you in Advance
Sanjib
--
Hi,
How do you copy Cell Comments, Please help.
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
Dear Pradhan,
Just Simple copy of Comment Cell and Paste it through Special Paste
and Check Comments Option
Step.
Copy-Special Paste-Click on Comments Check Box
On Fri, Aug 19, 2011 at 4:11 PM, N Pradhan nalini.pradha...@gmail.comwrote:
**
Hi,
How do you copy Cell Comments,
Try this
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Dinesh Prajapati
Sent: Thursday, August 18, 2011 7:15 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Countdown
Hi,
Can some one help me to create countdown ( Day-Hour-Min-Sec)
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Bob
Sent: Friday, August 19, 2011 3:10 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Check box to highlight Row if Checked
Please Help with code!
If CheckBox1 is Checked
Sub FOREACHTRUE()
mc = h 'change to column with formula
For i = 2 To Cells(Rows.Count, mc).End(xlUp).Row
If InStr(Cells(i, mc).Formula, TRUE) Then _
Rows(i).Hidden = True
Next
End Sub
From: ashish koul
Sent: Thursday, August 18, 2011 8:05 PM
To: excel-macros@googlegroups.com
Subject: Re:
Try this
Sub Filter()
Application.ScreenUpdating = False
On Error Resume Next
Dim Rec As Double
Dim rng As Range
Set rng = Selection
Rec = Range(A6).End(xlUp).Row
For i = 1 To Rec
If InStr(rng.Cells(i, 1).Formula, Range(C1).Value) Then
rng.Cells(i, 0).EntireRow.Hidden
Try this...
Go to tools -- options -- select Calculation tab -- check on
manual and make sure you check on recalculate before save. this is
going reduce the time taken by excel to calculate the formulae present
in your sheet. hence increasing the performance. I'm sure that you
have lot of
You can Try these
You can set calculation Mannual
You can Save your file in .xlsb
You Can Erase All After Last Rows and last Columns in that sheet
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Amit Desai (MERU)
Sent: Friday, August 19,
Try this
=((C2+D2)-(A2+B2))*1440/60
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of jayendra gaurav
Sent: Friday, August 19, 2011 1:28 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ difference time calculation
Dear team,
pleas find the below link..
http://forum.codecall.net/visual-basic-programming/4676-how-implement-lifo-fifo-method.html
On Fri, Aug 19, 2011 at 4:06 PM, Sanjib Chatterjee
chatterjee.kolk...@gmail.com wrote:
Dear Sirs,
anybody please help regarding FIFO method in Ms Access 2003. Please see
hey rajan,
what is the mean of 1440/60?
On Fri, Aug 19, 2011 at 7:22 PM, Rajan_Verma rajanverma1...@gmail.com wrote:
Try this
=((C2+D2)-(A2+B2))*1440/60
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of jayendra gaurav
Sent: Friday, August 19,
Try This
Public Cmt As Comment
Sub CopyComment()
Set Cmt = ActiveCell.Comment
End Sub
Sub PasteComment()
ActiveCell.AddComment Cmt.Text
CommentText =
End Sub
Press Shift+ctrl+C To Copy Comment
Press Shift+Ctrl+V to Paste Comment
From: excel-macros@googlegroups.com
What-if analysis is the process of changing the values in cells to see how
those changes will affect the outcome of formulas on the worksheet.
Three kinds of what-if analysis tools come with Excel: scenarios, data
tables, and Goal Seek.
1) Scenarios and data tables take sets of input values and
Hey N Pradhan,
please find the below link
http://www.contextures.com/xlcomments03.html
On Fri, Aug 19, 2011 at 4:11 PM, N Pradhan nalini.pradha...@gmail.comwrote:
**
Hi,
How do you copy Cell Comments, Please help.
Regards.
--
Its mean Minuts/Hour
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of XLS S
Sent: Friday, August 19, 2011 7:30 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ difference time calculation
hey rajan,
what is the
Rajan,
Your solution is awesome!!!
On Aug 19, 9:39 am, Rajan_Verma rajanverma1...@gmail.com wrote:
You Can Tri this :
Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo Err:
Dim k As Integer
If Target = Range(H7) Then
Application.EnableEvents = False
Thanks and Welcome
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Lawali
Sent: Friday, August 19, 2011 7:57 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Need your help in Vlookup formula.
Rajan,
Your
Thank you - I will. Funny i didn't see this earlier, I've spent about 3 days
looking around for examples.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
By the way - I need to be able to accomplish this using VBA - I don't want
to do it directly in the pivot table because I'm locking that down from a
sales organization that doesn't have a very high degree of 'Excel' skills.
--
can you attach the sample file
On Fri, Aug 19, 2011 at 8:48 PM, marston.go...@allstardirectories.com
marston.go...@allstardirectories.com wrote:
By the way - I need to be able to accomplish this using VBA - I don't want
to do it directly in the pivot table because I'm locking that down from a
Dear All,
Need your help, to have a formula to get answers in yellow cells for # of
services completed in TAT in days.
Sample sheet attached for your reference.
Best Regards,
Amit
--
--
Some important links for
*Thanks to all of you for spending your valuable time*.
On Fri, Aug 19, 2011 at 8:11 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
Thanks and Welcome
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Lawali
Sent: Friday,
very good help!! . thank you very much to all
excellent
2011/8/19 dguillett1 dguille...@gmail.com
I would put the table to create to the side and retain the top row of
formulas and just fire this. See attached
Sub DoPercentageTableNextToTable1()
Dim slr As Long
slr =
see if it helps
On Sat, Aug 20, 2011 at 9:21 AM, Amit Desai amit...@gmail.com wrote:
Dear All,
Need your help, to have a formula to get answers in yellow cells for # of
services completed in TAT in days.
Sample sheet attached for your reference.
Best Regards,
Amit
--
Use =INDIRECT('2011
Forecast'!ADDRESS(28,MATCH(TEXT(J3,),'2011 Forecast'!$A$2:$X
$2,0))) in Monthly IS, range F9
Steve, sure you can replicate this for all your cells.
Regards,
Sam Mathai Chacko (GL)
On Aug 19, 9:53 pm, Steve Weaver steveweave...@comcast.net wrote:
Hi,
Can some one help
See if it helps
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Amit Desai
Sent: Saturday, August 20, 2011 9:22 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ TAT reporting for assignment
Dear All,
Need your help, to have a
Thanks this helped...
Now what if I need, TAT range (0 - 2 day, 3 - 7 days, etc...) next to
Completion time in Days column in the attached file?
Best Regards,
Amit Desai
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of ashish koul
Sent: Saturday, August
37 matches
Mail list logo