jul

  1. K

    sum totals in one column if values in another column are equal

    I have an Excel 2010 worksheet tracking homeless client data for a cold weather shelter for families. Each family is assigned a number. If there are 5 members in the family, they will all have the same unique family number. The Family # is in column D of the spreadsheet. One of the family...
  2. H

    converting Date to a readable date

    Guys, I am downloading a file from one software. the date format i am getting in the file is like this <tbody> 21 Jul, 11 </tbody> I tried to convert the date using formatting, I also tried using len,mid,left right but whatever value I get that's not in standard MM/DD/YYYY format which is...
  3. H

    Formula to extract data based on Month & Year

    I have source data on Sheet1 for Jul 2017 (cell K1) on a particular workbook which is imported-see sample Data Below I have July 2017 on another Workbook (K4) and would like to extract the figures for each dept pertaining to the month Applicable I would like a formula to extract the data...

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
Back
Top