I have tried to write VBA code to compute the % of recovered cases (row 4) vs total cases in row 2. The formula is in row 5
Your assistance is most appreciatedPlease Login or Register to view this content.
I have tried to write VBA code to compute the % of recovered cases (row 4) vs total cases in row 2. The formula is in row 5
Your assistance is most appreciatedPlease Login or Register to view this content.
Hi Howard,
If you change the way you keep your data, a Pivot Table can show the % Increase from one day to the next. You simply drag the value down a second time and show as. See the attached:
Percent Increase of Corona Cases.xlsm
See the example on https://www.howtogeek.com/407781/cal...h-pivottables/
Now go wash your hands...
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Thanks Marvin
How did you get the table in Row 11 onwards in that format ?
Last edited by Howardc1001; 04-18-2020 at 10:58 PM.
Hey Howard,
To get your data into what I wanted, I used Power Query. It took about 30 seconds to convert it using UnPivot, a tool in PQ. I'm not sure you have Power Query in your version but you could. Watch: https://www.bing.com/videos/search?q...tail&FORM=VIRE for UnPivot. You won't need the last part.
Thanks for the link. It helped me a lot. I used Power Query a while back, but have not used it much. Will use it a lot more in future.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks