ann

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

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

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

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

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

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

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

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

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