**2**

votes

**2**answers

36 views

### Fill a large range with a formula in Excel, without mouse-dragging to extend

I have 5000 elements in column A and 5000 in column B
I want the element wise difference and stored in column C.
The subtraction command I know is =A1-B1 then drag all the way down with a mouse.
...

**0**

votes

**0**answers

14 views

### Why is Excel hidden on the taskbar?

We have updated 6 machines to Windows 10 over the weekend and one of them has an issue that I hoped would go away with the upgrade but it has not. And of course it's the boss's computer.
When he ...

**1**

vote

**2**answers

17 views

### Bound together cells in Excel

My problem is very simple. Suppose I have the following table:
and this one:
Is there an automatic way to obtain the following without using a sequence of nested IF?

**0**

votes

**1**answer

70 views

### Excel does not update formulas values after filling source cells with values

I do 3 steps:
Based on a template, I create a new Excel file through code (it works fine):
Shared Sub FillExcel()
Dim extension As String = ".xlsx"
Dim sourcePath As String = "c:\Temp\libro" & ...

**1**

vote

**1**answer

37 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

**2**answers

20 views

### Reference cell's formula rather than the value in Excel?

Let's say in A1 I have "=ROW()". The cell shows '1' since it's the first row.
Now in A2, I want Excel to reference the formula of A1, not the value. So A2 should say '2'. Obviously "=A1" won't work ...

**5**

votes

**6**answers

16k views

### How can I convert a hex number to a decimal number in Excel?

I have a cell containing this value:
0x00006cd2c0306953
and I want to convert it to a number.
I tried:
=HEX2DEC(C8)
where C8 is the cell containing my hex value.
I get a #NUM error.
What am I ...

**-1**

votes

**0**answers

15 views

### Excel if at least one is true

If cell A16 is true, and at least one of the cells from the range A17:A22 is also true, then check if the at least one words in the list of words in Sheet5!A1:A6 in present in cell A7, if at least one ...

**3**

votes

**2**answers

4k views

### Excel chart won't update, based on calculated cells

I have an Excel document (2007) with a chart (Clustered Column) that gets its Data Series from cells containing calculated values
The calculated values never change directly, but only as a result of ...

**0**

votes

**0**answers

11 views

### Assigning values to rows based on keywords

My bank statement has a description column which tells me where I spent the money or where I got it from. Based on this information I fill a column manually to be able to catagroize these expenses - ...

**2**

votes

**1**answer

3k views

### How to preserve a data cell's bold/italics in a linked text box

Suppose I have this formatted text in cell A7 of worksheet "myworksheet":
My bold and italic text.
I can get "My bold and italic text" to show up in a text box in a chart by setting the formula ...

**1**

vote

**1**answer

20 views

### Excel show drop-down list based on the value of the cell

Here,
I have a list of red coloured fruits, and a list below it, of yellow coloured fruits, as you can see.
Here, I have two drop-down lists used to select colours and fruits.
When selecting "Red", ...

**1**

vote

**4**answers

30k views

### Excel or PPT: How to have two pie charts, but one legend

I would like to design a slide that shows two pie charts of the same size side-by-side, but with a single legend that is centered on the page beneath both charts. I can easily create one of the pies ...

**1**

vote

**2**answers

1k views

### Calc - How to combine rows from multiple sheets into 1 main sheet

I have several statements separating my various bank accounts in Calc, they all use the same columns and have a Date column which I sort them by.
I want to create a 'Overview' sheet which contains ...

**0**

votes

**1**answer

23 views

### Adding value of rows if column A and B cells are similar in Excel

I have a situation. I have three columns
| A | B | C |
|Category | Sub | Price |
Column A is basically Category column, column B is Sub Category and "C" is price.
I need to add the ...

**0**

votes

**1**answer

3k views

### Sort doesn't work properly for cells with references to other cells

I have two tables in Excel 2010, the second table has the last column filled with cells that reference the last column cells from the first table:
For instance, the value of the first cell in the ...

**-2**

votes

**2**answers

55 views

### Excel show list based on cell value

Basically, I wanna do something like this :
=IF(B1="APPLES","Show First List",IF(B1="ORANGES","Show Second List"))
But I'm not sure how to make a proper formula.

**0**

votes

**1**answer

19 views

### Select the column down to the first blank row in the adjacent column? [duplicate]

In Excel 2010 I have several columns with data. I insert a column, and type a formula in the top cell of that column. I want to fill the formula into the remainder of the column, down to the same ...

**1**

vote

**1**answer

18 views

### How to determine largest individual value in excel in a group of identical cells?

I am trying to figure out Column D Which SKU has highest total? how do I do that in excel with a formula? In this case I determined it manually, I tried IF=IF(A2=A3,IF(C2>C3,"Largest","NOT Largest")) ...

**0**

votes

**0**answers

8 views

### Connect to PostgreSQL database from Excel 2013 Power Query with Npgsql

I want to pull data from a PostgreSQL database on my local network with Power Query. By default my version of Excel lists three options under the "Get External Data/From Database" menu on the Power ...

**0**

votes

**1**answer

20 views

### Excel formula to show multiple cell address or row locations?

I'm using the following formula, which returns a numeric value:
=SUMPRODUCT((A3:A176="Thing1")*(B3:B176="Thing2")*(C3:C176="Thing3")*(U3:U176="No"))
However, I'd like to also know the cell address ...

**3**

votes

**2**answers

15 views

### Limit Excel Macro Usage to Certain Users

I want my Excel macros to activate for certain users recognized by Windows Excel. How do I do that?

**0**

votes

**1**answer

19 views

### Subtracting time formats in excel

I want to calculate the difference between hours. I tried using the formula mentioned above which uses ABS function with TEXT function and IF function, but that didn't work. I also tried activating ...

**0**

votes

**1**answer

3k views

### Nesting multiple IFERRORS with Index and Match

I feel like a dummy. I basically need a column that says - If column a2=0 then index and match column C, if that returns an error index and match column e, else index and match column a
Current ...

**0**

votes

**2**answers

4k views

### Plotting quarterly and monthly data in Excel

I have one monthly data series in one spreadsheet and one quarterly in a different spreadsheet. What is the "smartest" way to plot them together in one graph (in Excel)? Its quite a lot of data, so I ...

**1**

vote

**1**answer

26 views

### Count how many fall within a time range based on specific text

I am trying to produce a formula that counts how many times and individual registers a time between a certain time range. The table below is part of the data. So, for example, I need a formula to ...

**0**

votes

**1**answer

34 views

### Extract text between emails with < >

Original link
Extracting Data Between two Characters in Excel
I have a combination of cells where some have nicknames and some without nicknames.
Some will have nickname < > emails and same will ...

**0**

votes

**2**answers

34 views

### If Difference Higher or Lower than Display

I need a excel formula that will show:
* "1" if B is less than A by more than 2
* "0" if B is within 2 of A
* "-1" if B is higher than A by more than 2
Can someone please tell me whether this is ...

**2**

votes

**2**answers

32 views

### IF statement formula for overdue DVD rentals

I am creating a spreadsheet for my local parish church to keep track of borrowed DVDs:
The DVDs have to be returned 14 days after they are borrowed. If the current date is over 14 days after the ...

**1**

vote

**2**answers

652 views

### Get Excel to use column of numbers as labels (equally-spaced on x-axis) instead of as x values (x-axis co-ordinates)

It could be an easy question but I can't find a proper way to accomplish my task.
I have a simple graph and all I want is to show the X values I wrote in the first column at the bottom of the graph ...

**1**

vote

**2**answers

1k views

### Set the primary maximum and minimum Y-values equal to the corresponding secondary Y-values on a graph in Excel?

Is there a way to set the scale on a chart so that the primary maximum and minimum Y-values equal the same values on the secondary Y axis as well?
Basically I have a number of different stocks I'm ...

**0**

votes

**1**answer

23 views

### Calculate time difference in percentage

I'm trying to make some statistical data on the performance of a specific task.
One of the data points gathered is how long time it took to run. I'd then like to compare that against the expected ...

**0**

votes

**2**answers

17 views

### If/Then (# to Text) With Multiple Number Ranges

I am using Excel and trying to create a formula. Part of the formula works, the next doesn't. I'll explain.
Column P is "BPM" (Beats Per Minute) and will have a numeric value, which will be entered ...

**-2**

votes

**0**answers

14 views

### Automatically synchronise two excel spreadsheets

I'm trying to connect two separate excel spreadsheets and automatically update the data from the second one from the first one. which already comes to me with the new data monthly, and I have to ...

**5**

votes

**2**answers

53 views

### How to split a CSV file into multiple files based on a text string?

I have multiple text files (CSV) with a structure similar to this:
funkiana,23.55,-99.866
funkiana,24.634,-98.701
funkiana,24.717,-98.901
geminiflora,22.25,-104.6166667
...

**1**

vote

**2**answers

4k views

### MS Excel: Can I link images using a relative path?

I am working on an MS Excel document that contains a lot of (around 200) images. They are currently saved within the document, so the file becomes huge and working gets very slow.
Linking the ...

**0**

votes

**0**answers

19 views

### Documenting Excel Spreadsheets

I am managing a fairly large Excel workbook with about a dozen worksheets, several
macros, and 100+ columns total. Are there any best practices when it comes to
documenting Excel spreadsheets?

**1**

vote

**1**answer

25 views

### Referenced cell containing date-time showing up as a number in Excel

I am pulling values from one sheet to another. Sheet 1 has ticket ID and Sheet 2 has various values associated with ticket ID. I am finding the matching ticket ID on Sheet 2 and pulling the multiple ...

**0**

votes

**1**answer

5k views

### How to customize Paste Value Excel Short Cut

I was reading in this other post how to set up VBA code to paste values in Excel. I understand how to create the VBA code.
I would like to set the keyboard shortcut to Ctrl d but Excel pops up an ...

**2**

votes

**4**answers

34k views

### Extracting Data Between two Characters in Excel

I have the following format in Excel and I am trying to extract the data between the characters:
First Last <flastname@xxxx.com>
I need to extract the email address between < and > into ...

**0**

votes

**1**answer

67 views

### How to return all the cells in a row if first column matches a value on another worksheet

I have 2 worksheet tabs in an Excel workbook, tickets and tickets info. I have values in Column A of tickets (from A2:A500). I want to search for each value from A2 to A500 of the ticket sheet looking ...

**5**

votes

**5**answers

52k views

### Best way to remove leading zeros from a non-numeric value in Excel

I have many cells in an Excel sheet, using 9 characters of 0-9 and A-Z, that have some number of prefixed zeros:
000000123
000001DA2
0000009Q5
0000L210A
0000014A0
0000A5500
00K002200
I'd like to ...

**3**

votes

**2**answers

33 views

### Filtering Data Excel Data from Survey to Obtain E-mails

Over the summer we conducted a survey for a number of students to indicate their interest in a number of clubs. The way the responses were scanned in gave us a column for each club and a '1' in each ...

**0**

votes

**1**answer

19 views

### Averageifs in Excel

I need help with a formula that will provide answers for the yellow shaded cells below. I think it's an average ifs function. I keep getting DIV/0
In the example below, I'm trying to get the ...

**0**

votes

**3**answers

49 views

### What is the delimiter for the CSV file below?

I'm having trouble importing the CSV file, below, into Excel 2007. I can't figure out what the delimiter is.
...

**1**

vote

**2**answers

3k views

### Cells are not showing date as per Format in Excel 2010

In my excel sheet, I have selected date in Format Cells as 3/14/01 (which is M/DD/YY)
Some cells in DATE column are showing date in correct format like 5/31/12 (M/DD/YY), while some are showing it as ...

**5**

votes

**5**answers

2k views

### How to combine data from two rows, when certain criterion is met

click to enlarge
I'm trying to make this Excel document but I want the AdminTimes for the same LastRxNo to be on the same line. So if the LastRxNo is the same, have one line and the AdminTime column ...

**0**

votes

**3**answers

701 views

### Excel saves a file in .csv but it keeps the columns and the rows as they were in the original sheet

I have a problem converting an Excel sheet in a *.csv file. I've searched all day for solutions, but nothing seems to work.
After I select the sheet and save it as "CSV(Comma delimited)", pressing OK ...

**0**

votes

**1**answer

8k views

### Any trick to calculating percentages when the base is a negative number

I am trying to calculate percent change when the base number (at time 1) can be a negative and the resulting number is positive (at time 2).
My problem is the percent changes from -4 to +4.
A change ...

**0**

votes

**3**answers

223 views

### How can I resolved Performance issues with Excel 2013?

I'm using a dell E6440 laptop with Core i5 CPU and 64-bit windows 7. I'm running Excel 2013. I do a lot of reporting through Excel and of recent I've noticed reduced performance - choppy mouse ...