Posts by Ingo_Ingo


Try this:
Instead Tech Grade 1 in B1, use Custom Formatting "Tech Grade "# then in cell B1 put just number (1 or 2 or ...)
In Sheet1, cell B2, use this formula:
=IF(SUM(ISNUMBER(FIND("TG" & B$1,Sheet2!$B$2:$C$7))*(Sheet2!$A$2:$A$7=$A2))=1,"y","") than drag down till last name
and if you put in C1 number 2, then you can drag formula from B1 to C1 then drag down and so on.
Name Tech Grade 1 Tech Grade 2 Tech Grade 3 Joe y y y Dave y y Karen y y Bob y y 



Hi,
I'm not a programmer....
Try to format all txt......(who have data)...
In button UPDATE
Sheets("Worksheet").Cells(y, 3).Value = Format(txtReceived, "dd.mmm.YYYY") put data in your format mm/dd/yy or mmm/dd/yyyy ...
Sheets("Worksheet").Cells(y, 4).Value = Format(txtMoved, "dd.mmm.YYYY")
Sheets("Worksheet").Cells(y, 5).Value = Format(txtCompleted, "dd.mmm.yyyy")
Change everywhere you need.

Hi,
for this:
In Private Sub lstProformaDisplay_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
replace:
Me.txtDate.Value = Me.lstProformaDisplay.List(Me.lstProformaDisplay.ListIndex, 2)
with:
Me.txtDate.Value = Format(Me.lstProformaDisplay.List(Me.lstProformaDisplay.ListIndex, 2), "ddmmmyyyy")


Quote
=IF(Specific cell="","",Original formula), etc.
Try:
=If(a687="",0,IF(WEEKNUM(A687,21)=WEEKNUM(B687,21),WEEKNUM(A687,21),WEEKNUM(A687,21)&WEEKNUM(B687,21)))
or
=If(or(a687="",b687=""),0,IF(WEEKNUM(A687,21)=WEEKNUM(B687,21),WEEKNUM(A687,21),WEEKNUM(A687,21)&WEEKNUM(B687,21)))

Hi,
If your DOB 13061973 is in A2, then in B2 put this formula:
=DATE(YEAR(A2)+59,MONTH(A2),DAY(EOMONTH(A2,0)))

You forget to tell us that you posted same question here:

Common sense is not so common!



Hi,
use =IFERROR(B2*C2,0)+IFERROR(D2*E2,0)+IFERROR(F2*G2,0)+IFERROR(H2*I2,0)


The formulas given by me do not produce that zero.
However, those zeros can be removed with conditional formatting or Custom Format.

Hi,
In sheet SETUP
In E4 use this formula:
=IF($B$4="","",INDIRECT($B$4&"!G"&ROW()+3)) and drag down
and in D4 use this formula:
=IF($E4="","",IF(LEN($B$4),INDIRECT($B$4&"!"&"F"&ROW()+3),"")) and drag down
In sheet Material1, Material2, Material3
In F7, then drag to G7 then drag down, this ARRAY FORMULA:
=IFERROR(INDEX(B$7:B$26,SMALL(IF($D$7:$D$26="y",ROW(B$7:B$26)ROW(B$7)+1),ROWS($F$6:F6))),"")

