Hi Trackfiend:
The 'It' you refered to in your post is the Conditional Formatting formula:
=MIN(IF(A1:A101>0,A1:A101))
All I am saying is that the 'It' does not work me as Conditional Formatting formula. What does work for me is ...
=A1=MIN(IF(A$1:A$101>0,A$1:A$101))
Now mind you I am using...
Hi trackfiend:
I don't think using ... =MIN(IF(A1:A101>0,A1:A101)) as Conditional Formatting formula will work.
Would you please clarify, if you did use a formulation for Conditional Formatting other than reference to the cell with the related MINIMUM value, what is that formulation.
Yogi...
I think meaningful experience in your area of work, good preparation, and composure are the keys. When I took my PE exam, I had been out of school for many years ... I was quite scared, however, I did take both parts 1 & 2 at the same time and I was fortunate enough to get through in the first...
Hi josephv:
continuing with my last post, may array formulas ...
array formula ... =MIN(IF(ISNUMBER(1/(A1:E1>=A2)),A1:E1))
and
array formula ... =LOOKUP(INDEX(A1:E1,MATCH(1,1/(A1:E1>=A2),0)),A1:E1)
will give the correct result even if the entries in cells A1:E1 were not in ascending order...
Hi Josephv:
Using the layout as in Yakpol's post, here are couple of other formulations that should work for you ...
1) formula ... =INDEX(A1:E1,INDEX(MATCH(1,1/(A1:E1>=A2),0),0))
2) array formula ... =MIN(IF(ISNUMBER(1/(A1:E1>=A2)),A1:E1))
3) array formula ...
Hi Okieduck71:
You have received very good counsel from a lot of people. No giving up ... of course not -- remember as long as you don't quit you have not failed.
Apart from being well prepared, the references you take along to the exam should be used only to locate where to find what ... the...
Hi newnickname:
Thanks for posting and sharing this spreadsheet!
Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC
ANAND Enterprises LLC
http://www.energyefficientbuild.com
Hi nodalDOF:
In the following illustration, I formatted cell A5 as TEXT before entering TIME to enable the value to be showed in hh:mm:ss display even when the formulas are being displayed ...
Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC
ANAND Enterprises LLC...
Hi ACtrafficengr:
for using ROUNDDOWN, try ... =ROUNDDOWN(B2/A2,0)*A2
where B2=39, and A2=5
Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC
ANAND Enterprises LLC
http://www.energyefficientbuild.com
HI Housila:
The reason you are not getting the right result is because ...
Use of LOOKUP function requires that the values in the LookUp column be arranged in ascending order
One of the ways would be use the VLOOKUP function as in ...
Yogi Anand, D.Eng, P.E.
Energy Efficient Building...
Hi boottmills:
Picking up from TomBarsh, ... how about unhiding say Sheet6, Sheet7, and Sheet9
Sub y_1a()
For Each sh In Sheets(Array("Sheet6", "Sheet7", "Sheet9"))
With sh
.Visible = True
End With
Next
End Sub
Would this work for you...
Hi Harley:
I couldn't quite follow, so where are you at -- is it going to be a formula based approach, or are you going to use a macro?
Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC
ANAND Enterprises LLC
http://www.energyefficientbuild.com
Hi Harley78:
If I understand you correctly ...
Cells(i, 47).EntireRow.Hidden = True will hide row number i
and
Cells(i, 47).EntireRow.Hidden = False will unhide row number i
If I misunderstood your question, my apologies.
Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC...
Hi Mike:
The link didn't come through!
Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC
ANAND Enterprises LLC
http://www.energyefficientbuild.com
