Re: $$Excel-Macros$$ Shortening an Excel Sheet

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

Re: $$Excel-Macros$$ Question about function

Change the formula in J2 from =F2G2H2I2D2 to =F2G2TEXT(H2,dd/mm/)I2D2 On Sun, Jun 30, 2013 at 3:17 PM, Bé Trần Văn betnmtdongna...@gmail.comwrote: 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

Re: $$Excel-Macros$$ Question about function

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 betnmtdongna...@gmail.comwrote: Question 1: I need one function to the

Re: $$Excel-Macros$$ Question about function

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 betnmtdongna...@gmail.comwrote: Question 1: I need one function to the column

Re: $$Excel-Macros$$ Look up errors from 2 sheets.

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 drdeva...@gmail.com wrote: Hi Experts, i am getting error in vlookups in finding the

Re: $$Excel-Macros$$ Excel Invoice Template

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 (

Re: $$Excel-Macros$$ Mid Function

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, Dec 17, 2011 at 2:03 PM, Aamir