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)

0
votes
1answer
11 views

I cannot insert a bar chart in PowerPoint

In rerence to a previous post I too can no longer insert a chart into powerpoint. When I select chart type it allows me to click but then blinks at me and does nothing. My IT guys have looked into ...
0
votes
1answer
20 views

Comparing and Updating multiple excel sheets within a single workbook

I have 4 sheets of names, some of which may exist in one or more of the other sheets. What I need to do is, compare all 4 sheets of names and create a new sheet ( Master List ) of all names from each ...
1
vote
3answers
55 views

Summarize tables of several sheets into one final Table Excel and include new sheets in summary

I have got several excel sheets, every single one of them containing a table for user information and one last sheet which contain the sum of all the previous tables. Since my table is very big, is ...
1
vote
3answers
48 views

How to hyperlink to a location in a cell in Excel?

I have a cell, with a file path written in it. How do I make it that so, when you click that cell, it automatically opens whatever file path is written in it? Ex : if cell A1 contains ...
0
votes
0answers
17 views

Cannot insert more than 4 empty rows in an excel sheet

I currently work on billing for the company that I work for and use excel for this purpose; I use one sheet all month and at the end of the month I sort and separate participants and add an empty line ...
0
votes
0answers
13 views

Radar chart in excel - charting with intended “gap data”

I want to plot a radar chart that has cross-fire axis with text added labels at each axis. The data items to be placed between these axis points eg at 2pm, 4pm, 8pm, 10pm. I am having difficulty ...
0
votes
1answer
28 views

Count appearances of two cells in a 5x100 matrix

I have two cells that I want to compare against a 5 columns by 100 rows matrix where they can appear. I have tried this but doesn't work: ...
0
votes
1answer
46 views

Dynamic array/matrix generating within formula

The following formula: =TRIM(A1:A20) would make no sense; you typically should decide a column, write =TRIM(A1) on first cell and copy until =TRIM(A20) ... BUT ... suppose you want/need to use it ...
0
votes
0answers
35 views

How to convert dd.mm.yy date format in excel 2007 date

Please help me to get excel(2007) date format 'DD-MM-YYYY' for the following non-standard date format. " 01.11.65" having leading space. "'01.11.65" having leading single quote mark. "15.11.50" ...
0
votes
0answers
18 views

Google spreadsheet count words [migrated]

I have spreadsheet: https://docs.google.com/spreadsheets/d/19GrXAFLpv6jz9OzDum-fyfP_m-RZFCNrQ0rr1vd5bYI/edit?usp=sharing I want to count percent of wins(W) in G column and write it to G1 cell. I plan ...
1
vote
3answers
50 views

How can I automatically organize data from a text file in a spreadsheet?

I have a text file like this: and I would like to organize into Excel like this: I could do this by hand manually for two data entries, but I would like to be able to automate this for a larger ...
2
votes
1answer
44 views

Use Excel to match data from a cell on a worksheet, then copy data from its neighboring column and paste on a different worksheet

I have a spreadsheet with multiple names and phone numbers next to them in each Sheet 1 - Sheet 5. Each Sheet has about 900 names on column A and their associated phone numbers next to them on column ...
4
votes
2answers
372 views

How to count if there's a cell with certain restrictions using Vlookup?

I'm finding if there at least one cell with the first character equal to "!" Formula I have used without success: =Vlookup("!";Left(N2:N49;1);1) Why doesn't it work? And what do I have to change ...
-1
votes
1answer
38 views

excel extracting data and concatenating fields? [closed]

I have a large excel sheet which I want to extract some certain fields. Here is an example: Column 1 has a list of countries: Country: USA | UK | India | GER Column 2 has a list of route IDs: ...
0
votes
0answers
32 views

Two-way data update with Excel PowerPivot tables (Office 2013)

Background: We have two excel workbooks: Data and Visual which we are using to track and visualize activities in our project. The Data file is organized like a database: each sheet is a table (which ...
0
votes
1answer
27 views

Pulling data from multiple spreadsheets [closed]

Need to run a report pulling data from 10 time tracking spreadsheets. In column C, if the job type = Artwork, then I need to pull in the data from columns A, B, D & I of the same row. There may be ...
0
votes
1answer
19 views

Format an Excel cell from VB 6.0 with an amount to two decimal places

When using vb 6.0 to make a cell, we cannot force the amount to be shown with 2 places after the decimal if the number does not have end in 1-9. For example 59.12 shows up correctly but if we try ...
1
vote
0answers
31 views

What has caused my csv load time to dramatically increase?

I have a monthly report formatted as a .csv file. It's file size is 90 MB. It used to take around 10 seconds to open. Now it takes 4-5 minutes. When I convert it to an .xlsb, it takes 10 seconds. ...
0
votes
1answer
23 views

Excel 2010, how to summarize counts based on month listed by row

If I have a set of data with a month listed for each row and want to sum various column counts by month listed, how do I do that? For example, I have 10 rows of data, with two rows being "June" and 8 ...
0
votes
0answers
32 views

Make reference in two Excel tables in order to automate a calculation

I have a table in excel. My tables stands several feature values for every month (from 1-44) The tables rows stands for the several features and the table columns for the months. I want to create a ...
0
votes
0answers
22 views

Excel 2013 PivotTable refresh slow when source data file is not open

I have an Excel workbook with ~3800 rows and ~380 columns. In a different workbook I am using a PivotTable which references this monolithic workbook. I am seeing an issue where if the source ...
0
votes
1answer
44 views

Excel Formula - Match

Can someone recommend a way to write a formula that will achieve the following. I can achieve these things individually but stringing together seems to be difficult. I have a list of orders with ...
0
votes
1answer
24 views

In excel how could I generate a row of data from another sheet?

In excel I have a sheet named "sales", and another one named "factor". In factor I have some fields for factor ID, customer name, product code, quantities and price. I want when I add this data to ...
0
votes
0answers
11 views

Excel Consolidate Choice List Data in New Tab

I have a sheet which lists a bunch of people and next to each they can select a choice such as: Barry / Choice 1 Sally / Choice 1 Dave / Choice 2 Lucy / Choice 1 Alex / Choice 2 What I would like ...
1
vote
1answer
21 views

Excel - pivot date values with max function

I am trying to pivot date values in a pivot table in MS Excel. I am getting incorrect date values. I do not want "Grand Total" as they do not apply for dates. Is it possible to do such pivots in ...
0
votes
0answers
41 views

Excel Power Query joining all text files together, need them on separate rows Basic

I am importing many files in to excel. They are text files. Using PowerQuery They have about 40 lines of data in them, all on separate lines. 0945996 G ANDERSON 1405 Saturday 8th etc etc I want ...
0
votes
1answer
39 views

maintaining a constant total of excel cells

I have a column with 3 cells: A1, A2 and A3. I want the numerical total of the 3 cells to remain constant as I increase or decrease any one of the 3 cells. That is to say, I need any increase or ...
1
vote
2answers
29 views

How do I use IF in MS Excel-Mac 2011 for 3 variables?

When I type A, B or 0 in one cell, I want to see in other two cells (separately) to show 2,1 if I type A 1,2 if I type B 0,0 if I type 0 Can someone help me how to do this? I currently only have ...
1
vote
1answer
23 views

Use Conditional Formatting on a Cell Based on matching a value in a range

I want to change the cell background of a cell (M16) if the number in it matches one of the numbers in a table of random numbers (M3:Q12) Table of numbers - M3:Q12 Cell I want to format is M16. ...
0
votes
3answers
43 views

Excel Formula issue

I've been trying to write a formula to help me with rostering. It seems to work if I put the first few parts in, but after that it says "The formula you typed contains an error." Can anyone see the ...
0
votes
1answer
31 views

filter excel list by formula instead of values

If I have a column in excel, with the following formulas, would it be possible to filter it? In this case, the values are all 7, but could I filter by the explicit formula? =2+7 =3+4 =2+7 7 =1+6 7 ...
0
votes
0answers
30 views

Excel 2013 - Not Responding and crashing while stepping through VBA macro- Win7-64 I7 processor

I am getting a consistent problem whereby, while stepping through a macro (or running it) Excel 2013 gives me a NOT RESPONDING message and essentially crashes; i.e.- I have to close the app. This has ...
0
votes
1answer
29 views

Elapsed time between two timestamps

I'm having real trouble converting two timestamps into elapsed time in seconds for example: 07/16/2015 14:01:42:140 07/16/2015 14:01:52:563 I have tried multiple functions and the classic (A3-A2) ...
0
votes
2answers
38 views

How to autofill with every other cell incremented by one

I need a list like 1 | 1 | 2 | 2 | 3 | 3|. I need it to go to 50 just like that, so 100 columns, but only goes to 50. When I type 1 and drag it will bring me 1-50 automatically, but I need it to show ...
1
vote
0answers
17 views

Extract numerical data from MS Word graph [duplicate]

I have a word document that includes chart objects linked to data held in unknown spreadsheets that cannot be accessed. The charts are 'frozen', in the sense that they are displaying the data ...
2
votes
1answer
39 views

How to make a formula-based cell read-only in MS Excel?

I'm trying to create a unique ID for each row in Excel, based on the formula [RowNum + X] (X is given). The formula autocompletes on each new row, based on Excel Tables. After creating the new row, I ...
1
vote
1answer
24 views

Checking column for value. If true, check same row in another column and count if not blank

I have a spreadsheet of employees. Column A is a list of Dept types (sales, HR, payroll, etc). Column B is the date their appraisal is completed, or blank if incomplete. I would like a function that ...
0
votes
1answer
23 views

Converting non-numeric date to individual month,day, year components, and combining into one cell as datevalue

I have a date that Excel does not see as a value, I parsed out the month, day, year components into three separate cells, and converted to values, and now need to combine them in one cell to be seen ...
0
votes
3answers
74 views

How to keep a running balance of payments vs. billings in Excel

I have a row of cells with 12 Monthly columns, G4 (January) through R4 (December), in which I will input the amount paid towards a monthly billing. [Note that an early comment discusses multiple years ...
1
vote
2answers
43 views

How to keep history of data changes in one excel workbook or sheet to another workbook or sheet

good afternoon, I am working on an excel sheet where I have a table of data. This data represents several metrics that my department wants to keep track on. Whenever someone wants to populate the ...
2
votes
1answer
90 views

Is it possible to reference two cells in Excel to find a third cell?

I have a spreadsheet that has a decent amount of data on it. I need to return some of that data to certain cells. The data that I need to return is always near a cell with "Attached Components" in it. ...
0
votes
0answers
12 views

Can empty cells be entered into an array constant in Excel?

I want to enter an array constant in Excel that contains a properly empty (blank) cell. If I just use two row or column separators after each other ({1,,3} or {1;;3}), I get an error message and the ...
0
votes
1answer
30 views

Insert Hyperlink to an IP Address

I can open a browser (Chrome or Firefox or Internet Explorer) and enter an IP address in the Address bar, say: 134.170.185.46 and the browser will open the website (Microsoft.com) directly - ...
2
votes
1answer
22 views

Excel autonumber range

Most of you know about this little feature of Excel, as well as almost any other spreadsheet software like Google Spreadsheets called Autonumbers. Example. What I'd like to know if it's possible to ...
0
votes
1answer
14 views

Column C to list missing items from comparison of Columns A and B

I have column A with 1860 items and Column B with 1650 similar items. How do I in column C list the missing items from column B?
0
votes
0answers
29 views

Graph activity from logs on a timeline

With an input of a large list of timestamps representing some activity occurring over time, I'd like to have a visual graph or representation of frequency (either clusters of thin lines, or a line ...
0
votes
1answer
19 views

Excel highligting

I have been searching for the answer on my own, problem is that I cannot find one similar to my issue. I have 2 columns of data "C" and "D". I am trying to set it up so that if "C" is a greater number ...
1
vote
1answer
23 views

How to get Excel conditional formating to recognize boolean operations

I have constructed a spreadsheet to color code incoming scientific data based on different levels of criteria. My problem is with data coming in as 'less than'. For example, if the data shows ...
0
votes
2answers
35 views

Excel Identifying biggest drop in a number series / on a graph

I have a running total figure in a single column that gradually increases over time but fluctuates along the way. I am trying to identify the largest negative downturn in the series as an absolute ...
1
vote
0answers
37 views

Enter the Date (and Other) Values [closed]

Excel interprets following inputs as a date values: July 15, Jul 15, Jul. 15, 7-15, 7/15. Similarly, Excel accepts time values in several formats: 14:00, 2 pm, 2 p, 2:00 pm. What are all valid input ...