Select the upper left corner of the worksheet. Above row 1 and the the left
of column A. This will select the entire worksheet. Right click any of the
row numbers, then select unhide.
On Mon, Feb 22, 2016 at 4:53 PM, wrote:
> Dear Experts:
>
> See the "Input" tab in the atttached workbook.
> Do
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
The lookup names have to be entered the same on both sheets, some need a
space and some don't have a space. Look more closely at the ones that
yield #N/A.
On Tue, Jul 10, 2012 at 5:23 AM, Deba Ranjan wrote:
> Hi Experts,
>
> i am getting error in vlookups in finding the names from 2 sheets.
See if the link below has something that would help you:
https://sites.google.com/site/normay/excel-files
Norman
2011/12/27 ♥.•:*¨¨*:•.♥.•:V.Kiran Kumar :•.♥.•:*¨¨*:•.♥ <
vadnalaki...@gmail.com>
> Dear Excel Experts
>
> If anybody has good automated Excel invoice template (
> http://www.youtube
Try the following formula:
=IF(ISERR(MID(A2,FIND(" ",A2)+1,IF(ISERR(FIND(" ",A2,FIND(" ",A2)+1)),
FIND(" ",A2),FIND(" ",A2,FIND(" ",A2)+1))-FIND(" ",A2)-1)),"",MID(A2,FIND("
",A2)+ 1,IF(ISERR(FIND(" ",A2,FIND(" ",A2)+1)),FIND(" ",A2),FIND("
",A2,FIND(" ",A2)+1))-FIND(" ",A2)-1))
Norman
On Sat, D
