**0**

votes

**1**answer

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

**1**answer

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

**3**answers

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

**3**answers

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**0**answers

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

**3**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**3**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**2**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**3**answers

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

**2**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**0**answers

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 ...