vic

Hello I have the following set of data I would like to like to do the following: Total the values in Annual Peak KWh* for each state so e.g There are 2 rows for VIC with 180,000 in each row so the total would be 360,000 1 row for QLD = 200000 What is the formula to create to do that for...

Hi I need a formula to look up maximum date and corresponding state In below case it should look at state , eg VIC and also maximum date 04/01/2019, giving answer 50 <colgroup><col width="64" style="width: 48pt;"> <col width="68" style="width: 51pt; mso-width-source: userset; mso-width-alt...

Hey guys, I've been pulling my hair and trying to work this out, I was wondering if there's a formula that would allow me to remove the extra semi-columns, see data below: <style type="text/css"><!--br {mso-data-placement:same-cell;}--></style> <tbody> ;;;;;;VIC; ;;;;;;VIC; ;;;;SA...

How do I remove everything in a cell that comes before the final set of characters "..." In this example of how the data in the cells appears, I would like to have a column next to this that would have just "Melbourne" (if I could eliminate the ending period "." too that would be great. ACE.AU...