Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. If your question is about programming Excel in VBA then also tag it excel-vba. If it is about an Excel formula or worksheet function, then also tag it worksheet-function.

learn more… | top users | synonyms (2)

-3
votes
2answers
36 views

How to have a value from one Excel sheet propagate to other sheets, while being incremented?

I have an Excel workbook, which has 100 sheets in it, all the sheets are identical apart from A10 in every sheet. In A10 of sheet 1 there is a value 101 which I typed in manually and A10 of all other ...
-5
votes
0answers
26 views

Charting and manually drawing

I have a collection of (x,y) data. I can paste this data to MS excel and see the graph. Is there a way to manually draw straight lines over the chart.
-6
votes
2answers
50 views

How to do simple math in Excel VBA

I have a value in any cell which is greater than 60. For my purpose, I need to subtract 60 from such values until the value is less than 60. So, for example, say I have a cell containing a value of ...
2
votes
2answers
29 views

Microsoft Excel - Sum drop down boxes with text

Good morning everyone. I require some help with my spreadsheet. As you will see by the screenshot below, i have added drop down boxes with text that i pick based on different combinations. I then ...
-1
votes
0answers
14 views

Microsoft Excel transform table data

I have the following table (#1) in Excel which I'm trying to convert to format shown in table 2. I tried pivotting, but I could not get it to work. Table 1 Time User Ref Average 8-Dec ...
1
vote
2answers
22 views

How do I identify duplicate rows in an Excel cell?

I have an excel file with thousands of rows of contact info. I need to get a list of all the rows that have duplicate first and last names. I have been able to use conditional formatting to ...
2
votes
1answer
19 views

How can I filter which colums will be shown on a spreadsheet?

I have filters set up for each column, however I also want to be able to filter which of the columns show. Eg: I have 70 different columns, all with different headings. How can I create a filter that ...
0
votes
2answers
31 views

Excel Data Not Refreshing

I have an EXCEL sheet that is connected to an outside Flatfile. I have the report set to open up and refresh the data automatically. However, the data does not refresh and I still have to manually go ...
0
votes
1answer
23 views

Display prefix units in excel cell

I have a specific cell in my excel sheet that contains a value from 0-100 (The value can be changed by the user). Whose value is used in some formulas at different places in the sheet. I would like ...
-4
votes
1answer
38 views

Formula to find the upper case in the sentence as true [on hold]

i have one worksheet which has a sentence in-between uppercase words, i want to know which cells has a uppercase word in the sentence. Please someone help me out with the right formula to find. I ...
1
vote
1answer
36 views

Assistance with Excel macros

My company uses Excel to track inspections and maintenance of portable fire extinguishers and I'm trying to add some functionality to it but don't have the first clue about how to do it. I'll do my ...
1
vote
1answer
25 views

VBA code to change the selection of a drop down list (combo box)?

I ran the macro recorder and changed the selection of a drop down list that is formatted with data validation, and nothing was recorded. Does this mean that there is no way in VBA to change the ...
0
votes
1answer
11 views

match product and copy a row range to Sheet 2

I have 2 Sheets. In Sheet1 I have a list of products (400) in column A. In colums B to M is the space for the names of 10 different owners, but each product could have any number of owners in one of ...
-1
votes
0answers
16 views

query about excel joining data on sheets

just wondering if its possible to link cells in excel, say i have in column A 1,1,1,2,2,2,3,3,3,5 all below each other and in column B a range of names matched to the numbers. Then in a second sheet ...
-6
votes
1answer
25 views

Deleting some cells in Excel 2013

I have 30,000 contacts on my excel sheet and some have not included their emails. I am a beginner at excel, and would like to know how to delete all cells without emails as well as the corresponding ...
1
vote
1answer
30 views

Excel Copy Formulas Horizontally

On Row 1, Column A I have =Sheet!1K2, on Column B I have =Sheet!1K3, Column C =Sheet!1K3 and so on. On Row 2, Column A I Have =Sheet!1L2, on Column B I have =Sheet!1L3, Column C =Sheet!1L3 and so on. ...
0
votes
2answers
31 views

How to find time difference between two rows of one column in excel sheet?

I have an excel sheet containing the Entry and Exit time for users from bio metric software. I want to find how much time the user had stayed i.e. sum of difference between entry and exit times, but ...
1
vote
1answer
43 views

IF formula incorporating sequential answers

I am trying to write an IF-THEN formula that outputs sequential numbers (See the example at the bottom). If you need further clarification on the process, just let me know. Here is what I am trying to ...
0
votes
1answer
20 views

Copy Full worksheet including multiple defined range names using macro or VBA

I've been trying to build a workbook for my company to use to track sales. The problem I'm running into is that I want each user to have their own workbook saved on their local computer for their ...
-2
votes
0answers
35 views

Excel 2010 formula?

cell L26 being a date of 12/15/14 cell K26 = Y or N cell J26 = Y or Y Still not working. Here is what I am trying to accomplish. in looking at 3 cells, the 1st condition that must be met is ...
0
votes
2answers
37 views

Obscure DateTime Format

I have a document with dates of the form 2014-05-14T9:15:20. Unfortunately, Excel does not recognize this DateTime format. Is there a way to tell Excel to read this as a DateTime format without ...
0
votes
2answers
28 views

Numbering Identical Items in A Column

Suppose I have multiple, repeating names as follows: John John John John John Tom Tom Tom Tom Tom Tom Anna Anna Anna Anna Anna Anna I would like to find a way to tell Excel: while the name is ...
0
votes
0answers
24 views

Email Macro Assistance [on hold]

I am not experienced in writing VBA Macros & need assistance to create the following Macro. What I am working with is 25 rows of data in Excel where I need a macro written. The request is that the ...
0
votes
1answer
45 views

How to find number rise within 1 hour in Excell?

I have numbers logged over the period of time. In one column, lets call it A there is a time in seconds from 0 to 10000, in the column B temperature logged accordingly to the time. Temperature usually ...
0
votes
1answer
33 views

How do I create a table with multiple header rows

How can I create a table in Excel that has two or more headers rows. I want to keep the range as a table so I can use the built in tools such as re-sizing, totaling, formatting, etc... I saw a ...
1
vote
1answer
23 views

Referencing cell in workbook with variable name

I have a spreadsheet with a macro that creates a copy of a worksheet and names it with the current date. name of new worksheet is captured in first worksheet. How can I reference a cell in the second ...
0
votes
1answer
30 views

Excel-function IF

Column C calculates the earliest date from column A and B. What would be the shortest function to display Row A1 or A2 in Column D as per the value of Column C? Overhaul 1 Overhaul 2 Earliest due ...
0
votes
2answers
40 views

How can I automatically fill a series in excel, based on the value of another cell?

How do I automatically change the length of a column with the numbers 0-n, where n = a number in a certain field? I'm thinking of something like this: EDIT: Seems like I was bad at explaining ...
0
votes
1answer
22 views

Excel formula for extracting numeric input

I have a column that contains a number starting 2007***. Counting down it changes. I was wondering if there is a formula to take out the number and show it in as a separate column. Cell ...
1
vote
1answer
21 views

How do I copy rows based on single cell value in Google Sheets?

I have two sheets in Excel, which is duplicated on Google Sheets. Sheet 1 is a list of names with various bits of information for example Name Number Outcome Colin Smith ...
1
vote
0answers
19 views

How to use Excel 2010 VBA to set series line color, marker fill, and marker line color

I am trying to write an Excel 2010 VBA subroutine to format charts according to a predefined (i.e., defined by me) standard. The particular attributes that I want to be able to set are merely the ...
0
votes
0answers
19 views

Excel chart tooltip does not display the value for data formatted with triple semicolon

I have two columns labelled Distance and Time. Column E is Distance. Column E is formatted General. Column F is Time. Column F is formatted ;;;. This format effectively makes the cells appear ...
1
vote
0answers
17 views

how to plot on 2 axis with 3 data sets

I have a graph about tracking investment value. It has 2 Y axis scales. First data set displays fine (left Y axis scale) Second data set displays fine (right Y axis scale) However when I try to ...
-2
votes
1answer
24 views

How to find address of last used cell in row for use in formula

I have a row of values in a range and need to subtract the value in the last cell in the row from the value of the first cell of the row. The challenge is that the last cell location is unknown, so ...
1
vote
0answers
21 views

Calculated Fields Reference Error (#NAME?) on Pivot Table Refresh

I'm helping a colleague fix a spreadsheet with a similar issue as stated in this ozgrid post. The problem: Pivot table with 31 calculated fields. Some calculated fields are calculations of the source ...
-3
votes
2answers
42 views

How do I get Excel to look up customer names from another sheet?

I have two sheets in Excel i.e. sheet1 and sheet2. In sheet1's column A there are account numbers of the customer and in column B there are names of the customers. Now I want that in column A of ...
1
vote
2answers
29 views

How can I compare two linked columns from one table with other two linked columns in another table? [on hold]

I need some help on getting the proper formula for validating the following. We have Customer list with Customer name, Customer number registered in our system, Customer number in another billing ...
0
votes
0answers
13 views

Accessing locally stored external data

I have an excel file that has an external connection in it to a SQL server DB. The external data from the last refresh is stored in Excel somewhere as i can create new pivot tables from that data set ...
3
votes
1answer
129 views

How to automatically colour cell background with value selected from custom dropdown list in MS Excel 2010

In MS Excel 2010 Professional is there a way to automatically copy the background colour of the custom dropdown values from somewhere else in a spreadsheet? I have some Data Validation on a row of ...
1
vote
1answer
14 views

Excel Stuck in Developer 'Design Mode'

We have a set of spreadsheets that contain scrollbars added in developer mode. Clicking these scrollbars changes a value and a diagram in the spreadsheet. Suddenly these do not work. The mouse cursor ...
-2
votes
0answers
13 views

macro to collect data from number of sheets to main page and need to add the sheet name that where the data collected

Please help me..,I need a macro to collect data(Student names) form number of Sheets(Class Name).all student names collected from sheet1, then a new column added with the sheet name (i mean ...
0
votes
0answers
27 views

How can i convert .xls to .csv when change is made on csv file automatically? [closed]

How can i batch convert A.Xls to A.Csv When change is made in A.xls, for example when add 1 record in to A.xls Thanks
1
vote
3answers
90 views

How to split numbers into columns with negative and positive values, without empty cells?

Given positive and negative values in column A of an Excel sheet, I want column B to list the positive values from column A, and column C to show the negative values, in the order in which they appear ...
-2
votes
0answers
28 views

please make excel sheet [closed]

Suppose you have two Excel Sheets as follows and it’s more than 1000 rows and you cannot do manually: Sheet 1, Available List: Area tower Br# Siza Rent Sale Height ...
0
votes
1answer
21 views

Corrupted XLSX File

So, i was copying some files after work from one partition to another. I then accidentally deleted both partitions due to being really tired. I managed to get my files back using recovery software. ...
0
votes
2answers
27 views

Calculating column values based on positive/negative values of another column in Excel

If I am typing randomly positive and negative values in column A in Excel sheet then I want when I type any positive value in column A then counting should start in column B and if I type any negative ...
0
votes
0answers
18 views

Using Chart BeforeDoubleClick with a chart object in worksheet

I am trying to get a macro to work on a chart in a worksheet using the Chart.BeforeDoubleClick event. I have been able to use BeforeDoubleClick event (without the use of class modules) in a ...
-4
votes
0answers
34 views

Still trying to find a solution [duplicate]

I need to create an Excel spreadsheet for my sales quotes. On one Tab, I want to list all of the possible services the customer could buy from me. I would simply click a box or enter a Quantitiy ...
4
votes
4answers
153 views

Comparing the first part of a string in Excel

I'm trying to create an automated function that will determine the class identification for IP addresses after you input it into Column A's input section by checking the first section of the address. ...
1
vote
3answers
227 views

Can't click on ActiveX control in Excel 2010 Standard

I have a .xlsm file that has ActiveX control button with a module macro assigned to it. Problem is I can't click the ActiveX button from my Excel 2010 Standard. I tried to repair and reinstall Excel ...