Dear Excel gurus,
I have noticed that many time you all use -- in a formula. Why is it been used
and when it should be used?
Sandeep Kumar Chhajer.
Sent on my BlackBerry® from Vodafone
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thre
I have done as said still the function is not working. So i want to
know where am i going wrong?
I have send u the screen shots on ur email as i dont know how to
attach files on these grp
Thanks,
Karan
On Dec 2, 8:15 pm, Sam Mathai Chacko wrote:
> Karan, sure I will try to help, but what is th
Dear Excel Experts...
I have created two separate work book.
1st one is the database and 2nd one is the report / summary file
now my query is that while checking the reports I dont want to open
the database file ,, currently I have to open both file for working.
Is there any easy way.
2ndly pl
Congratulation Sam Sir,
On Sat, Dec 3, 2011 at 5:02 AM, Asa Rossoff wrote:
> Sam,
>
> You're advice here is invaluable as always.
>
> Thanks for your kinds words last month.
>
> ** **
>
> Also Don, Noorain, Ashish, and everyone for your major contributions --
> appreciated.
>
Dear Excel Experts.
I have created a drop down list using data validation and the source
of the list is a dynamic range created at another sheet.
I have checked "Show error alert after invalid data entered"
Its working fine and showing the source list in the drop down list but
it also accepts an
Hi
I have two workbooks.sheet1 and sheet2. I want to find duplicates data from
sheet1 to sheet2.Is this possible to record a macro.for this?
Thanks
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent,
Sam,
You're advice here is invaluable as always.
Thanks for your kinds words last month.
Also Don, Noorain, Ashish, and everyone for your major contributions --
appreciated.
I enjoy helping others as time allows in several venues. It's rewarding and
a great way to learn more yourself,
Please find the information as requested
On Sat, Dec 3, 2011 at 1:25 AM, Aamir Shahzad wrote:
> Dear Group,
>
> I am using "Countifs" function how I give the second criteria e.g. I want
> >9 it's mean only pick the buckets of 10,11 & 12. See the attached file
> plz.
>
> Regards,
>
> Aamir Shahzad
Dear Experts,
Can anyone please tell me that how to Enable Activex Setting in Excel 2003.
I know how to do this in 2007.
Excel Option>Trust Center> Trust Center Setting>ActiveX Setting
But don't know hot to st thins in Excel 2003, Please help me
I will appreciate quick help
Please
--
Pankaj
Hi Ashish,
I don't have the answer for you, but perhaps these thoughts will be helpful
(especially if dynamically modifying macros is not practicle) --
You can do virtually anything you can do in macros, in VBA. and faster.
As I recall, the DoCmd object has methods for most of the macro comma
Dear Experts,
Greeting of the Day,
I am facing a very strength problem, I have created a workbook, which have
2 Text box and 2 Command Button in on a worksheet. but when i
am opening this workbook so some time after opening the Text box and
Command not appearing. This problem is occurring rendom
Just use >9 as ">9"
=COUNTIFS($G$3:$G$14,B4,$H$3:$H$14,">9")
Thanks,
Rohan.
--
FORUM RULES (934+ 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 not get
sample formula
=AND($D$4>3,$D$2>15)
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Aamir Shahzad
Sent: Friday, December 02, 2011 2:16 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Condition Formatting
Dear Group,
I am using the condition (if Khi>3days & Upcountry>1
Dear Group,
I am using the condition *(if Khi>3days & Upcountry>15 days)* just want to
ask you that how I use this in one formula in condition Formatting. Plz see
the attached file.
Secondly if grater than 2 conditions.
Regards,
Aamir Shahzad
--
FORUM RULES (934+ members already BANNED for v
Dear Group,
I am using "Countifs" function how I give the second criteria e.g. I want
>9 it's mean only pick the buckets of 10,11 & 12. See the attached file
plz.
Regards,
Aamir Shahzad
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thr
Nice work Rajan.
Aamir Shahzad
On Fri, Dec 2, 2011 at 11:24 PM, rajan verma wrote:
> if your list in a1:a10 then try this with CSE (ctrl+shift+Enter)
> =MAX(IF(A1:A10<>MAX(A1:A10),A1:A10))
>
>
>
> On Fri, Dec 2, 2011 at 5:31 AM, dguillett1 wrote:
>
>> Although the ORIGINAL post said nothing a
I tried to Import the table straight instead of making a link with MS
Access. The seems to solve the problem as most of the #N/A and #NUM
does not appear. I will try and create the query and the macro in the
imported table and see if it produces consistent results. Will get
back with the sheet inca
if your list in a1:a10 then try this with CSE (ctrl+shift+Enter)
=MAX(IF(A1:A10<>MAX(A1:A10),A1:A10))
On Fri, Dec 2, 2011 at 5:31 AM, dguillett1 wrote:
> Although the ORIGINAL post said nothing about DUPLICATES
> Using your sample, In P1
> =LARGE(O:O,1)
> and in P2
> =SMALL(O:O,COUNTIF(O:O,"
Congrats Boss.
On 12/2/11, Ayush Jain wrote:
> Hello Everyone,
>
> Sam Mathai Chacko has been recognised as 'Most Helpful Member' for the
> month of Nov'11
> He has posted 129 posts (13% of total posts) in Nov 2011 and helped many
> people through his expertise. He has been consistent contributo
The problem with hiding multiple rows is that each time a row is hidden,
there is a calculation that happens in the backend, which slows down the
overall processing time. So hiding 20-50 rows is OK, but when it comes to
large number of rows, the macro gets slow.
Check the module provided here whic
The column data type is normally allocated automatically depending on the
first 8 rows of the data in that column. After you have created a linked
table, if the data type in the excel sheet uses data of a different data
type, the access table will show erroneous values. Ensure that your formula
ret
Karan, sure I will try to help, but what is the problem to start with? You
haven't mentioned what issue you are facing.
Sam
On Fri, Dec 2, 2011 at 12:26 PM, Karan wrote:
> Dear SAM,
>
> I have created the addin from the above trailing mails. Can u please
> guide me where am i going wrong or how
Hi,
Finally done !
One silly mistake and 2 days wasted.
anyways thanks Ashish.
From: ashish koul
>To: excel-macros@googlegroups.com
>Sent: Thursday, 1 December 2011 5:49 PM
>Subject: Re: $$Excel-Macros$$ Excel to Word
>
>
>can you attach the sample document and send it to the group
>
Hi Experts,
Any info on the above issue!!
--
FORUM RULES (934+ 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 not get
quick attention or may not be a
Option Explicit
Sub ShowNegativesInColumnsI_L_SAS()
Dim i As Long
Application.ScreenUpdating = False
On Error Resume Next
For i = Cells(Rows.Count, "b").End(xlUp).Row - 1 To 1 Step -1
If Cells(i, "I") >= 0 Or Cells(i, "L") >= 0 Then _
Rows(i).Hidden = True
Next
Application.ScreenUpdating = T
do you want to hide rows with error value or not
On Fri, Dec 2, 2011 at 4:40 PM, AbdulGani Shaikh wrote:
> It gives error, screenshot of which is attached herewith
> Regards
>
> On Fri, Dec 2, 2011 at 12:20 PM, ashish koul wrote:
>
>> Sub hide_data()
>> Application.ScreenUpdating = False
>> App
Hi Friends,
Remember 3 years back, I started solving your MS Excel & VBA queries, today
I need your expertise in MS Access.
Issue: Using the VBA sub-routine, I would like to modify the 'MS Access
Macro Object'. If not modification, let me know about if we could create
the 'MS Access Macro o
27 matches
Mail list logo
