Search results

I am preparing a dashboard using data provided by a call centre. As part of this process I need to add 2 time fields together. They represent the time taken to deal with the incoming call and the time the call is transferred, if that is appropriate. Being a relative newcomer to Power Query I...

Thanks SO much for taking the time to respond to my question vietm. I'm not sure that I understand your reply, but I'll try to follow what you have said. The main point of the project was to increase my daughter's understanding of Excel and I wanted to show her the concept of an interactive...

Thanks for the reply vietm. Perhaps I don't understand what you are trying to tell me. 1. There is a table populated with data. 2. The pivot table is updated when you add data, therefore the pivot table will always contain data. 3. The pivot chart is based on the pivot table, but selected...

Does anyone know if there is a process to report "must haves" or "nice to have" to these lovely people at Microsoft? I guess that it is the MVPs who will have most influence.

I just wish that Microsoft would let users restrict the scope of the timeline. Unless I am missing something the upper limit appears to be December of the last year for which there is data, but the lower limit is 1 January 1900. That's one heck of a lot of redundant dummy data to have to use...

I have left this problem for a couple of weeks and have now returned to it. I have managed a workaround which might be of potential interest to others. 1. I am now fairly certain that it is not possible to restrict the scope of the timeline. 2. I can use dummy data to add an insignificant...

Hi I have been trying to teach my daughter some more advanced Excel techniques than she learned in school and she suggested using some of her exercise data to provide a real life example. Her thinking was a dynamic chart , but I thought that we could be more creative, which is where I perhaps...

I have been given a spreadsheet which is basically along the lines of the attached spreadsheet and have been asked if it is possible to produce a pivot table or pivot chart to display selected data with multiple slicers. In the real world there are many more product categories, many more...

Chihiro Thanks for your prompt response and your help. I have turned off background refresh and the connections did indeed refresh more rapidly. {However I achieved an unexpected result. When I looked at the refreshed data it seems that , my formulae in the Sector Summary tab have...

I plan to create a dashboard using data obtained from the web. In order to prove the concept and make sure it was practical I created a worksheet which takes information from 4 tables on Google Finance. Worksheet attached. I have reformatted the tables and used camera to place all 4 images on...

Hui I have tried to load your new file with exactly the same "file corrupted" message

Hui I have tried the xlsx, xlsb and zip files and I too get the "file corrupted" message. Excel 2016 32 bit Windows 10 Professional 64bit. Hope this helps.

Chihiro Thanks for your continued interest. I understand exactly what you say about using a flat table structure rather than a cross-tab structure. However, my main concern here was to be the economy of data entry. I will be using a TINY keyboard and my objective was to be able to enter 4 or...

You have all been very helpful. As I said, there is almost always a number of ways of solving an Excel problem. I may have made a fundamental error in my thinking about how best to achieve what I wanted. I will be recording time information in a 32 * 24 matrix. If I could have performed the...

Khalid I didn't even think of using AGGREGATE. I am so grateful to you for posting this. I haven't had an opportunity to try it yet, but it an elegant solution to the problem. Excel is just so full of surprises. I'm frequently surprised at how many ways one can find to achieve an objective...

Nebu Your formulae correctly the fastest and slowest laps per hour but they do not determine the second and third fastest or slowest. Chihiro's formulae work perfectly and have saved me a great deal of time and frustration. Thank you for showing an interest. Regards, Alan

Chihiro You have been a great help. Very many thanks indeed. Regards, Alan

Thanks for your prompt reply. In the attached spreadsheet cell E20 should contain the second smallest number in row 9 where the number in row 11 is 1. Likewise F20 should contain the third smallest number where row 11 is 1 and so on. Cell E33 and cell F33 should contain the second largest...

My head is spinning and I need a little help. I have been asked to provide a spreadsheet to provide real time information for an 8 hour dinghy race. There will be up to 24 competitors and up to 32 laps. The spreadsheet will be run in LibreCalc on a Raspberry Pi and because the keyboard is...

Thanks very much for your help. This is just what I had in mind. I have one small question. When I use the scrollbar the table scrolls perfectly, but the scroll button flashes when you release the mouse button. Is this normal? Thanks again. Greenbriars

I am pretty sure that this is trivial, but I have been unable to find a solution online. The scenario is as follows: My daughter has just opened her first bank account and I am trying to get her interested in managing her money. I have created a spreadsheet which will record her transactions...

Thanks SM Aggregate is really one powerful function! I wonder whether the Excel community asked for something like this, or whether Microsoft decided that we needed it. I can't thank you enough for your help. I had spent many hours on this problem, but could not get it right.. Best regards...

Hi SM Once again Chandoo has been proved correct. You Excel Ninjas are simply awesome. Thank you very much for your help. I believe that this solves my problem, although I have only had a few minutes to test it. I thought that I was fairly competent in Excel, but I must say that I don't...

I hope that the following makes sense. Adjusting cells E3 and E4 in tab "Race Calculator" will determine the number of starts in the race. In turn, the table on the left in tab "PY Numbers" will show which start each class falls into. Mike has provided an array formula which works perfectly...

Mike Thanks for your help. Your solution is helpful to a point, but it does not really solve my problem. I attach the complete worksheet so that you will have a better idea of what I want to achieve. The scenario is that as a dinghy sailor we occasionally run what is called a pursuit race...