• Home
  • Excel Formulas
  • Excel Functions
  • Excel VBA
  • Help us Answer Questions
  • Ask a Question
Home / Posts tagged formulas

excel

I have some product list that are sold every month. I need to find the rate of sale for them now the rate of sale for them now the rate of sale should be sum …

August 28, 2019 | Excel 2003 Help, Excel Formulas | 164 Comments

Excel table equivalent to tree diagram

How do I create a 12-month table with several variables in Excel? Say I start with 5 possible X values and have two growth factors, each with 5 proposed values …

April 9, 2019 | Excel 2003 Help, Spreadsheets | 9 Comments

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 …

February 7, 2019 | Excel 2003 Help, Excel Formulas | 0 Comments

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 …

February 4, 2019 | Excel 2003 Help, Excel Formulas | 0 Comments

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 …

February 4, 2019 | Excel 2003 Help, Excel Formulas | 96 Comments

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 …

February 4, 2019 | Excel 2003 Help, Excel Formulas | 0 Comments

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 …

January 22, 2019 | Excel 2003 Help, Excel 2007 Help | 6 Comments

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 …

January 7, 2019 | Excel 2003 Help, Excel Formulas | 105 Comments

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 …

December 20, 2018 | Excel 2003 Help, Excel Formulas | 0 Comments

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, …

November 20, 2018 | Excel 2003 Help, Spreadsheets | 1 Comment

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 …

November 6, 2018 | Excel 2003 Help, Excel Formulas | 6 Comments

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 …

October 20, 2018 | Excel 2003 Help, Formula | 5 Comments

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 …

September 12, 2018 | Excel 2003 Help, Excel Formulas | 1 Comment

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 …

August 27, 2018 | Excel 2003 Help, Excel Formulas | 6 Comments

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 …

July 24, 2018 | Excel 2003 Help, Excel 2010 Help | 139 Comments

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 …

July 17, 2018 | Excel 2003 Help | 7 Comments

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 …

February 5, 2018 | Excel 2003 Help, Functions | 15 Comments

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 …

January 15, 2018 | Excel 2003 Help, Excel 2010 Help | 0 Comments

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, …

December 11, 2017 | Excel 2003 Help | 0 Comments

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 …

November 5, 2017 | Excel 2003 Help, Excel Formulas | 0 Comments

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 …

October 18, 2017 | Excel 2003 Help, Excel Formulas | 0 Comments

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 …

October 5, 2017 | Excel 2003 Help | 0 Comments

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 …

August 8, 2017 | Excel 2003 Help, Excel Formulas | 0 Comments

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 …

July 20, 2017 | Excel 2003 Help, Formula | 0 Comments

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, …

June 22, 2017 | Excel 2003 Help, Excel Formulas | 3 Comments

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 …

May 27, 2017 | Excel 2003 Help, Excel 2007 Help | 0 Comments

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 …

May 20, 2017 | Excel 2003 Help, Excel Formulas | 0 Comments

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 …

May 15, 2017 | Excel 2003 Help, Excel Formulas | 0 Comments

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 …

May 12, 2017 | Excel 2003 Help, Excel Formulas | 8 Comments

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 …

May 3, 2017 | Excel 2003 Help, Excel Formulas | 0 Comments

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 …

April 12, 2017 | Excel 2003 Help, Excel VBA | 208 Comments

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

February 1, 2017 | Excel 2003 Help, Excel 2010 Help | 7 Comments

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

February 1, 2017 | Excel 2003 Help, Excel Formulas | 0 Comments

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, …

January 4, 2017 | Excel 2003 Help, Excel 2010 Help | 0 Comments

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 …

December 29, 2016 | Excel 2003 Help, Excel 2010 Help | 0 Comments

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 …

December 22, 2016 | Excel 2003 Help, Excel Formulas | 1 Comment

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 …

November 8, 2016 | Excel 2003 Help, Excel Formulas | 1 Comment

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 …

November 8, 2016 | Excel 2003 Help, Excel 2007 Help | 0 Comments

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:   …

November 25, 2014 | Excel 2003 Help, Excel 2010 Help | 0 Comments

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 …

November 12, 2014 | Excel 2003 Help, Excel Formulas | 6 Comments
← Older posts

Topic Groupings

AND Array chart Colours in Excel Conditional Formatting count countif COUNTIF Function data Date Dates & Times Excel Excel-Vba Excel 2010 Excel Formula Excel Formulas Excel Functions Excel VBA Code filter find formula formulas function functions help IF IF Function index London LOOKUP Macro Macros. match percentage Pivot Table search sort SUM Sum Function SumIf SUMIFS table time VBA vlookup

Pages

  • All Excel Help Posts
  • All Posts
  • Ask a Question
  • Contact
  • Home 8
  • Latest Questions on Excel Geek
  • Post Archive

Categories

  • Excel 2003 Help
  • Excel 2007 Help
  • Excel 2010 Help
  • Excel Formulas
  • Excel Geek
  • Excel VBA
  • Excel VBA Books
  • Favourite
  • Formula
  • Functions
  • Keyboard Shortcut
  • Macros
  • Spreadsheets

Recent Posts

  • Formula to Extract Text from Cell
  • Excel work Lottery prediction
  • Formula Help
  • looking age of last non-matching value
  • solution
© 2014 ExcelGeek. All rights reserved.
Optional footer notes.