Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations MintJulep on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: yogia
  • Order by date
  1. yogia

    Highlighting MIN value greater than zero

    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...
  2. yogia

    Highlighting MIN value greater than zero

    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...
  3. yogia

    PE Exam Flunkie

    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...
  4. yogia

    the smallest value that is greater than or equal to lookup_value

    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...
  5. yogia

    the smallest value that is greater than or equal to lookup_value

    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 ...
  6. yogia

    PE Exam Flunkie

    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...
  7. yogia

    Sand Mound Design Spreadsheet for MD unprotected

    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
  8. yogia

    Probelm with Excel Tools->View->Formulas option and Time format

    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...
  9. yogia

    rounding question

    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
  10. yogia

    LOOKUP TABLE!?

    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...
  11. yogia

    Unhiding worksheets

    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...
  12. yogia

    AM I IN A DREAM WORLD?

    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
  13. yogia

    Row Hiding

    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...
  14. yogia

    50 ksi W-shapes

    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
  15. yogia

    adding dates and times

    Hi athomas236: Of Course! Yogi Anand, D.Eng, P.E. Energy Efficient Building Network LLC ANAND Enterprises LLC http://www.energyefficientbuild.com
  16. yogia

    adding dates and times

    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
  17. yogia

    adding dates and times

    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
  18. yogia

    Trying to do this without VBA

    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...
  19. yogia

    Bolt Counts

    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...
  20. yogia

    DISPLAY SHEET NAMES

    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...

Part and Inventory Search

Back
Top