I am unable to find how to get information pasted in cells after 5 minutes from Another worksheet.
I have a data sheet which updates information every 5 minutes and i have another worksheet that calculates the data. Now i want the data refreshed every 5 m ...
Read More
 
Hi there,
I am trying to change the formatting (color) of a number of cells in an array (4 cells in a row) given a value that I am going to input in 1 of those cells. This input will be compared to an array of values already input. So depending on the ...
Read More
 
Hi, I am trying to set up a meal planner on excel. I have created 4 worksheets planner, shopping list, recipe, smoothie. I have drop down menus on my planner for meals, so on a Monday for breakfast I have a drop down menu and click smoothie which links ...
Read More
 
I am trying to establish a connection between an Excel file to an Excel file located on a SharePoint site in a folder. I select the "Get Data From Web option":
I enter the SharePoint site URL on which the file resides and am given the following error:
I ...
Read More
 
I have 4 comparison with 4 unknowns.
is there a function in Excel that I can use for this?
Read More
 
When I try to import an excel file, I get the below error,
"The wizard is unable to access information in the file '<file_path>.xls. Please check that the file exists and is in the correct format."
When I open that file in excel and just save without a ...
Read More
 
Hi all,
I'm a bit of a novice when it comes to excel formulas, so any assistance I can get on the below would be amazing!
I need a formula that does the following:
 On 1 sheet I have a table of numbers
 The column headings contain a 3digit job nu
...
Read More
 
Let me apologize in advance if i have a hard time explaining this. I'm not even sure if excel can do this. I have a spreadsheet where i want to be able to sum up Overtime Hours and Comp hours in the same row. What i would like to do isL: for overtime pu ...
Read More
 
Me again .. (almost think I'm new to excel ! )
Here's what I want to do:
if K7 is less than 3 enter 112.5, if K7 is between 39 enter 150, if K7 is greater than 10 enter 187.50
here's the formula I have but I've got something wrong ..
=IF(K7,">3",112.5)*O ...
Read More
 
I am trying to create a IF statement that will work for the following situation:
I currently have the sheet set up to calculate dates based upon previous data input. Column G will calculate a date of column A + 45 days. However, if column H has a date ...
Read More
 
Hi,
I have what is probably a basic question but I'm having a moment and can't figure it out!
I want to do a simple sum formula but exclude one column only if it contains a percentage. Sometimes it will contain a number, which I want the formula to the ...
Read More
 
Hi.
I need a formula that helps me list supplier name situated in column C under column F against codes listed in column A. I am attaching a "Test" excel sheet of what the final result needs to look like (result marked in orange).
Example:
Supplier ...
Read More
 
Hello,
I have a ton of data about our production over the last 2 years. The data is contains all the produciton jobs we ran over the past two years. For every job it shows its production route. My goal is to find out what the main production routes were ...
Read More
 
Hello, I have a workbook with 4 different worksheets (4 different tables). I would like to be able to create an extra worksheets that incorporates all 4 tables into one and that is reactive to changes in either of the 4 initial tables.
Thank you!
Read More
 
Hi. I'm a complete beginner to Excel and need some help please. I'm doing a spreadsheet comparing prices from different companies for hundreds of products so I'll have about 10 columns and up to 1000 rows. I want the cheapest price in each row to be highli...
Read More
 
I have used Excel for many years, but have exhausted my knowledge on this one.
The worksheet that I am trying to fix is labeled "100.01". On "100.01" the first 55 instances are pulled from "General Ledger" but not the 56th.
The same error occurs on ev ...
Read More
 
Here's the Scenarios,
If any row in the first column of PivotTable1 equals any row in the first column of PivotTable2, then perform this formula (PivoTable1 Second column/ PivotTable2 Second column) for each row
I need to compare names between eac ...
Read More
 
I have a 15 digit number. All the numbers have to remain the same except for the 10th digit and the last digit. The 10th digit needs to go up 1 and the last digit needs to go up 7. If the last digit starts at a 7 and adding 7 makes it 14, the 1 in the 14 ...
Read More
 
Hi,
In column A of workbook 1 I have a number of customer ref codes. I want to do a vlookup of these codes into workbook 2 to return the orders associated with these codes (located in column D). I want these orders returned to column P of workbook 1.
...
Read More
 
Hello,
If I had time to take a course in Excel, I would. I just need to know the formula for a Balance Column.
All of the formulas I have tried work for one row, but I cannot get them to work for the following rows, without typing them in for each cell. C ...
Read More
 
I have an attendance tracker that has a YTD summary sheet and a sheet for each quarter. I have used a COUNTIF function on each of the quarter sheets =COUNTIF($E6:$CQ6, ">0") that totals the number of cells that have any entry in them.
I want to have a c ...
Read More
 
Here is the formula I'm working on
F1=SUMIFS(C:C,A:A,E1,B:B,'sheet1:sheet2'!A1)

A 
B 
C 
D 
E 
F 
1 
Jan 
Mary 
100 

Jan 
90 
2 
Jun 
Susan 
300 

Feb 

3 
Jan 
Peter 
50 

Mar 

4 
May 
Richard 
80 

Apr 

5 
Jan 
Evan 
40 

May 

sheet1!A1=Peter
sheet2! ...
Read More
 
Hi all,
I've been attempting to create a formula to help me streamline a process for what feels like forever.
I want to search for text (from a list of texts) within a cell, and then if that text exists, return that text. The list of texts is approx ...
Read More
 
Dear All,
Sheet 1 summarises Values listed in Sheet 2.
Sheet 1 has categories listed in Column A , and a formula in Column B
Sheet 2 contains a list of expenses that I want add up in Sheet 1, by using the Row numbers in Sheet 1 as a reference, rather th ...
Read More
 
Hi,
Within a spreadsheet i have created a REF TAB where I have created many lists:
 months of the year (jan, feb, mar etc)
 Manager name (jon, bill, fred etc)
 Risk impacts (revenue, lost of service, technical dept etc).
 .....
Using "Name manager" I have ...
Read More
 
Hi there,
I am trying to change the formatting (color) of a number of cells in an array (4 cells in a row) given a value that I am going to input in 1 of those cells. This input will be compared to an array of values already input. So depending on the