Search results for query: *

Thanks guys... I settled on "Based on a review of the previous Report, the Big Boss decided that..." Much better [bigsmile] Chris Someday I'll know what I'm donig...damn!

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 strongm, I'm sorry I didn't reply sooner, but we were sidetracked to another project and now off for Christmas. I'll try it out during the break and get back to you ASAP OK? Thanks for helping, and have a merry Christmas and Happy New year 😊 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...

Hi Andy, I know what you mean, but as I learned a lesson from this, I decided to share that lesson with the Tek-Tips Family [thumbsup2] Chris Someday I'll know what I'm donig...damn!

Forget it! My bad, I was putting quotes around the criteria words and phrases, which it turned into formulas and....D'Oh Chris Someday I'll know what I'm donig...damn!

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

Skip, Sorry for the delay but we've been diverted for the last few days. Tweenster and I have tried the Missing Items property and clearing the Pivot Caches, manually and by VBA, but the error still occurs every time the WS is opened. Any chance it could be due to the sheer gigantic size of the...

Thanks Skip, tried that and it Refreshed them all nicely, but closing and reopening still kicks off a repair of PivotTable8, even though the entire tab with it on has been deleted [thumbsdown] 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...

Thanks combo [2thumbsup] That's the reminder I needed! No need for XY Chart Labeller (fantastic though it is) Chris Someday I'll know what I'm donig...damn!

Hi Skip, Star for you too, as I gave my (other) friend a medal...you must've posted almost at the same time as me! Chris Someday I'll know what I'm donig...damn!

Sometimes the hardest things are soooooo simple! My colleague came up with the Winner: =TEXT(A1,"ddmmyy") [medal] Chris Someday I'll know what I'm donig...damn!

I guess the nub of it is that the limits of the axis as I've set them, are already Minor Grid points! Chris Someday I'll know what I'm donig...damn!

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

I know Skip, thanks. I don't think Excel provides that functionality. It's just a presentation thing, really. I can look at the chart as it is and understand it, but the people in floors above like to see grids so they can say "So what's with the gap between, ooh 23,300 and 24,300-ish?" Come...

The Chart I'm working with has Running hours on the X-Axis, and Count of Events on the Y-Axis. Both axes are set to Logarithmic, and the data Series has a Power Trendline applied. All works great, and the Trendline equation gives me the results I expect and require. It's just that the data...