## Copy formula down automatically

I have a simple chart with sales numbers in 3 columns. Actual, Target and difference. The target amount is consistent and the formula for the difference …

I have a simple chart with sales numbers in 3 columns. Actual, Target and difference. The target amount is consistent and the formula for the difference …

I need an excel function/formula to say that completing 1 task (whatever it may be) will be equal to this amount of time. So I need a function to say …

I am using AJPiUserformDrawng (UFDrawer.xla) to allow line draw functions on user forms. My need is to be able to draw various size hyperbola like curves that …

I have a spreadsheet where I want one cell to populate itself with a single digit number value if I place an “X” in a box in the same row of the …

Dear Excelgeek, I am trying to create a spreadsheet that allows me to calculate an average for how long it takes someone to qualify in a specific role. I am …

I have 5 columns of words that i would like to put in another set of 3 columns based on this criteria. For column 1 of the 3 if the text appears in any of the …

I want my excel function to do the following actions on the below attached spreadsheet image: Search for SumA in Column B Every time the system finds SumA, …

I am looking to break down the following formula into a simpler function with the same effect, so it won’t take ages to enter it: …

Im using Excel 2010 for MAC. I have a stacked bar chart. The horizontal (value) axis consists of dates. They are in date format in the spreadsheet. On the …

I have a list of data, exported to excel, which has ‘TRUE’ or ‘FALSE’ in a column, based on if they checked a box on a previous form. …

I am trying to create a hyperlink in a word document using excel vba. i am currently using excel vba to populate bookmarks in a word document with …

DATA I have on SHEET 1-4 The different sheets are based upon the product and then broken out by deparment …

Uaing MS365 Excel, I have two lists, one 15,000 rows of a customer base. Another spreadsheet of 1000 rows of ENROLLED customers into a certain program. …

Dear Is it possible that on excel sheet when we write in any cell of column c , automatically in the same cell of Column A Current time …

Hello, Thank you for taking my questions! I have dates in column E and 0 or 1’s in column G. When an E cell gets to the current date, I would …

I have a workbook with 15 sheets for different business lines. This workbook is a template with multiple empty rows on each sheet. I would like to consolidate …

The following Macro works fine, except when I email the file it won’t attach the pictures only a link error. If I cut and paste them it …

I am trying to form and IF statement, where if the value is blank, i would like it to return text that says “Not Final”. If there is a date in the …

When doing my school work the problems usually give me sets of data that i have to enter into excel. For example it will be : 360, 29, 61, 171, 36, 284, -45, …

Hi I have the following situation whereby i have a list that includes duplicate customer codes but have different contract start dates and end dates. I need an …

I have a discrepancy report that I ran a pivot table on. In the pivot, I have 2 row labels (Name and Year) and 1 value (# of discrepancies). So the …

3 Range : Time, Value A, Value B Triger : “>=7” condition : between A and B, who reach 7 first in period of time 1 to 6, then win. …

Im in a production enviornment. Some months there is a plan to do no production but units do end up being produced. Below you can see a basic percent formula …

Hi hope one brilliant person out there knows this (if it is possible), can I set excel up so I can type a word in one cell(carpet name), and it puts a …

Hi, I want to compare a cell value witha range of cells in another column and return 0 if it finds match in any of the cells in other column otherwise …

I am very new at excel, might as well start that off. I am taking it upon myself to make a better workplace by making a KPI (Key Performance Indicator). My …

there are many answers on how to get 2 values in a single cell but i want to punch in 2 different input values may be separated with commas and require its …

Hi There, Need a help. I am trying to create a ticket tracker. For that I need the current date and time when clicking on a text box. I tried the mentioned …

Is it possible to use excel macro to send data between computer using internet connection? By:

i want to include search in by excel….like i will type the name and its should give me all the details of that particular function ex salary telephone …

Hello Guys, Need your help please. I am using excel office 2007. I need assistance on the following formula If the Sum of A1:A3 is more than 10 and less …

Here is a deal where you can enter to win an Apple Watch. This is mosting likely to be the base version one they hand out, the Apple WatchSport with a worth of …

Hello! This is a really complicated question to ask, but I’ll try to be as clear as possible. ðŸ™‚ I would like your advice on how I would be able to …

Hi, I am looking for a solution for following problem, and can’t solve it at this time: In one sheet I have my product order sheet. Column A is …

Looking for the function to state the cell reference of a given value in a worksheet (array). Value “2” ,located in A1, and located in …

Previously when i used to import data from my office software into excel the date format use to be in dd/mm/yyyy 00:00 (05/06/2015 00:00)but i had to format my …

Hello! I have a system with up to 60 workbooks containing several worksheets. And then I have a master workbook which I need to update with data from the other …

I have an excel sheet with a column of dropdowns for different values. If the value is “apples” I want it to multiply the value by 4%. if there is …

Hello, I need to combine multiple workbooks into 1 spreadsheet with multiple tabs where the new tab names = the name of the workbook. I also need …

Hey guys, Need some help with a scenario situation in excel. I’ll try to give an easy example below. The first 3 lines are a simplified cashflow. I …

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.