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 …
Agent
Hello, I am a beginner in excel. I need some help on data validation formula. Due to character limitation, I am not able to add two more IF clause …
Combining lookup with matrix
Hi all, I’m looking for a solution to my excel problem. I’m not sure whether this can be done by using formulas solely, I hope it can be …
Calculate expression in another cell
Hello! I have in COL 1 many rows containing simple expressions (addition, substraction, multiplication and division with brackets) and I need to show the …
Multiple IF functions in one formula
Making a usage spreadsheet for Housekeeping. Multiple units with different bedding and towel totals. I have each column separated by what the unit has …
Check multiple cells to show the one with a result
Hello, I need help with a formula. There are 4 cells, only one will show a result at a time, I need a formula that will check the 4 cells and return as …
Excel WhatIf formula help
Hello, I am looking to set up a spreadsheet that will allow me to calculate the number of parts to be order for various models of motorcycles. Some of the …
Copying & pasting data from same rows in multiple tabs to different worksheet
So I was recently tasked to take over an ongoing report by a former coworker. The report is an Excel workbook that consists of 100 different tabs with …
I need an alternative VLookup
Hi All, I’m attempting to make a spreadsheet for a school at the moment. On one tab I have the Reciepe and Ingredients i.e. – Cottage …
Sum of different columns with a multiplying based on condition
Hello, I need to sum different columns to calculate a share ratio. When i use “SUMIFS” i can calculate the potentials for A and …
How to get formula for MLM system bonus based on level and downline?
you could see my excel example for calculate the bonus from each downline below their level.and tell me how to get the value automatically because it …
Challenging Question bugging me to death
Hi Everyone I was wodnering if anyone could kindly help please. I may go on a little bit but please bare with me. I am stuck on how to calculate this …
How to sum multiple rows and columns
Please see data example below. In the input sheet, I need a formula that would give me the result for ABC’s Session 1, for January 2017. Then for …
Sorting Extensive Dates and Times
Everyday I pull up a report indicating when someone took a course for my work. Instead of pulling up in chronological order, the report shows the Day of the …
HELP / Macro
Hi im new to excel, cut a long story short i want to make to make a button so that every time i click it, it makes a shape, in this case the shape is a simple …
IF and OR – using OR to provide a rule avoiding #DIV/0
Dear group below is a table that i’m trying to create a table for. its looking at dependancy ratio’s and giving a weighted score, but i have the …
Formula to select first and last values in multiple groups
Hi! I have two columns of data, the first is a group number, the second is a numerical value. Each group has a different number of values in it. (See …
Excel Formula Assistance
I’m having trouble writing a formula for my excel file. I want the excel to read the Quantity for each model and instead of keeping them separate it …
Populate a sheet with info on another sheet based on certain values.
Hello everyone, First of all I am not even close to a good at excel, so I was thinking maybe you can help me. I have a workseet that has 2 …
Cell Formula
Hello, I am making a budget and need to make this formula: =”Variance “&YEAR(A1-300)&”a vs. “&YEAR(A1)&”b” …
formula with text concatenation
I can use the following formula to get a cell value from another excel workbook =’N:GroupNYcurrent[tradingbook.xlsm]summary’!$P$10 Now I try to use …
formula with text concatenation
I can use the following formula to get a cell value from another excel workbook =’N:GroupNYcurrent[tradingbook.xlsm]summary’!$P$10 Now I try to use …
Count With Criteria
Hi, Please how to I count the number of yes in coloumn are the match dog or car in column b? By:
Counting cells
Hey, I have this data set which includes phone numbers, length of time of call and date of call. So I want to see how many calls did it take before the …
How to count days but only if data is present
Hi I’ve created a spreadsheet that’s populated on a day-to-day basis with details of various projects as they’re received. I want a cell to …
Calculating the longest duration over which a value remained peaked in a column
Hi, A column ‘V’ has data from a process and the value peaks to around 6.0 at multiple times. The time corresponding to each data point is captured …
Which formula should I use?
I’m working with about 4,000 names and zip codes of local volunteers on our registry. I need to sort them into specific jurisdictions based on their zip …
interval calculation across several sheet over a range of cells help!!
Hi I currently have a workbook with 3 different sheets which I need to tally up info from. I currently have the sheet self calculating if there is …
VLOOKUP & IF OR MATCH/INDEX
Hello, I’m trying to configure a solar pump system sizing sheet. Basically, after calculating several criteria, a solar pump model should be …
Excel If and AND Functions
Hello, Please could you help. i need a formula for IF Column B had data in and Column J is Empty then do this …
SUMPRODUCT Question
I’m trying to use a SUMPRODUCT formula to add multiple rows together based off a couple different criteria. When I do it for just one row I can get it to …
Automatically bring data from different tab
I want to automatiacally bring data from different tab within same worksheet. I have a summary tab, that will show summary of many detailed tabs. I want …
IT support
HI Came across this web and I have an excel problem =COUNTIFS(B4:B6,”>10″,B4:B6,”<=13″) works …
Help with ISERROR
Hi I am trying to add the ISERROR to the below formula. I am calculating between dates to return a value or sum the amount of months in between …
EXCEL HELP NEEDED
Hi I have two worksheets. One listing all days against a individual contract e.g. Contracts Days 1234 …
Excel Formula
Hello Everyone I want to ask a question relating excel 2013. I have 2 columns A and B respectively.Now my question is that suppose there are 2 vaues. In column …
Formula question
Hello, I hope you can help. I am trying to find one cell in a column and then find another cell in the same column and then sum what is between the …