## How to identify similar (not duplicate) text within same column

I have a column that has address line data in and I want to see how many unique addresses I have, the issue is the fields have been manually typed in so using …

I have a column that has address line data in and I want to see how many unique addresses I have, the issue is the fields have been manually typed in so using …

I have a spreadsheet with hundreds of cells and formulas in a high percentage of them. Rather than transcribe each cell’s formula, is there a way …

I have a spreadsheet with hundreds of cells and formulas in a high percentage of them. Rather than transcribe each cell’s formula, is there a way …

I have a spreadsheet with hundreds of cells and formulas in a high percentage of them. Rather than transcribe each cell’s formula, is there a way …

I have an excel spreadsheet that takes information from a main sheet and uses formulas to break it down into smaller sheets. I also need it to format the …

I have a summary sheet where I’m trying to create a list of all of the people that meet a criteria. That formula is working, but it is giving me …

Hi I’m tearing my hair out with this one – can you help? I have two seperate workbooks – 1 contains a Match ID & a match Outcome …

I am wanting to know how to do two things please: 1) I have a worksheet with lots of rows. I want to filter those down so that if Column G says certain words, …

A1 = “Hello World!” in bold. In cell A2, there is a formaula =A1. I want A2 to match the formatting of A1 but don’t know how to …

i would like to create a sheet for calculating overtime workers that work on field. calculating the hours for 2 different dates is fine but separating it …

Hallo Clever People, I need to take the following data: Object Field Low High Node S_TABU_DIS ACTVT 1 18 S_TABU_DIS ACTVT 2 18 S_TABU_DIS ACTVT 3 …

I am trying to create a workbook for my company to decide who has gone through and completed something that needs to be done. I was wondering if there is a way …

Hello, I am looking to find a way to divide certain value based on the drop down choices in excel. What I am trying to do is to make a way to …

Hi there, I’m looking for some help as I’m not really sure of the correct terms to use on my query below, so whilst normally I would google …

I am trying to set up a spreadsheet into which I can dump a month’s worth of appointment dates, times, and visit durations for a variety of people. I …

I have created a link to a website: no big deal. I am trying to get a formula to ‘add’ the number from an adjacent cell A1, A2, etc. to search at …

I need a workbook to keep up with cash paid out and received daily. I would like to have multiple sheets for each month (example – dec. 1st, dec. 2nd, …

Hi! I study use of Excel in my university, but I’ve encountered insurmountable challenge in my latest homework. No previous teaching material or …

The cost of materials is $22.59. One person can assemble four per hour. You pay that person $10.25 per hour. The cost of packaging is $1.50 and it takes 5 …

The first table is the input table. The second table is the for the results. The result should display as follow: – If the end date of the …

Hello, so I am trying to create a volunteer hour tracker for my organization where people will go in add their name and other information about their …

Hello, I am trying to do a chart and need to edit the X-Axis. I see where you can edit the increments, but is there anyway to do two different …

I’m looking to get assistance on how to count the number of employees who servered customers during each hour, of each day. I have the employee name, …

Hello all, I need help using excel formulas to figure out the date and time of deadlines. I don’t need a timer since the spreasheet will only be to see …

Hi I need some help. I want to put in one column for example 5 times letter X (in two rows) X X X X X X X X X X and I want to have Sum of them (or count) to …

If you take (A1-A2)/A2 , what does this formula give you? Let’s say you’re doing a YOY comparison, if A1 is April 2017 and A2 is April 2016, would …

Hello! I am currently working on a workbook involving inventory on each sheet. On my cover sheet I have a summary of all of the rooms where …

Hi, I have a table that looks like this: C denotes columns C1 C2 C3 A B C A E F A B E A B C A B D I know I can use index match to match against two criteria …

I made a Data Entry Form that ads or updates rows in a datasheet. With this http://www.contextures.com/exceldataentryupdateform.html as the base. The …

Ok here goes…. So I am trying to evaluate two sets of values in two cells let’s just say, for the sake of argument, cell A1 and cell B1. …

Hi, Need help from excel experts . I need to do data comparison and consolidation between 2 excel files, which have employee leave data in different formats. …

Thank you in adavace, you’ll be saving hours in the day. Ok, so I have a couple hundred items for sale on Amazon. When i try to get any kind of report, …

Hi there, I am somewhat new to excel and was hoping if someone could help me with this. I am using excel to track some proejcts that I am currently working on …

Hi! I am having problems figuring out an Excel formula. This is for Excel 2010 on a Windows PC. I want to enter a number in one cell, then display a …

I am trying to create an if/then function with text…every way i write it i get error..I want to make it so if 2 cells that are adjacent both contain …

Hi I receive every month the same data in an excell file.I would like to create a new sheet in this file with the same data (and some calculations) in order to …

Hi There, I am trying to create a formula to count the amount of forms returned by a department. The database is set up in a way as such: …

Hi, I’m trying to run an if function in excel which will add up the numbers in one column depending on the values in 2 other columns. The 3 …

I have a worksheet where I have calculated placings from 1st to 49th (this number will change on each worksheet – sometimes more, sometimes less). I …

I would like to obtain a percentage of accuracy for a box office prediction site. For example let’s say i have this: A1 Predicted Gross / B1 Actual …

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. How Google uses data when you use our partners' sites or apps

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.