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
Thanks FrenchCAD ... now let us keep EXCELing!
Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC
ANAND Enterprises LLC
http://www.energyefficientbuild.com
Hi athomas236:
You may aldo try ...
=TEXT(DATE(A1,B1,C1)+(D1&":"),"dd mmmm yyyy hhmm")
Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC
ANAND Enterprises LLC
http://www.energyefficientbuild.com
Hi gadero:
Following is a formula based solution ...
| A | B | C | D | E | F
---|----------|---------|------------|-------|-------|----
1|MonthCompare
2|column1 column2 column3 data1 data2
3|Bill 1/2/2007 1/13/2007 6 16...
Hi Engineeeeeeeeer:
Not knowing exactly how your data is laid out, it is hard to talk of actual formulations, but how about looking into using one or more of ...
1) COUNTIF
2) SUMIF
3) SUMPRODUCT
4) DSUM, DCOUNT, ...
4) AdvancedFilter
5) PivotTable
6) DataTable
7) ....
functions/features in...
Hi bylar:
You may also want to try ...
Sub yListAllSheetNamesInWorkbook()
For i = 1 To Sheets.Count
cells(i, 1) = Sheets(i).Name
Next i
End Sub
This will print the name of every sheet in the Workbook in column A of the ActiveSheet starting with row 1.
Yogi Anand, D.Eng, P.E...