Grahamfff

Thank you. Would this be fairly easy repaired (or the power supply replaced? Do you think the power supply is likely to be specific to the Clavinova, or a fairy generic thing?

My Clavinova is making a very load humming and crackling noise as soon as it's turned on. Does anyone know anyone who can repair it. The piano is pretty old - about 25 years, I think.. Thanks

OK - thanks!

Thanks for this. Yes, as I mentioned, I know I can do it by using formulae but I'd realy like to know if I can use a pivot table. It's as much about assuaging my curiosity as getting the job done!

Hi I have a table of survey data which looks like this: Person Question 1 Question 2 Question 3 Question 4 Question 5 Question 6 Person 1 Yes Maybe No No Yes Maybe Person 2 Yes Maybe No No Yes Maybe Person 3 Yes Maybe Maybe Yes Yes Maybe Person 4 No Yes Yes Yes Yes Yes Person 5 Yes Yes No Yes Maybe Yes Person 6 Yes No Yes No Yes No Person 7 Maybe Maybe No No Yes No Person 8 Yes Yes No Maybe Maybe No Person 9 Maybe Maybe Maybe No Yes Yes Person 10 No No Maybe No Yes No I'd like to set up a pivot table which analyses it like this: Responses Question 1 Question 2 Question 3 Question 4 Question 5 Question 6 Maybe 2 5 3 1 2 3 No 2 2 5 6 0 4 Yes 6 3 2 3 8 3 However, whatever I do with the pivot table I can only get it look like this: Responses Question 1 Question 2 Question 3 Question 4 Question 5 Question 6 Maybe 2 2 2 2 2 2 No 2 2 2 2 2 2 Yes 6 6 6 6 6 6 So in this version, the responses to Q1 are repeated in each column. I know I can do this with formulae instead, but I feel there should be a way of using a pivot table, - I just can't get it to work! Can anyone help? Thanks

I am using a pivot table in Excel to report on numbers of events per quarter of the year. By default Excel regards Jan - March to be quarter 1. Can I get Excel to work with our financial year so that Quarter 1 is April - June and so on? Thanks

An article I was reading the other day referred to a bookshop at 233 Fulwood Road. This is where Record Collector now is. Can anyone confirm there was a bookshop there, probably in the 1970s. (I know there was one called the Broomhill Bookshop further up, on the other side of the Glossup Road junction, near the post Office). Thanks

Yes, sorry for the confusion! I mean a Echo Dot (5th generation, 2022 release) smart Bluetooth speaker with Alexa https://www.amazon.co.uk/echo-dot-2022/dp/B09B96TG33/ref=sr_1_1?crid=2MMPTUECMMOXA&keywords=amazon+echo&qid=1687940195&sprefix=amazon+echo%2Caps%2C84&sr=8-1

Thinking of getting one for a bedroom, Does anyone have one? What is the sound quality like? Thanks

Thanks - plenty of options!

Anyone know if there are any coffee shops in the city centre open till 7pm? Thanks

Thanks HallamGirl I created the macro just by recording my actions, not be writing VB code which is a bit of a mystery to me. Do you think your solution will still apply in this case? Thanks very much.

I have created a macro which creates a pivot table of my raw data, on the same sheet as that raw data and this works fine. But if the macro asks Excel to create a new sheet of the picot table, I get an error when I run the macro: Run time error '5': Invalid procedure, call or argument Anyone know why?

I am trying to get a friend's VM email working in Outlook on her new Windows laptop. I am repeatedly asked to give the email address and password which I know are correct because I can use these credentials to access her email on the VM website. Any suggestions? Thanks

Does anyone know when next year's fixture list is published? I know the Premiership fixtures are published on 15 June - will it be the same for the lower leagues? Thanks