Hi Nai Chin,
Without looking at the file it almost impossible tell whats wrong. Can you
post the file. so that someone can look at it.
Cheers,
Tawhid
On Sunday, 10 November 2013 08:14:07 UTC+1, Nai Chin wrote:
>
> I have a workbook which has thousands macro (user functions) on one
> worksheet
Please send me the file I have the solution without changing your data.
On 12 Nov 2013 09:55, "Vinay Saraf" wrote:
> You can insert one column which contain sum of all 40 column and you can
> use vlookup on that column
> On 12 Nov 2013 09:21, "Shrinivas Shevde" wrote:
>
>> Dear Vinay
>> Thanks f
Hi
Please help me, to create a formula with small function and Vlook up
function.
Regards
Ravindra
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
It's very simple to Sum of more than one column. You can use SUM function
by different type of range as mention below.
=SUM(AV2:AV15)+SUM(AW2:AW15)
=SUM(AV2:AW15)
On Tue, Nov 12, 2013 at 9:55 AM, Vinay Saraf wrote:
> You can insert one column which contain sum of all 40 column and you can
> use
Kantila,
Thanks for your effort. I appreciate it and everyone else's contribution. I
have a question
I want to add to this. So, I looked at the code and notice that you have
defined everything to end at line 23 (except for the last past that says
22?). That's fine, I thought I could cha
You can insert one column which contain sum of all 40 column and you can
use vlookup on that column
On 12 Nov 2013 09:21, "Shrinivas Shevde" wrote:
> Dear Vinay
> Thanks for reply
> Actually I want to sum of more than 40 column
> Regards
> Shrinivas
>
>
> On Mon, Nov 11, 2013 at 5:51 PM, Vinay S
PFA
Non array solution
CA Kantilal Badale
On Tue, Nov 12, 2013 at 7:33 AM, Bill Q wrote:
> PERECT Ravinder !
>
> MANY thanks !
>
>
> On Monday, 11 November 2013 02:01:37 UTC-5, ravinder negi wrote:
>
>> pfa
>>
>>
>>
>> *From:* excel-...@googlegroups.com [mailto:excel-...@googlegroups.com]
Dear Vinay
Thanks for reply
Actually I want to sum of more than 40 column
Regards
Shrinivas
On Mon, Nov 11, 2013 at 5:51 PM, Vinay Saraf wrote:
> You can use vlookup or sumif 3 times and add all three
> On 11 Nov 2013 17:27, "Shrinivas Shevde" wrote:
>
>> Dear All
>> In vlookup we are giving
PERECT Ravinder !
MANY thanks !
On Monday, 11 November 2013 02:01:37 UTC-5, ravinder negi wrote:
> pfa
>
>
>
> *From:* excel-...@googlegroups.com [mailto:
> excel-...@googlegroups.com ] *On Behalf Of *Bill Q
> *Sent:* Sunday, November 10, 2013 10:55 PM
> *To:* excel-...@googlegroups.co
Thanks Bruce
On Monday, 11 November 2013 19:51:30 UTC-5, bruce wrote:
> What is PFA?PFA is "Please Find Attached"
> On Monday, November 11, 2013 3:49:38 PM UTC-8, Bill Q wrote:
>>
>> What does pfa mean ?
>>
>>
>> On Monday, November 11, 2013 2:01:37 AM UTC-5, ravinder negi wrote:
>>
>>> pf
What is PFA?PFA is "Please Find Attached"
On Monday, November 11, 2013 3:49:38 PM UTC-8, Bill Q wrote:
>
> What does pfa mean ?
>
>
> On Monday, November 11, 2013 2:01:37 AM UTC-5, ravinder negi wrote:
>
>> pfa
>>
>>
>>
>> *From:* excel-...@googlegroups.com [mailto:excel-...@googlegroups.com]
What does pfa mean ?
On Monday, November 11, 2013 2:01:37 AM UTC-5, ravinder negi wrote:
> pfa
>
>
>
> *From:* excel-...@googlegroups.com [mailto:
> excel-...@googlegroups.com ] *On Behalf Of *Bill Q
> *Sent:* Sunday, November 10, 2013 10:55 PM
> *To:* excel-...@googlegroups.com
> *Subject
You can use vlookup or sumif 3 times and add all three
On 11 Nov 2013 17:27, "Shrinivas Shevde" wrote:
> Dear All
> In vlookup we are giving the column no from which value should be picked
> up .
> I want to get the summation of 3 column is it possible?
> For Eg
> I want to get the summation of c
Sent from my HTC
- Reply message -
From: "Jorge Marques"
To:
Subject: $$Excel-Macros$$ Extract data in worksheet in xml format to another
sheet
Date: Mon, Nov 11, 2013 5:03 pm
Hi Ashish, I have to do it by Macro has the data I get from is email and I
have no access to external sourc
Dear All
In vlookup we are giving the column no from which value should be picked up
.
I want to get the summation of 3 column is it possible?
For Eg
I want to get the summation of column 9,10,12
Can anyone tell me how to do it
Thanks in advance
--
Shrini
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT
Great, Thanks a lot Ravi sir, you are just a excel rocker. Thanks a ton.
With warm regards,
Rajan Sharma
On Mon, Nov 11, 2013 at 4:22 PM, Ravi Kumar wrote:
>
>
>
>
> Is this what u r looking for?
>
>
>
> PFA solution…
>
>
>
>
>
>
>
> *Warm Regards,*
>
> *Ravi Kumar.*
>
>
>
> *From:* excel-m
Is this what u r looking for?
PFA solution.
Warm Regards,
Ravi Kumar.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rajan sharma
Sent: Monday, November 11, 2013 4:10 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$
Thanks Ravi sir, Actually still my requirement is not yet fulfill. Please
find the attachment, i did manually in the attached excel.
Thanks for the help.
With warm regards,
Rajan Sharma
On Mon, Nov 11, 2013 at 3:59 PM, Ravinder wrote:
> pfa
>
>
>
> *From:* excel-macros@googlegroups.com [ma
pfa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rajan sharma
Sent: Monday, November 11, 2013 3:42 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Formula Error
Dear experts,
I have wrote formula in the attached file, but throwing
Thanks for the prompt reply Ravi Sir,
I am still stuck in the formula and getting error even after using CSE.
Please write in excel please.
With warm regards,
Rajan Sharma
On Mon, Nov 11, 2013 at 3:51 PM, Ravinder wrote:
>
> =(INDEX($A$1:$A$51,SMALL(IF(($G2=$B$2:$B$51)*(K$1=$D$2:$D$51)*RO
=(INDEX($A$1:$A$51,SMALL(IF(($G2=$B$2:$B$51)*(K$1=$D$2:$D$51)*ROW($B$2:$B$51
)>0,ROW($A$2:$A$51)),COLUMN($A$1
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rajan sharma
Sent: Monday, November 11, 2013 3:42 PM
To: excel-macros@googlegroups.com
Subjec
Dear experts,
I have wrote formula in the attached file, but throwing error. Please
modify the formula and where i am wrong.
Thanks in advance.
With warm regards,
Rajan Sharma
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join officia
Dear Harish,
Pl find attached herewith the solution.
Warm Regards,
Gawli Anil.
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Mon, Nov 11, 2013 at 2:37 PM, Harish P Y wrote:
>
> Hi Vinay,
>
> In the location wise work sheet when i select the locat
Hi Vinay,
In the location wise work sheet when i select the location as sheet 1 like
that it should fetch the corresponding grade wise quantities from the the
grade wise work sheet
Regards
Harish
With Regards
*HARISH P Y*
*P* *THINK BEFORE YOU PRINT:**Before printing this e-mail think whether i
hi
value in local currency is rate or total amount?
On Mon, Nov 11, 2013 at 10:05 AM, C.G.Kumar wrote:
> Hi,
>
> Please advise how to use get all data matching specific condition.
> (Vlookup captures only first in data range)
>
> Sample file attached.
>
> -- Forwarded message --
please explain your exact requirement.
On Mon, Nov 11, 2013 at 12:56 PM, Harish P Y wrote:
> Hi Excel Guru's,
>
> Need help
> Please find the attached file
> when i go into the location sheet and select the location, kindly help me
> how to update.
>
> Regards
> Harish
>
> --
> Are you =EXP(E:R
26 matches
Mail list logo
