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 …
Dumping Formulas
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 …
Dumping Formulas
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 …
Dumping Formulas
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 …
Conditional Formatting
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 …
Add Criteria to existing Index Formula
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 …
COUNTIFS Function not working
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 …
Copying row to another worksheet
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, …
Formula that copies values AND formatting
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 …
overtime sheet for field workers
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 …
Excel – Transpose
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 …
Integrated Sheets With a Drop Down List?
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 …
How to devide the value, based on drop down choices
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 …
Calculating costs / cumulative costs
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 …
Excel 2016 – IF Function – Sum Times for Specific Name/Date
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 …
Hyperlink to website + search number from adjacent cell
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 …
Daily Balance Sheet
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, …
Questions about my Excel works
Hi! I study use of Excel in my university, but I’ve encountered insurmountable challenge in my latest homework. No previous teaching material or …
How would I solve this problem?
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 …
Vlookup with Today() formula
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 …
Help with pulling information from a table
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 …
Question About X axis on a Chart
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 …
SUMPRODUCT and COUNTIFS Help
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, …
Calculate hours and date for deadline
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 …
Sum letter and his value
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 …
What is this formula for?
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 …
Formula help :)
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 …
finding the number of results with index match in excel
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 …
exclude rows with formulas from range in macro
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 …
Complicated nested IF AND OR statement….
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. …
Data comparison in 2 excel spreadsheet
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. …
Linking Cells/data maybe?
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, …
Autofill function and completing next cell correctly
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 …
Using a set of numbers to display a second, different set
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 …
NEED HELP IF/THEN FUNCTION
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 …
Formula on uknown number of rows
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 …
SUMPRODUCT text/vs populated cells
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: …
EXCEL IF function using date
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 …
Can I use RANK formula to calculate points?
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 …
Percentage of accuracy
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 …