Hi,
Hope all well! I am really struggling trying to work out the below so I am hoping someone can help.
Firstly, I'm using Microsoft 365 (business) and running Windows 10.
I have a situation whereby I have many rows of data every month to analyse.
So I have, say, 31 rows of data, with the first column being the date of the month, and the first row being the time of day (split by half hour) - so 49 columns in total.
The data itself is just standard numbers.
I need to have Excel identify the highest number in all 31 rows and 48 columns - I can do this part easily, however, I need Excel to then reference the date (row title) and the time of day (column title) the highest number occured in i.e. these would be output to two different cells with the time in one cell and the date in another.
That is the first part!
I then need to have the row that has been identified as having the highest number in it referenced into a new row (the full row of data, not just the cell with the highest number). And all the data in this newly referenced row needs to be multiplied by 2.
If anyone can help with this it would be very much appreciated!
Thanks,
James
Bookmarks