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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: MeGustaXL
  • Content: Threads
  • Order by date
  1. MeGustaXL

    Determined, Decided or something else?

    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!
  2. MeGustaXL

    Father Of The Bride Speech

    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!
  3. MeGustaXL

    Dynamic MATCH function range

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

    XL2010 Data Validation List - Searchable Dropdown

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

    Pivot Table Conditional Formatting in XL2010

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

    XL 2010 Pivot Table Refresh Error

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

    IE11 - Country Problems

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

    Excel 2010 - convert date to six-digit string

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

    Abbreviations and Acronyms Table - Auto Compile

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

    Excel 2010 Chart with Log Scales

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

    Pivot Table - Suppress Rows Below/Above Threshold

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

    Excel 2010 Pivot Table Drilldown - Update Source table?

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

    Excel 2010 - Auto-Adjusting Trendline As Slope Changes

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

    Return Value From The Most Recent Cell

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

    AND shenanigans in XL2010

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

    XL2010 Bar-Of-Pie Chart

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

    Columns to Matrix in XL2003

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

    Link / Sync HTC One to PC

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

    What is an "Ideation Blog"?

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

    How can I make Excel 2003 my default version?

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

Part and Inventory Search

Back
Top