
Last seen: Sep 16, 2025
Hi Hannes, There's no workbook attached. Regards Phil
Hi Themba as Velouria said, you haven’t explained what you are trying to do or why you are doing it. If we don’t understand the problem and the res...
Hi, We need to see the code to be able to help 🙂 Regards Phil
Hi, Can you please supply a workbook with sample data. Thx Phil
Hi Alison, You can use the Transpose function as explained here: Use OFFSET to get the range and then wrap it in TRANSPOSE. Regards Phil
I'll check this, thanks for letting me know.
Hi, Can you provide the context for this, it might make it easier to work out a solution. Why are you trying to do this? In your examples, you ...
Hi Alison, I've raised this with the SumProduct team. Regards Phil
Hi Alison, I've checked with the team who produced the course and they are working on getting this fixed. Regards Phil
Hi John, There's no attachment. Regards Phil
Hi, Can you supply some example data and the result you expect. As much detail and info as possible 🙂 Thanks Phil
Hi Charlie, If the manufacturer doesn't provide a means for you to get the device data into Excel then I'm not sure how you would do it. Microso...