Give this a shot.
It could be done as a nested if..then..else but for clarity, I recommend
making a custom function in the macro/vba editor.
to use, enter "=Answer(testcell) in you desired answer column, ie: in
Column C, enter"=answer(A1)".
Function Answer(MyCell)
acct = Left(MyCell, 1)
balance
Hello
Use in O6 cell formula = COUNTIF($D$5:$I$32;O5) and copy to right.
Regards
W dniu piątek, 13 marca 2015 07:28:20 UTC+1 użytkownik Will Sob napisał:
>
>
> Hi,
> Please I need help with the attached file. I want a that calculates how
> many times 10, 13, 17 has appeared within the range D5
Hi Venkat,
Attached sheet contains the scenario as well as the solution. Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Wed, May 27, 2009 at 9:19 AM, venkat sudhakar wrote:
> Dear Friends,
>
> I n
hi venkat
find the solution sheet attached...
On Wed, May 27, 2009 at 8:04 PM, Norman May wrote:
> Paste the following formula on sheet 2 cell B5:
> =SUMPRODUCT((Sheet1!$C$5:$C$5)*(Sheet1!$B$5:$B$5=A5))
>
> Norman
>
> On Wed, May 27, 2009 at 7:47 AM, venkat sudhakar wrote:
>
>> Dear
Paste the following formula on sheet 2 cell B5:
=SUMPRODUCT((Sheet1!$C$5:$C$5)*(Sheet1!$B$5:$B$5=A5))
Norman
On Wed, May 27, 2009 at 7:47 AM, venkat sudhakar wrote:
> Dear Friends,
>
> Please find sample file attached.
>
> Regards,
> Venkat.
>
>
> On 27/05/2009, Dave Bonallack wrote:
>>
Dear Friends,
Please find sample file attached.
Regards,
Venkat.
On 27/05/2009, Dave Bonallack wrote:
>
> Hi,
> Sounds like a job for SUMPRODUCT
> I could probably do the needful if you attached a sample worksheet.
> Regards - Dave.
>
> --
> Date: Wed, 27 May 2009 0
Hi venkat...
if i have understood your problem, following shud serve the purpose
Can try "SUMIF" function.
1. In second Sheet if the code is in A1 then type in cell say C1, =sumif(
2. Go to sheet one and select the range from A1 to "end of Column A" (if
column A contains Code) press "F4" to
Hello Venkat,
Can you provide me with the excel sheet? Or against correponding code in
second sheet. Apply formula =SUMIF('Sheet1'!(range of your data)'(code name
cell number)
Thanks and Regards
Atul Kesaria
On Wed, May 27, 2009 at 9:19 AM, venkat sudhakar wrote:
> Dear Friends,
>
> I need a fo
Venkat, can you post us a sample file..so that it would be easier to us to
help out...?
On Wed, May 27, 2009 at 9:19 AM, venkat sudhakar wrote:
> Dear Friends,
>
> I need a formula for my work.
>
> There will be 2 Excel sheets.
>
> In First Sheet there will be 2 Columns
>
> In First column there
Hi Venkat,
Sounds like a job for SUMPRODUCT.
We could probably do the needful if you attached a sample worksheet.
Regards - Dave.
Date: Wed, 27 May 2009 09:19:07 +0530
Subject: $$Excel-Macros$$ Formula needed
From: sudhakar...@gmail.com
To: excel-macros@googlegroups.com
Dear Friends,
I ne
Hi,
Sounds like a job for SUMPRODUCT
I could probably do the needful if you attached a sample worksheet.
Regards - Dave.
Date: Wed, 27 May 2009 09:19:07 +0530
Subject: $$Excel-Macros$$ Formula needed
From: sudhakar...@gmail.com
To: excel-macros@googlegroups.com
Dear Friends,
I need a fo
11 matches
Mail list logo
