Hi ,
just comment 2 codes and try
regards
venkat
Chennai
--
Sent from my Nokia phone
--Original message--
From: kip
To: "MS EXCEL AND VBA MACROS"
Date: Sunday, January 8, 2012 10:49:27 AM GMT-0800
Subject: $$Excel-Macros$$ Enable print and save in excel
Hi members,
I hav
Hi members,
I have the following macro which i am unable to remove from my excel.
I cant print nor save even after deleting the macro. I am supposed to
write another macro to enable the print and save function
Private Sub Workbook_BeforePrint(Cancel As Boolean)
MsgBox "You cannot print any of the
Hi Sam,
Thanks for solving the problem. All the best for your future.
Once again thanks a lot.
Regards
Lokesh.M
On Sun, Jan 8, 2012 at 11:56 PM, Sam Mathai Chacko wrote:
> To add it to the sumproduct formula, all you had to do was ensure that the
> correct sheet and the correct cells are being
Hi Sam,
I have checked this formula and i get the correct counts. and just add
these counts to your sumproduct formula based on name wise.
Thanks for solving the problem.
Regards
Lokesh
On Sun, Jan 8, 2012 at 11:28 PM, Sam Mathai Chacko wrote:
> Here's the formula as an array.
>
>
> =IF(ISERRO
Hi Amit
find attach workbook. hope this will help
Add one column in your pivot table data & use below formula
Assuming you want to count unique values from Range A:A in pivot table
=1/COUNTIF(A:A,A2)
it would be great if you could attach sample workbook.
HTH
Mahesh
On Sun, Jan 8, 2012 at 2:14 P
Hi sam,
thanks for your valuable reply,
Yes. i am looking deleted sheet count ANUSHA CHANNAPPA get 54 is to be
added in consolidated report cell F4.
regards
lokesh
On Sun, Jan 8, 2012 at 9:12 PM, Sam Mathai Chacko wrote:
> Lokesh, your request is not very clear. Can you please explain what
> ex
Lokesh, your request is not very clear. Can you please explain what exactly
are you wanting to do?
For example, how did ANUSHA CHANNAPPA get 54 counts??!!
Sam
On Sun, Jan 8, 2012 at 8:37 PM, lokesh wrote:
> Hi Experts,
>
> I am looking any updates from you. Please do the needful.
>
> Regards
>
Hi Experts,
I am looking any updates from you. Please do the needful.
Regards
Lokesh.M
-- Forwarded message --
From: Lokesh Loki
Date: Jan 8, 7:22 pm
Subject: Add counts in sumproduct
To: MS EXCEL AND VBA MACROS
Hi All,
Please find the attached excel file. And I need to add
Shekar,
When you ask for a solution, it would be best for people who volunteer to
help to understand exactly how your final output would look like.
If you ask me, I could not understand step 9 above, what to replace. The
code below will do everything above.
Sub Consolidator()
Dim rngCell As
Hi
Your formula in N168 would be
=COUNTIFS(Attendance!$E$4:$E$98,'Summary
Sheet'!$M168,Attendance!$C$4:$C$98,'Summary
Sheet'!N$167,INDEX(Attendance!$G$4:$AK$98,,MATCH($N$166,Attendance!$G$3:$AK$3)),"P")
Kris
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate
Try again making sure that the range SIZE is the same like
'=SUMPRODUCT((G3:J3=H3)*(A4:A7=2))
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Amit Desai (MERU)
Sent: Sunday, January 08, 2012 3:28 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ FW: Technical Team Daily
Hi again Christoph,
I mentioned using two-dimensional arrays.. well, let me retract that. I
think you'd be better off using a one-dimensional array of a user defined
type that holds your whole record/stack. You'd have to modify a sort
routine to reference the sort-by field in your type.
Asa
---
Chip Pearson has an in-place array sorting routine for download at
http://www.cpearson.com/excel/SortingArrays.aspx.
You might use a two-dimensional array to couple your related data, and check
if his QSort routine needs any modifications to just sort by the integer
value in that situation.
Here'
13 matches
Mail list logo