qld

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...

G'day guys - we have 2 sheets sheet1 and sheet2 both sheets can go down to row 10,000 JOB ID is found in Column C and Delivery Price is found in Column I. We have the below: What we found was because Vlookup is finding the first entry with BLANK it returns BLANK as you'd expect - however we...

Hi Folks, Here is my question . 1) If i select the drop down list either Offshore Reject or Onsite Rejected or client rejected in the attached sheet in column H2 i want the entire row from A2 to H2 should be formatted with Yellow fill color and the font should be RED. 2) If i select the drop...

Hi, i have an excel sheet with an Address column - The Zip code is repeated twice in the column and i wanna remove the repetition - <tbody> Zurich House, Level 5, 201 Leichhardt St Spring Hill QLD 4004 , 4004 Zurich House, Level 5, 201 Leichhardt St Spring Hill QLD 4004 Zurich House, 6/...

Hey all, First time poster and hoping to get a bit of help. I've got a set of data that I need to sum up with 2 conditions however one of the conditions has got multiple (roughly 70) or statements. I can get this working with the below function: =SUM(SUMIFS('QLD Data'!H:H,'QLD...