qld

  1. D

    Sum a column based on an IF Statement

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

    look up maximum date and state

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

    Tricky VLOOKUP

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

    Entire Row should fill with Yellow color and font should be Red using conditional formatting

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

    Delete Repetitive occurrence in a cell

    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/...
  6. D

    SUMIFS Statement with multiple OR functions

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

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top