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

Journal Entry Automation

I am wanting to create an automated General Ledger and Journal Entries. The way I am wanting to set this is up is having a list set up that a user can choose …

April 18, 2018 | Excel 2003 Help, Excel Formulas | 0 Comments

Calculation of combinations

Hi,   I have an issue. Lets say I have 4 numbers (10, 50, 100, 250) and I want excel to give me the best combination of those numbers that will get me as …

April 3, 2018 | Excel 2003 Help, Excel Formulas | 0 Comments

Some assistance needed

Aoa, i am Uzma Razzaq from Islamabad Pakistan. i need a formula for excel sheet. As i have record of fee of school students. Condition: If more than one child …

March 29, 2018 | Excel 2003 Help, Excel 2007 Help | 0 Comments

Excel VBA master sheet copy-paste error 1004

Hello, I am new to VBA formulas in excel. I have a workbook with multiple sheets which needs to be copied(only values) in a master sheet in the same workbook. …

March 28, 2018 | Excel 2003 Help, Excel VBA | 1 Comment

Which is the best function

I am using Excel 2016. I need to figure how to get the cell to calculate the total by adding specific amounts which are based on an index.  For the …

March 25, 2018 | Excel 2003 Help, Formula | 0 Comments

Looking up text in string

Need to consolidate or look up which client deposited funds to our account. On our BANK DATA we see the account number or a reference from whom the transfer is …

March 18, 2018 | Excel 2003 Help, Formula | 0 Comments

Vacation Tracker earned days off based on years employed

I am needing help with the following I have spreadsheet that states employees hire date and formula to calculate that date to current date which auto generates …

March 9, 2018 | Excel 2003 Help, Excel Formulas | 0 Comments

Manipulate data in excel to order results per a certain column

Hi,   I want to make the information in some columns (but not all) displaying in rows, please see below an example.   This is what I have:   …

February 26, 2018 | Excel 2003 Help, Excel Formulas | 0 Comments

Formula for If cell A2 is “text”, B2 = copy paste formula of B1

Hi, As written in the title,  I want to copy past (similar to dragging down the formula) from a cell above if another specific cell contains a specific …

February 19, 2018 | Excel 2003 Help, Excel Formulas | 0 Comments

Work days with every working day displayed in a row

Hi everyone,  I was wondering if someone could push me in the right direction regarding how to build a formula. I am looking for something to display …

February 17, 2018 | Excel 2003 Help, Excel 2010 Help | 0 Comments

How to keep same column but different row in formula when pasting in multiple cells?

I want to compare row and column values. My formula is =IF(A2=B1,1,0) . Next below cell formula would be =IF(A3=B1,1,0) and so on. Meaning compare the value of …

February 12, 2018 | Excel 2003 Help, Excel 2010 Help | 1 Comment

Scanning sheet in excel

Hello,    I am working in a retail store and need to audit my inventory. I need to scan barcode tag which in return gives item code size and color of …

February 6, 2018 | Excel 2003 Help, Spreadsheets | 0 Comments

Top 10 sales by customer

Good afternoon. I have a complex formula that I need to build and don’t know where to start with it. i have built an automated front sheet that looks …

January 25, 2018 | Excel 2003 Help, Excel 2007 Help | 0 Comments

Using the text of a cell range (array?) in VLOOKUP or MATCH formula

Hi, Firstly sorry if my Excel lingo is a bit off as I’m self taught in Excel. Okay so my problem is simple, say if I had the letters a,b,c,d,e in the …

January 25, 2018 | Excel 2003 Help, Excel Formulas | 0 Comments

Checkbox Question!

Hi guys, there’s one thing that I wanted to do but couldn’t find any similar case after hours of googling. Here’s the case I have a list of …

January 22, 2018 | Excel 2003 Help, Excel Formulas | 0 Comments

Auto Populate Some Info

Hi, I’m trying to find out if I can input a file name such as “file name_123456_2018_NI” into one cell and have just what is before the first …

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

If statement between times and days

Hi everyone, I’m trying to create a formula for my overtime, as I get a different pay rate at different days and times. Mon – Fri: 17:00 – …

January 5, 2018 | Excel 2003 Help, Formula | 0 Comments

Record Date & Time on cell value change

Dear all Kindly solve one issue.   My requirement is that when user enter some value in a10 cell, & z10 = a10, now if user assigns some value in a10 …

December 26, 2017 | Excel 2003 Help | 0 Comments

Breakdown of shift hours worked

Hey guys, I hope someone can help me with this. I’m trying to create a timetable to monitor my hours and what shift brackets they fall into but …

December 19, 2017 | Excel 2003 Help, Formula | 0 Comments

Excel Formula need to extract the number in a position

Latency:   0   1   0   1   1   0   0 277 290 267 212 214   0 290    …

December 17, 2017 | Excel 2003 Help, Excel Formulas | 0 Comments

Time formula

I’m trying to create a formula for time but having no success.   I’m trying to create a sheet where meal breaks are automaticvally deducted …

December 13, 2017 | Excel 2003 Help | 0 Comments

Adding Hours for Tech Support

I am currently having to track the time all my support members are spending on the phone. We are having them submit a form which then in return is …

December 12, 2017 | Excel 2003 Help, Formula | 0 Comments

how do i search jpgs from an excel sheet?

I have a file of 1000+ jpgs and a list in excel of 300 file names – how do i search and find the 300 images in the bigger file? do i do this via dir …

December 4, 2017 | Excel 2003 Help, Spreadsheets | 0 Comments

Conditional Formatting Excel 2016

I am creating an excel document to help make work easier; I work at a non-profit agency. We have multiple families we serve (over 50). For each family, we must …

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

Count items based on another column

Hello,   I am trying to find an answer to this problem. I can see that there are answers to this on Google but I’m still finding it hard to …

November 27, 2017 | Excel 2003 Help, Formula | 0 Comments

Sum whole Row

Is there  a simpler way to achieve  =((Attendance!$C$3*Attendance!C5))+ …

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

comparing two collumns and inserting collumn when not matched

Comparing 2 collumns from 2 different groups having a empty collumn between the groups , each group containing 4 collumns, inserting the cell in every collumn …

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

results in a pop up when click a cell

Hi. I want to see the results in a pop up when click on a cell. For a example when clicking on a product to calculate the discounts of a certain customer and …

November 24, 2017 | Excel 2003 Help, Excel 2010 Help | 0 Comments

Unique drop down list option for each column

Hey, I am trying to make columns that have one unique option. First check this image: https://i.imgur.com/uxwX57G.png   Like you can see there …

November 16, 2017 | Excel 2003 Help, Formula | 1 Comment

Formulas for burnup/burndown chart

I’m trying to create a burndown and burnup chart for my team. However, I’m a bit confused as to what formulas I should be using with the data I …

November 15, 2017 | Excel 2003 Help, Formula | 0 Comments

Creating a graph simulating severel values for “X”.

Hello, I am using Excel 2007 and having difficulty creating a graph that calculates the value “y” for several “x” values. Here is the …

November 2, 2017 | Excel 2003 Help, Excel 2007 Help | 0 Comments

Matrix and kilometers

Dear reader, The Matrix below shows the distances between different cities in Poland. I have a dataset with courier services where the recipient city and …

November 2, 2017 | Excel 2003 Help, Functions | 0 Comments

top 6 values in a table

Hello, I have a table of values with 7 columns and 3116 row. The table is full of numbers and I would like to find out what are the 10 most recurring numbers …

October 17, 2017 | Excel 2003 Help, Excel Geek | 0 Comments

Excel fomula for “Table Summary”

I have a list of products in my excel sheet1 (A:A contains the product code, B:B contains the color of item) On sheet2, I would like to have a summary table …

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

How do I create alternate colours which do not get effected when I use a filter a-z on them?

Hi, I have used an excel template for my pipeline which has alternate 2x colours rows and that makes it easier to read between rows. I have added filters to …

October 10, 2017 | Excel 2003 Help | 1 Comment

Extending Formula Series

I am using Excel 2016 on Windows.   I wish to extend the following formula indefinitely down through the rows of a column:   =SUM(G7*G8 + H7*H8 + …

October 6, 2017 | Excel 2003 Help, Excel 2010 Help | 0 Comments

Run Module based on cell value

I have a data form with a submit button that submits data into log in excel. If a certain number of tasks haven’t been completed and the time (now) …

October 4, 2017 | Excel 2003 Help | 0 Comments

If a cell has a value, how to subtract first nonblank cell from adjacent column

Hi guys. So I’m going to try to explain this as well as I can, but might fail. I have three columns, let’s day A, B, and C. So I tried to kind of …

September 28, 2017 | Excel 2003 Help, Formula | 1 Comment

SUMIFS function

Hello, I need a formula to sum the values in a range of cells if the content in another range of cells equals the text currently in a cell in a completely …

September 24, 2017 | Excel 2003 Help, Functions | 0 Comments

Military time subtraction issues

I’m having the hardest time getting excel 2013 to get all the things I need rolled into one. I need to enter times in military time and know the …

September 4, 2017 | Excel 2003 Help, Formula | 0 Comments
← Older posts

Topic Groupings

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

All Time Popular Posts

  • Excel Formula Based on Cell Background Colour 113,477 views
  • How to Concatenate in Excel using LEFT, MID and RIGHT String Functions 76,375 views
  • Automatically Run Macro when Cell Changes 57,249 views
  • If Functions 52,026 views
  • IF Formula if Time is Greater than 10am 50,592 views
  • Get File Name with Excel VBA 46,484 views
  • Add Command Button to an Excel Worksheet 44,359 views
  • Calculate VAT in Excel 41,754 views
  • If Function – If False Do Nothing 36,465 views
  • Excel 2003 Color Scheme when Downloading from SAP 35,379 views

Popular Posts Last Seven Days

  • IF Formula if Time is Greater than 10am 353 views
  • How to Concatenate in Excel using LEFT, MID and RIGHT String Functions 241 views
  • Excel Formula Based on Cell Background Colour 178 views
  • Automatically Run Macro when Cell Changes 159 views
  • Get File Name with Excel VBA 142 views
  • Go to Next Blank Row in Excel 104 views
  • Add Command Button to an Excel Worksheet 100 views
  • Enter a Formula to Compute Total Cost 62 views
  • How to Check if an Array is Empty in Excel VBA 54 views
  • Calculate VAT in Excel 53 views

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

  • Excel countif command
  • Generate Alert Dates
  • Vlookup
  • NO VBA ‘OBJECT’ & ‘MODULE’ Folder SHOWING
  • 2 different data on the same chart
© 2014 ExcelGeek. All rights reserved.
Optional footer notes.

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.

Close