Thanks for the reply.
2013/7/3 Waseem Saifi
> Dear Van,
>
> I have placed a formula in first sheet in K column.
> it might help you.
>
>
> On Mon, Jul 1, 2013 at 12:47 AM, Bé Trần Văn wrote:
>
>> Question 1: I need one function to the column numbered F.
>>
>> Question 2: In column J, How to con
Thanks for your help
Please thank.
2013/7/1 De Premor
> istied using SUMPRODUCT, we can also use SUM with CSE
>
> {=SUM(--($C$2:C2=C2)) &". ("&TEXT(B2,"dd/mm/")&") - "&D2}
>
> Rgds,
> [dp]
>
>
> On 01/07/2013 7:33, Norman Cliff May wrote:
>
> If the countif function is not available to you,
istied using SUMPRODUCT, we can also use SUM with CSE
{=SUM(--($C$2:C2=C2)) &". ("&TEXT(B2,"dd/mm/")&") - "&D2}
Rgds,
[dp]
On 01/07/2013 7:33, Norman Cliff May wrote:
If the countif function is not available to you, the following formula
should work in cell E2 and copy down.
=SUMPRODUCT(-
If the countif function is not available to you, the following formula
should work in cell E2 and copy down.
=SUMPRODUCT(--($C$2:C2=C2))&". ("&TEXT(B2,"dd/mm/")&") - "&D2
On Sun, Jun 30, 2013 at 3:17 PM, Bé Trần Văn wrote:
> Question 1: I need one function to the column numbered F.
>
> Ques
Another suggestion would be to put the following formula in cell E2 and
copy down.
=COUNTIF($C$2:C2,C2)&". ("&TEXT(B2,"dd/mm/")&") - "&D2
Delete the columns to the right of column E
On Sun, Jun 30, 2013 at 3:17 PM, Bé Trần Văn wrote:
> Question 1: I need one function to the column numbered
I think the following formula does everything you are wanting to do if you
paste it into cell F2 and copy down.
=IF(E1=E2,(LEFT(F1,FIND(".",F1,1)-1))+1,1)&". ("&TEXT(B2,"dd/mm/")&") -
"&D2
Then you could delete the columns to the right of column F
On Sun, Jun 30, 2013 at 3:17 PM, Bé Trần Văn
Change the formula in J2 from =F2&G2&H2&I2&D2 to
=F2&G2&TEXT(H2,"dd/mm/")&I2&D2
On Sun, Jun 30, 2013 at 3:17 PM, Bé Trần Văn wrote:
> Question 1: I need one function to the column numbered F.
>
> Question 2: In column J, How to connect string (F & G & H & I & D),
> without losing formatting
