ann

  1. M

    Filtering Excel Data with VBA

    Hi All, I have been searching the internet to solve my little problem. I have some data and I would like to filter in place unique data to show unique values only. I dont want to copy the data to another sheet as i will be using the filtered data to filter it down some more. So for example...
  2. J

    duplicate rows

    I have had this question before and the macro does not work any more any suggestions the top half is single and the bottom half is where I want to get to. <colgroup><col span="2"><col><col><col><col><col></colgroup><tbody> <colgroup><col span="2"><col><col><col><col><col></colgroup><tbody> 25...
  3. P

    Sort & filter several times in one Sheet

    Hello. I' trying to find a way to filter several Places in one sheet What I want to havethe options to filter/sort tasks in a “logical” order or dates. That is bothtask 1,2,3,4,5 and ascending dates to task 1,2,3,4,5. See the illustrationunderneath. The problem is thatthe tasks and dates are...
  4. jevi

    Look Up with If Statement formula

    <colgroup><col><col span="2"><col span="2"></colgroup><tbody> 05/11/2018 Ann 01/11/2018 -06/11/2018 Ann Ann 01/12/2018 -02/12/2018 Sam 24/12/2018 -24/12/2018 Sam 28/12/2018 -28/12/2018 </tbody> =LOOKUP(3;2/($D$1:$D$4<=A1)/($E$1:$E$4>=A1);$C$1:$C$4) Hi all...
  5. A

    lookup value if there are multiple matches

    Hi there, I have data that when i vlookup it only picks up the first value. What is the best way of being able to find the corresponding value in a different column if the criteria matches? For example, i want to be able to find what all the Type 2 bookings are for the individuals. What...
  6. S

    Abbreviate a full name in 1 cell to a new cell

    Hello. I have a column of cells that contain a first and last name. Is there a way I can trim that cell from the full name to an abbreviated name as follows: cell B2 shows "Ann Smith" - this is provided for me. I want cell C2 to show "ASmith" Do I need to break Ann Smith into 2 columns, then...
  7. M

    Counting alpha and numerical data in a cell

    I have a sheet that has 4 columns and 32 rows. In Col D there are alpha and numerical data prefixed Annnn or Annn or Ann e.g. A1234 or A111 or A22. Each entry is separated by a ','. I wish to count the number of occurrences of a Annn and / or Annn and/ or Ann in each specific cell, D2 to D32...
  8. B

    Text To Columns Question

    I am about to set up a macro for a report I need to download weekly that has employee address information in order to stay current on their addresses for a mail merge I use weekly. Basically there are unneeded columns and then sorting that needs done. Unfortunately, the report comes with their...
  9. O

    stuck on date time addition

    <colgroup><col><col><col><col span="2"><col></colgroup><tbody> tom 05:55 01/08/2017 05:55 01/08/2017 00:00:01 sid 05:59 01/08/2017 05:59 01/08/2017 00:00:01 ann 06:00 01/08/2017 06:00 01/08/2017 00:00:01 jo 06:08 01/08/2017 06:08 01/08/2017 00:00:01 tom 08:00 01/08/2017 08:00...

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