Search results for query: *

Review of the previous report decided (determined) that the following actions should be taken in future..." Suggestions/recommendations? Chris Someday I'll know what I'm donig...damn!

Hi, My daughter's getting married later this year, so I'm starting my Father Of The Bride speech. Any hints/tips/jokes or special lines I can use? Chris Someday I'll know what I'm donig...damn!

Hi, In a table of data, I'm using INDEX-MATCH to return a value from the Header_Row, based on the column of a Target_Value. With a fixed Search_Row, the formula is: =INDEX(Header_Row,1,MATCH(Target_Value,Search_Row,-1)+1) This works perfectly. [thumbsup] But, the table has 10 rows, with...

Hi Guys, Any ideas on how to make a Data Validation Dropdown list searchable, ie Auto-Complete? I've got the DV list set to a list on another sheet called "DV_LIST" and it all works great, except that DV_LIST contains 235 items, and scrolling down leads to folks just picking the nearest match...

Why won't my Conditional Formatting Rules apply in a Pivot Table field? Chris Someday I'll know what I'm donig...damn!

Hi, My workbook has a total of 19 Pivot Tables, linked to various Data Tables. When I do a "Refresh All", a message pops up saying that "This Pivot Table is invalid...." When I close and reopen the workbook, it gets repaired because of an "Invalid Pivot Table", and the xml report points to...

Hi, I'm in the UK, but my computer connects via a US-based server. This often brings up unwanted/irrelevant search results and form autofill results. To complicate matters further, my IP is interpreted by Google as being in Germany! Several websites don't work properly for me because they...

I need to express a Date as a 6-character string, which I can then CONCATENATE into a longer string. I'm in UK, so this example uses UK Date Format. Date 22 October 2017 is in Excel as 22/10/2017. By using DAY(), MONTH() and RIGHT(A1,2) I can get 221017. Great! But 1 April 2017 is formatted...

Big document - over 150 pages - with LOADS of Acronyms and Abbreviations. Table at the end listing them all. How can I make sure I get every initial (no pun intended) occurrence of an abbreviation and put it in the table? Also, check the other way, to make sure every abbreviation defined in...

Hi, I'm charting my data, and in order to get a straight line regression on it, I'm using Logarithmic X and Y axes, then putting a Power trendline on it. It all works just fine, but the data tends to be all bunched between one or two gridlines on the axis. For instance, X-values between...

Hi, Is there a way to hide PT rows so they don't chart when their Total is below (or above) a set threshold? For example, my failure data has many, many failures that have only happened once, so I'd like to leave them out of the Pivot Chart if the Row Total is 1. I tried setting the Y Axis...

Hi, I've got a Pivot Table based on a Source Table that is 25,000+ Rows by 75 columns. When I drill down into the Pivot Table, it understandably unearths the odd data error, duplicate, incorrect entry, etc. Correcting these is easy if there's just one or two - each row in the Source Table has...

Hi I plot trend data, either on log-log scales or linear graphs, and apply trendlines to the plot(s). Quite often, the plots have sharp doglegs and up- or down-ticks. When I see these, I split the data at that point, and make the chart into two (or more) series, each with a separate...

Components are Serial Numbered. I want to know what the current serial number is, but the SN isn't recorded every time. So I need to pick out the most recent recorded SN. Like this: Serial Number 116 14/12/2015 19/02/2013 116 21/04/2012 Unknown 10/02/2012 14/12/2010 162 03/02/2007 288 I need...

Hi there, As usual, I'm getting in a tangle with my ORs and ANDs The conditions I want to evaluate are of the form IF X and Y THEN A ELSE " " OR IF B AND C THEN A ELSE " " Trying to put this into a formula keeps giving me errors, and I know it's the syntax and order of IFs ANDs and ORs, but I...

Hi, My data is arranged by Groups, eg Frame, Engine, Furnishings, Electrical, etc. Each Group contains a number of Subgroups, so for example Engine contains; Oil, Fuel, Control, Exhaust. Electrical might contain Wiring, Generator, Control Panel, Lighting, etc. Each of these Subgroups can have...

Hi I want to produce a Criticality Matrix for a FMEA in XL2003. Three columns: Failure OCC SEV Mode2 6 4 Mode25 6 1 Mode8 10 5 Mode1 1 6 Mode26 10 10 Mode19 2 7 etc.... And I want to produce a 10 by 10 matrix with OCC along the bottom, 1 to 10 and SEV on the y axis, 1 to 10. Each...

Hi I have an HTC One running Android 4.4.2, and a Windows 8 PC (laptop) with HTC Sync Manager installed. When I connect the phone to the USB socket on the laptop, I'm hoping to be able to browse the files on the phone, but this never happens. Either: 1. HTC Sync Manager says that it is...

Anybody know what "Ideation Blog" means? Chris Someday I'll know what I'm donig...damn!

Hi Sounds daft I know, but believe me, it'll be easier this way! IT have upgraded me to Windows 7, and included Office 2007, sideloaded next to my old Office 2003. I have several spreadsheets I use daily that don't like XL2007, and neither do I, frankly, so that's why they've doubled up for...