Posts by Ingo_Ingo


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))),"")



Your welcome.

Hi,
In A2 use this formula:
=VLOOKUP(B2,$F$2:$H$13,3,1) and drag down.

Hi,
For Lyra in column H, what is corect answer Beijing or Geneva or both?

Hi,
Change your Private Sub cmdOpen_Click() with this:
Private Sub cmdOpen_Click()
Dim sFilePath As String
sFilePath = "C:\Users\jchan\Documents\My Documents\NHRA\Chassis Inspection Info\Chassis Specs\Chassis Specs" & cboChassisSpec.Text
ActiveWorkbook.FollowHyperlink Address:=sFilePathEnd Sub

Maybe now someone could help...

Thanks for the answer, but I do not see how it could help me, that link.. I know that site.
I do not have access to the source file  it is "read only"  I would have wanted a code to do the processing  in memory  and then write it directly to the file where I run the code.
It seems difficult if nobody could answer. 
Hi,
I think it's too complicated ...