**1**

vote

**0**answers

5 views

### Excel worksheet and data manipulation

I want to take data on a spreadsheet and copy a subset of it to two different spreadsheets, then manipulate that automatically. I have a worksheet that has a large volume of data that is already ...

**0**

votes

**0**answers

8 views

### Excel Formula References Not Updating Properly

I have a row that I want to populate with formulas like
=SUMPRODUCT(B93:B96,B46:B49)/SUM(B46:B49)
=SUMPRODUCT(C92:C95,C45:C48)/SUM(C45:C48)
=SUMPRODUCT(D91:D94,D44:D47)/SUM(D44:D47)
but dragging ...

**1**

vote

**0**answers

13 views

### EXCEL 2011 - Inventory with Matrix and Vlookup

I am creating an inventory matrix, which has on the first column a list of all the items in the inventory, and on the first row a list of the dates for when the inventory gets renewed. Basically, not ...

**1**

vote

**2**answers

23 views

### Make a new table that shows only certain cells from a reference table according to their values

I have a of monthly expenses spreadsheet that looks like this:
Rent | $200 | +10% (variation from this value to the past month value)
Internet | $60 | -5%
Fuel | $100 | +12%
... and so on. ...

**0**

votes

**1**answer

25 views

### How to automate data scraping from multiple pages of site where the URL doesn't change

I'm trying to amass a table in excel by extracting the data on a webpage. The site contains 27 pages with data that I would like to lump into one single table in Excel. However, the URL doesn't change ...

**0**

votes

**1**answer

12 views

### Daily spend vs projection spend pacing (%)

I have a google doc sheet which currently has all our accounts spends.There are two tabs.The first tab details our actual daily spend for each account for each day of the month.The other tab is a ...

**-1**

votes

**0**answers

9 views

### column values in excel to place the values (if any) in another column across the second row for a mailmerge word

I have numerous columns in excel that I need to place the values (if any) in another column across the second row for that to pull on a mail merge to word.
If there a function I can place in the ...

**0**

votes

**2**answers

18 views

### Excel 2010 - Extracting Clock In Entries that Have no Clock Out

Thanks in advance for any help on this situation.
I have an Excel sheet that is raw data from a time clock system. This data has the following columns:
A: Date/Time of Entry
B: Purpose of Entry ...

**0**

votes

**1**answer

8 views

### Shared workbook hangs when opening and saving

I have a shared Excel file with 14 people having access. The spreadsheet has been fine for a while, however, in the last 2 weeks, opening and saving the spreadsheet hangs for a good 4 to 5 minutes. ...

**-3**

votes

**0**answers

12 views

### VBA Delete duplicate rows in column B (date) if column C is blank

I have a list of dates in column B, I may have same dates mulitple times as I'm inserting data from another sheet so I'd like some VBA to delete the duplicate date from COL B if COL C is Blank.
Hope ...

**0**

votes

**0**answers

11 views

### check the duplicates and unique data in two or more sheets

I have two sheets of excel, Sheet A and Sheet B.
Both sheets have same column (A is Emp_num, B is Name, and C is amount) but data of both sheets are not same.
How do I get answer on sheet C as data ...

**0**

votes

**0**answers

18 views

### Excel 2010/2013 - VBA - How to run event before print preview

I have been spending a great deal of time trying to solve this issue and searched many forums but I have not yet found a solution. Maybe someone here can find an answer...
I want to run some code ...

**1**

vote

**3**answers

261 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

**0**answers

27 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**

votes

**0**answers

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

**0**

votes

**0**answers

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

**1**

vote

**1**answer

24 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", ...

**0**

votes

**2**answers

32 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 in the sheet.
Now in A2, I put "=A1". Unfortunately, this references the VALUE of A1, rather than the formula. If it ...

**1**

vote

**1**answer

20 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

**1**answer

25 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

**0**answers

12 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

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

**0**

votes

**1**answer

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

**2**

votes

**2**answers

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

**0**

votes

**2**answers

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

**0**

votes

**1**answer

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

**-2**

votes

**0**answers

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

**0**

votes

**0**answers

21 views

### Documenting Excel Spreadsheets [on hold]

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?

**3**

votes

**2**answers

20 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?

**-2**

votes

**2**answers

59 views

### Excel show list based on cell value [on hold]

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

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

**0**

votes

**1**answer

37 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

**1**answer

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

**1**

vote

**1**answer

26 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

68 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

**2**answers

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

**3**

votes

**2**answers

34 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

**3**answers

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

**-3**

votes

**1**answer

25 views

### Entering every Monday Tuesday and Friday as a date

Hi I need to enter the date of every monday, tuesday and thursday on top of a sheet to use as a register, I have looked at the one below and this works for two days, could you please help me to extend ...

**1**

vote

**2**answers

23 views

### Fill formula right to end of row, without going to edge of worksheet

In Excel, suppose I have a row with, say, 26 formulas horizontally from A1 to Z1, and then I move down to cell A2 and type a formula. Now I want to fill that formula to the right, through cell Z2. The ...

**2**

votes

**2**answers

37 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

**1**answer

29 views

### How do I superimpose a conditional formated heatmap based on one set of values over a different set of values in Excel 2013

I would like one cell to be formatted with a gradient color based on the value in another cell. For example, I would like cells A1 and A2 to be highlighted based on the values in B1 and B2. If I ...

**0**

votes

**0**answers

26 views

### If function in MS-Excel

=IF(F506>0,IF(F506-L506=0,0,IF((F506*0.05)>U506,(F506*0.05),U506)),IF(G506>5000,G506*0.05,0))
When the Value of F506-L506 is 0, its not returning 0, rather its returning the value U506. ...

**-1**

votes

**1**answer

13 views

### Using multiple functions in one cell

I'm using Excel 2010 and I'm trying to do the following
For IT Changes in different locations, I'm trying to find how many "successful" changes in "Lake Mary"
The data is in the same file using ...

**0**

votes

**1**answer

14 views

### Access Autofilter listing with VBA

How can I access the unique listing of values in the column that the autofilter displays with VBA?
I already know how to turn the autofilters on and off with VBA. I can access filters that the user ...

**1**

vote

**1**answer

18 views

### Chart Series name referencing cell address Excel 2010 VBA

I am using Excel 2010.
I have a XY scatter chart built and formatted the way I like. I reuse this chart many times, so I just copy and paste the chart into a new worksheet containing the new data ...

**0**

votes

**0**answers

24 views

### Projecting Revenue in Excel

So we are building a spreadsheet to project sales and revenue. In our business, we sign a deal, we get implementation revenue the month after we sign the deal, then we get the recurring revenue for ...

**0**

votes

**3**answers

28 views

### EXCEL VLOOKUP returning #NA when IF condition specifies “ ”

=IF(VLOOKUP(D4,'[05.14_Wave 5 Priority 14 (Big+Cranberry) Specifications.xlsx]Big'!$B:$B,1,FALSE),"Project
BIG",IF(VLOOKUP(D4,'[05.14_Wave 5 Priority 14 (Big+Cranberry)
...

**1**

vote

**1**answer

43 views

### Excel 2013, SUMIFS formula

I think I need to use a SUMIFS function for this but I am not positive. I have a list of codes:
All of these codes are in a category of downtime, each code also has minutes 5,10,15,40,65 etc. My ...

**1**

vote

**1**answer

21 views

### Lock color scale (convert to fixed)

I have used conditional formatting to apply a color scale to a range of values. Now I would like to permanently freeze those colors. I have poked around a bit, and can't find event the beginning of ...