01/01/18

  1. R

    Sum values based on two criterias, one horizontal and the other vertical

    Hi, I'm sorry to post this as I'm sure someone will be able to answer this in a flash. But I have had a look through the forum and online and still couldn't quite find the answer I was looking for, which is the reason I'm reaching out, thank you in advance. I'm trying create a formula which...
  2. V

    Extract 3 columns from multiple xls files into a new xls file

    Hi, I am new to the forum and heard a lot about it. I am sure, I will get answer to my query, which I am struggling to solve. Here it goes I have 1000's of xls files where I am trying to fetch the information of 3 columns and corresponding rows into a new xls file. How to do it without...
  3. S

    Unique count in different format

    Hi I have a huge list of data lists data in this format Name Date Question UN A 01/01/18 Q1 1 A 01/01/18 Q2 1 A 01/02/18 Q1 2 i have pivoted the table and added a slicer for Date and UN. I’m trying to get a unique count of records not including the questions so for UN 1, A and 01/01/2018 the...
  4. P

    Auto filter and delete blank rows

    Hi can anyone help? On sheet1 I have data A1:G1 have headers A B C D E F G A2:H29 has data I have recored a macro and added (lRow) to the code to delete blank rows and unwanted data using AutoFilter. I want to Select ("A2:G" & lRow) at the end of the code which should select "A2:G11" (the...

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