Thanks Rajan and Shaik for your quick help, you have provided the same
which i was looking..
I also tried sumproduct but i have not succeedthank you once again.
Regards,
Vijayendra
2012/4/27 Shaik Waheed
> Hi Vijay,
>
> PFA, hope this is what you are looking for
>
> On Fri, Apr 27,
file not attached
On Fri, Apr 27, 2012 at 11:09 PM, who wrote:
>
>
> =SUMIF($G$7:$G$135,$G$142,I7:I135) - can copy this across. Will have to
> change to copy down =SUMIF($G$7:$G$135,G142,$I$7:$I$135)
>
>
> On Friday, April 27, 2012 7:43:04 AM UTC-7, Vijayendra wrote:
>
>> Dear All,
>>
>> I need
Not on Google, but here is a list that last I was on it had an excellent
group of people:
http://www.lsoft.com/scripts/wl.exe?SL1=ACCESS-L&H=PEACH.EASE.LSOFT.COM
Asa
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Anil Kumar
Sent
Dear Deba,
Thanx for the reply, if u find any link this please share the same with me...
But for sure, if we need to ask any question regarding the msaccess.
we have to have the membership in the group otherwise our attempt to
ask something will definetly will go in vein. I mean to say our voice
c
Hi
These groups are not very active but you can see the queries and answer
there..
http://groups.google.com/group/comp.databases.ms-access/about
http://groups.google.com/group/microsoft.public.access/about
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googl
*Happy Birthday Ayush*
Haseeb
--
FORUM RULES (986+ 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 answered.
2) Do
Dear Friends,
Can anyone give me the link to Subscribe Msaccess group.
Anyone's help is most welcome!
Rgds,
Anu.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Pr
Hello Lee,
This should work with just ENTER.
in AC2, then drag down.
=SUMPRODUCT((A$2:A$23=AB2)*(B$2:Z$23<>"")/COUNTIF(B$2:Z$23,B$2:Z$23&""))
Adjust the ranges. See the attached.
Regards,
Haseeb
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread title
=SUMIF($G$7:$G$135,$G$142,I7:I135) - can copy this across. Will have to
change to copy down =SUMIF($G$7:$G$135,G142,$I$7:$I$135)
On Friday, April 27, 2012 7:43:04 AM UTC-7, Vijayendra wrote:
> Dear All,
>
> I need one formula which will using for accounting entries, I tried
> sumproduct
no but this takes duplicates into consideration.. I would need count of
only unique values for every load no
On Fri, Apr 27, 2012 at 7:39 AM, Shaik Waheed wrote:
> Hi Sara,
>
> PFA, Hope this is what you are looking for...
>
> On Fri, Apr 27, 2012 at 4:33 PM, Sara Lee wrote:
>
>> Anil
>
>
> Happy birthday from cyberspace
>
Pascal
--
FORUM RULES (986+ 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
Hi,
Please help out
On Fri, Apr 27, 2012 at 4:31 PM, yogananda wrote:
> Hi Guys,
>
> Wats up, there is no one to revert on my issue raised. Please resolve
>
>
>
> On Friday, April 27, 2012 1:18:44 PM UTC+5:30, yogananda wrote:
>
>> Hi,
>>
>> Please help out
>>
>> On Friday, April 27, 2012 7:36:
Hi Vijay,
PFA, hope this is what you are looking for
On Fri, Apr 27, 2012 at 8:13 PM, Vijayendra Rao wrote:
> Dear All,
>
> I need one formula which will using for accounting entries, I tried
> sumproduct but it doesnt work. I have attached is the same file.
>
> Regards,
> Vijayendra
> 94491
Hi
Sumproduct is working fine with this:
=SUMPRODUCT(--($E$6:$E$136=E142)*--($F$6:$F$136=F142)*--($G$6:$G$136=G142),$I$6:$I$136)
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Vijayendra Rao
Sent: Apr/Fri/2012 08:13
To: excel-macro
Fantastic work , Rajan , I am very grateful
was what I needed
thank you very much
Chilexcel
2012/4/27 Rajan_Verma
> HI
>
> Please try this Code
>
> *Worksheet Is attached *
>
> ** **
>
> Sub MakeTotal()
>
>
>
> Dim rngSumRange As Range
>
> Dim wksSheetAs
Dear All,
I need one formula which will using for accounting entries, I tried
sumproduct but it doesnt work. I have attached is the same file.
Regards,
Vijayendra
94491 67631
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles,
You finish
Option Explicit
Sub transposeqmSAS()
'fire from qmform sheet
Dim dlr As Long
With Sheets("raw")
dlr = .Cells(Rows.Count, "b").End(xlUp).Row + 1
Range("C4:C40").Copy
Sheets("Raw").Cells(dlr, "b").PasteSpecial Paste:=xlPasteValues, _
Operation:=xlNone, SkipBlanks:=False, Transpose:=True
R
Hi,
How many worksheet of QM Form do you have ?
Rajan
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Mukesh Kukreja
Sent: Apr/Fri/2012 03:30
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Pls help me brothers, need macro - Urgently
Hi
Please find attached Sheet
=SUM(1/COUNTIF(OFFSET(INDEX(Range,MATCH(A2,Range,0),1),,1,COUNTIF(Range,A2),
COUNTA(D1:AC1)-1),OFFSET(INDEX(Range,MATCH(A2,Range,0),1),,1,COUNTIF(Range,A
2),COUNTA(D1:AC1)-1)))-1
Rajan
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.
Also, Happy birthday from Texas
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Sam Mathai Chacko
Sent: Thursday, April 26, 2012 7:05 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Happy Birth Day Ayush.
Happy Birthday Ayush. Have a great new y
Anil
it s not the count of loads.. i need the count of distinct values for every
load no
ie Load 0241
7151865O 7154687O 7175843O 7202990O 7212856O 7253406O
has 6 values both from top row and bottom row.. so 6 should be the output
for load 0241
in some case as u see, some loads have 3 ro
Hi Guys,
Wats up, there is no one to revert on my issue raised. Please resolve
On Friday, April 27, 2012 1:18:44 PM UTC+5:30, yogananda wrote:
> Hi,
>
> Please help out
>
> On Friday, April 27, 2012 7:36:30 AM UTC+5:30, yogananda wrote:
>
>> Hi Champs
>>
>> Did anyone tried out to solve
why need macros? use paste as transpose only.
From: Mukesh Kukreja
To: excel-macros@googlegroups.com
Sent: Friday, April 27, 2012 3:29 PM
Subject: $$Excel-Macros$$ Pls help me brothers, need macro - Urgently
Hi All,
Request you to kindly help me very u
*Thanks All, I got it. very thanks
*
Thanks & Regards,*
*
*Deba Ranjan P***
On Fri, Apr 27, 2012 at 3:04 PM, Shaik Waheed wrote:
> Hi Ranjan,
> You are talking about conditional formatting, please go through the links
> to understand it better with examples.
>
> http://www.cpearson.com
Hi Rabinder,
PFA, hope this what you are looking for.
On Fri, Apr 27, 2012 at 1:48 PM, CoRe wrote:
> Hello Ravin,
>
>
> Please check the file attached .
>
> To open Data Validation form , ALT+ D + L
>
>
> If you have any queries , let me know.
>
>
> On Thursday, April 26, 2012 11:49:56 PM U
Dear Sara,
Its Working Fine please find the attached file.
Thanks & Regards
Anil Kumar
113784
On Fri, Apr 27, 2012 at 2:52 PM, Darwin Chan wrote:
> See if you understand array formula.
>
> http://www.excelfunctions.net/Excel-Array-Formulas.html
>
>
> 2012/4/27 Sara Lee
>
>> thee are two si
Hi Ranjan,
You are talking about conditional formatting, please go through the links
to understand it better with examples.
http://www.cpearson.com/excel/cformatting.htm
http://www.contextures.com/xlcondformat03.html
On Fri, Apr 27, 2012 at 2:25 PM, Deba Ranjan wrote:
> *Hi expert ,
>
>I sh
See if you understand array formula.
http://www.excelfunctions.net/Excel-Array-Formulas.html
2012/4/27 Sara Lee
> thee are two similar rows with same load no---this is not working
>
> On Fri, Apr 27, 2012 at 4:06 AM, anil panchal wrote:
>
>> you can use
>>
>> =SUMPRODUCT(--($A$2:$A$23=AB2))
>>
thee are two similar rows with same load no---this is not working
On Fri, Apr 27, 2012 at 4:06 AM, anil panchal wrote:
> you can use
>
> =SUMPRODUCT(--($A$2:$A$23=AB2))
>
>
>
>
> On Fri, Apr 27, 2012 at 1:26 PM, Sara Lee wrote:
>
>> yes i need count of distinct records for each load no-- sample
---
vaibhav joshi wants to stay in better touch using some of Google's coolest new
products.
If you already have Gmail or Google Talk, visit:
http://mail.google.com/mail/b-29daa15304-2281a1c1c5-cD4o7BwlshmGRs_ZxeoZnFvClE8
You'll
---
vaibhav joshi wants to stay in better touch using some of Google's coolest new
products.
If you already have Gmail or Google Talk, visit:
http://mail.google.com/mail/b-29daa15304-4e8aa75804-CjxffWWvzra9YU7ZRv_4gHK2GNE
You'll
---
vaibhav joshi wants to stay in better touch using some of Google's coolest new
products.
If you already have Gmail or Google Talk, visit:
http://mail.google.com/mail/b-29daa15304-20eb8c6583-JcvylIh1e0iWMo6nIvdeo3X2Y_k
You'll
Hi Vijay,
You said:
>> which calculate and change after every 5 min
This lead me to guess that your workbook is kept in manual calculation mode,
and you have a VBA macro that periodically recalculates the workbook. If
this is correct, please post the macro that performs the calculation.
Or
should i paste in AB2?
On Fri, Apr 27, 2012 at 4:52 AM, Darwin Chan wrote:
> sara,
>
> the formula should workfirst highlight the range you want to implement
> this formula, then you should try Ctrl + Shift + Enter.
>
>
> 2012/4/27 Sara Lee
>
>> it is not working-- anybody else can help here
*Hi expert ,
I show the attached file, its very valuable. any way i just want to ask
the method, on the data validation, how to change the color automatically,
eg:-
Selecting 1:- Red,
2:- yellow
Please explain it to me.
Thanks in advance.
*
Thanks & Regards,*
*
*Deb
sara,
the formula should workfirst highlight the range you want to implement
this formula, then you should try Ctrl + Shift + Enter.
2012/4/27 Sara Lee
> it is not working-- anybody else can help here
>
>
> On Fri, Apr 27, 2012 at 4:06 AM, anil panchal wrote:
>
>> you can use
>>
>> =SUMPROD
it is not working-- anybody else can help here
On Fri, Apr 27, 2012 at 4:06 AM, anil panchal wrote:
> you can use
>
> =SUMPRODUCT(--($A$2:$A$23=AB2))
>
>
>
>
> On Fri, Apr 27, 2012 at 1:26 PM, Sara Lee wrote:
>
>> yes i need count of distinct records for each load no-- sample output
>>
>> load
Hello Ravin,
Please check the file attached .
To open Data Validation form , ALT+ D + L
If you have any queries , let me know.
On Thursday, April 26, 2012 11:49:56 PM UTC+3, ravin wrote:
> Dear All,
>
>
>
> I am making large data sheet of company name list.
>
> My concern is when
you can use
=SUMPRODUCT(--($A$2:$A$23=AB2))
On Fri, Apr 27, 2012 at 1:26 PM, Sara Lee wrote:
> yes i need count of distinct records for each load no-- sample output
>
> load 02416
> load 02423
> load 02452
> load 02462
>
>
> On Fri, Apr 27, 2012 at 3:45 AM, Ab
yes i need count of distinct records for each load no-- sample output
load 02416
load 02423
load 02452
load 02462
On Fri, Apr 27, 2012 at 3:45 AM, Abhishek Jain wrote:
> Actually count of values stored in adjacent columns of each load number is
> required. For Loa
Hi,
Please help out
On Friday, April 27, 2012 7:36:30 AM UTC+5:30, yogananda wrote:
> Hi Champs
>
> Did anyone tried out to solve my problem
>
> -- Forwarded message --
> From: yogananda muthaiah
> Date: Thu, Apr 26, 2012 at 11:12 PM
> Subject: Fwd: $$Excel-Macros$$ Attendance
Actually count of values stored in adjacent columns of each load number is
required. For Load 0241 - there are 6 values so the formula should return 6.
On Fri, Apr 27, 2012 at 1:09 PM, Darwin Chan wrote:
> Hi Sara,
>
> Seems formula COUNTIF can solve your problem simply.
>
> 2012/4/27 Sara Lee
Hi Sara,
Seems formula COUNTIF can solve your problem simply.
2012/4/27 Sara Lee
> hi
>
> i have data as in the attached data. i need count of unique values of
> column A i.e i need output as in column AB, AC... pls advise a formula
> thanks
>
> --
> FORUM RULES (986+ members already BANNED
Hi Waheeb
Please give me the formula for the same I would like to apply for full sheet
Thanx lot for your valuable support
Vaibhav
On Fri, Apr 27, 2012 at 12:17 PM, Shaik Waheed wrote:
> Hi,
>
> PFA
>
> On Fri, Apr 27, 2012 at 11:12 AM, vaibhav joshi wrote:
>
>> Dear All
>>
>> Followin
44 matches
Mail list logo
