@googlegroups.com
Subject: Re: $$Excel-Macros$$ VLOOKUP OR SUMPRODUCT FORMULA HELP
Hi Rajan
Get Total function (UDF) is perfectly fine, but it is taking too much time to
process large data.
Is there any other way to get the same results using Excel in-built functions
like VLOOKUP/ SUMPRODUCT/ INDIRECT. I
]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Amit Gandhi
> *Sent:* 23 June 2012 5:19
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ VLOOKUP OR SUMPRODUCT FORMULA HELP
>
> ** **
2012 5:19
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ VLOOKUP OR SUMPRODUCT FORMULA HELP
Thanks Mr. Rajan
For given set of values, its working perfectly. But I have some questions.
1. If values in H5:H9 are changed, then it doesn't give correct result.
Pls su
Thanks Mr. Rajan
For given set of values, its working perfectly. But I have some questions.
1. If values in H5:H9 are changed, then it doesn't give correct result.
Pls suggest function, which can work independently and doesn't depend on
adjacent column. I am attaching modified task file for your
Hi Amit,
It will fulfil your requirement . J , See the attached.
Function GetTotal(rngLookUpRange, rngMapping As Range, rngLookup As Range,
lngCOlumnresult As Long, lngMinusValue As Double) As Double
Dim VarMapping
Dim VarLookup
Dim strLookUp
Dim lngResult As
Hi Rajan
no counts are calculated, Input table 2 is manual feeded table. In result
table I want TOTAL of values in column G and/or H against each "BL#_MAWB#"
against each "Invoice#".
Regards
Amit
On Fri, Jun 22, 2012 at 6:09 PM, Rajan_Verma wrote:
> One instant question:
>
> ** **
>
> How
One instant question:
How is counts Calculated in Input table 2?
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Amit Gandhi
Sent: 22 June 2012 5:20
To: excel-macros@googlegroups.com
Subject: $$Ex
