Search results for query: *

Exactly! This post relates to a larger project of converting imperial linear measurements to metric.

UPDATE #2 I thought I solved it by removing the -1, but there's a problem elsewhere with it now. AAARGH. Still working to fix it.

UPDATE: I've isolated the issue to this line: (ABS(LEFT(I7,SEARCH(CHAR(34),I7)-1))) When put into its own cell, it needs to be =IFERROR((ABS(LEFT(I7,SEARCH(CHAR(34),I7)-1))),0). Instead of returning 0 when the content in I7 is only any fraction of an inch except numerator > 12/denominator =...

Thank you for your reply, Deniall. I'll take your advice and see if that method helps me to solve the issue.

Thank you for your reply, BFroeschlKC. I will use your method to see if I can isolate the problem. I'll post back to relay the results.

Hello dhookum, Thanks for your reply. I have considered it, but would rather not have an xlsm, as I need it to be as user-friendly as possible for unskilled workmates to open on their work machines and phones without having to enable macros and make it a trusted document. Phillip

Hello Mighty Excelers! I'm stumped. I have formulae that extract numbers from imperial linear measurements which are formatted in specific ways, for example: 12' 11-13/16" or 11-13/16" (when there are no feet) or 11" (when there are no feet and no fraction) or 13/16" (when there are no feet and...

Thanks for your replies, Andrzejek and Combo! Andrzejek's solution worked very well. I couldn't get Combo's to; probably my ineptitude.

Hi Techies, I have an Excel spreadsheet that tracks hourly temperature and relative humidity for Level 1 and Level 2. It uses averages, and minimum and maximum values. I've attached it to make it easier to follow my issue. In the range B12:AW12, I've averaged the readings for temperature and...

Hi Tech! Thanks in advance for your help. Tek-Tips has always been extremely helpful when I'm expreriencing stumpage. I posted this in the asp forum, where it was suggested that it might be a CSS formatting issue. Is there something with my CSS thaat could be causing the grief? I have an asp...

Oops! Well spotted, guitarzan. That was just an error from my clumsy copy and pasting. The variable idxItems holds a value from a previously opened recordset that filters the results of the SQL statement. As I didn't paste the code for the entire page (it's too onerous), I just pasted that line...

Hi Tech! Thanks in advance for your help. Tek-Tips has always been extremely helpful when I'm expreriencing stumpage. I have an asp page that connects to a database. Everything works great except for this one table cell on the page. In the database is a table, tblTravelHistory: (there are...

Thank you, JVF and Skip! All of your solutions work perfectly. I went with SUMPRODUCT, as it works across all Excel versions, including legacy. Your help is awesome! Thanks again.

Hi Tech, I've been pulling my hair out over this one. The range F3:F7 holds numbers. Cell G9 holds the sum of F3:F7. I want G9 to sum only the values in that range where the corresponding cells in columns I, J and K are blank. In other words, if F3=9, and either I3, J3 or K3 are not blank...

As usual, I was making things more difficult than they actually are. The problem was that the main report was bound to a query that returned multiple invoice numbers, so the subreports in the detail section repeated themselves the corresponding number of times. Making the main report unbound...

Hello All, In the attached (Access 2000) database, the report repeats the Detail section once for every invoice from which it draws data. So, what should be a 3-page report on 10 invoices becomes a 30-page report with the same information repeated on pages 4 through 30. A 2-page report on 6...

Hi Chris, Thank you for your reply. When I remove "position: fixed;" from header_container, undesireable effects are produced: the header doubles in height (?!), and the header scrolls up with the rest of the page. What I'm trying for is to only have the header's height expand when the buttons...

Hello Gurus! This page works just like I want, except for one thing: when the browser window is resized so that the header buttons take up two rows, the now height-expanded header encroaches upon the beginning of the content. What I wish would happen is that the entire content block would...

I've solved it, by: 1. examining the output (page source) of the working version; 2. using that to replace the deprecated html with current html; 3. replacing with the new html and testing variable values one at a time. There were a few mistakes in my previous attempts, including a couple that...

Correction: the end of the above code block is: rs.Close set rs = Nothing conn.Close set conn = Nothing %> </TABLE> </div> </div> </BODY> </HTML>