**0**

votes

**1**answer

9 views

### Excel - how to sum values in one columns based on set of matching rows in another column

I have 3 columns: Class ID, Status, Count
I need sum of Count column (in new column), for every row that has same Class ID. I have tried SUMIF but I do not know how to check previous row value.
So ...

**1**

vote

**1**answer

14 views

### Is there a way to “save as” a pdf linked by hyperlink in an excel file?

I am tasked with downloading hundreds of pdfs that are linked via hyperlink in a giant excel file. As of now, I click the hyperlink, which opens the file in adobe reader in internet explorer, and save ...

**0**

votes

**0**answers

9 views

### The delicate application of DDE

I looked up a method of opening multiple files in separate instances of MS Excel, as I have both a landscape oriented and portrait oriented monitor and need to use both. The common method of doing so ...

**-1**

votes

**0**answers

16 views

### 2 Excel Tabs: Find matching values in column As and match the B columns based on A. (Only one tab has B filled)

I have two tabs in excel; one working with technologies and one with patents on those technologies. The technology tab has each tech ID in column A, and the patent tab has the same tech ID numbers but ...

**-2**

votes

**1**answer

11 views

### Excel Vlookup across 2 workbooks

I have two columns of data in different excel workbooks:
I want to compare all the data in column C of Workbook 2 against the data in Column D of Workbook 1.
If the data in column C matches the data ...

**1**

vote

**1**answer

13 views

### Using OR condition in SUMPRODUCT

I have three columns of data - a sum column (A) and then the two columns that form the sum (B and C). Sometimes, just one of the B and C columns is filled in; occasionally the B and C columns are both ...

**1**

vote

**2**answers

24 views

### add same value to range of cells in microsoft excel

I want to add the same word from cell B1 to B40000
I do not want to use the click and drag box method to apply it across multiple cells/rows.
I know I have to type in the formula bar B1:B40000 but I ...

**0**

votes

**0**answers

7 views

### Average over all pivot rows in excel

Say I put into pivot a number of bananas eaten by the monkey, sliced by months and days.
How to add a column containing average number of bananas eaten by the monkey over all period of time?
...

**-1**

votes

**0**answers

14 views

### How can I use 2 information on 1 Y axis graph?

please help. I want to create a column bar graph that shows 2 information, one is the actual number and another is the annualized number. Can it be stacked but with different style (the annualized ...

**-1**

votes

**1**answer

28 views

### how can I sum hours in excel

I have a sheet with names, that appear up to 20-30 times in the column. Every name has in another column a time related, meaning work hours. I want to sum those hours, for every name particularly. SO ...

**0**

votes

**1**answer

12 views

### Text function in Excel isn't formatting year

I've got a problem with the text function in Excel (2007).
It doesn't format the year, it just states yyyy instead of e.g. 2014.
If I have a cell with 23-7-2014 and use the formula ...

**0**

votes

**2**answers

17 views

### how do I sum a column with times that are related to another colums

I have a sheet with names, that appear up to 20-30 times in the column. Every name has in another column a time related, meaning workhours. I want to sum those hours, for every name particularly. SO ...

**0**

votes

**3**answers

18 views

### Compare 2 columns in Excel and copy data from 3rd column

I'm trying to compare 2 columns that don't have the same size (one has 205 entries, the other 440) and if the data from column B matches the data in column A, the data from column C must be copied in ...

**0**

votes

**1**answer

8 views

### CSV compabtility issue in excel

I download a .csv from database and use the file to generate a PDF using a PDF conversion service. However, for specific files, the conversion fails and the request times out. I checked the file type ...

**0**

votes

**1**answer

11 views

### Excel - sumifs and indirect

I am trying to obtain data from multiple worksheets:
Where:
sheet 1 - has an F2 cell that enables you to choose from a drop down list of names and each of these names equals a different worksheet in ...

**1**

vote

**2**answers

27 views

### Is it possible to see if two cells contain similar text in Excel?

I've got two columns populated with names, and I want to see if the names in each row are similar (not the exact same, just similar) to each other. Is there any way to do this on Excel?

**-1**

votes

**0**answers

7 views

### Converting excel cells in individual slides in powerpoint

I have one long column of info (see below) and need to take every two lines (the person's response and their name) and easily make them into individual powerpoint slides?!?!?! ASAP?!?! Please help
...

**0**

votes

**0**answers

20 views

### Excel crashes everytime when saving a specific file

The instant I try saving a particular excel document excel will crash.
How do I solve this problem, I've tried saving as different excel formats but I got the same result, except for when I saved it ...

**0**

votes

**0**answers

21 views

### How to live-update query/view data for order-status update. MS Access

If anyone remembers File Express by Expressware (a DOS program), this is what I'm trying to replace.
I need to create a database to keep track of different custom jobs. (This is not used to print ...

**0**

votes

**0**answers

26 views

### Embedded excel chart in powerpoint does not print correctly from Office 2013

We have a user that has Office 2013 installed in her machine - she is the only one. The rest of the users have Office 2010. The user with 2013 is the only one with the issue.
There is a powerpoint ...

**0**

votes

**2**answers

48 views

### Calculating time difference between two date/times from two columns in Excel

I have 5 columns: Start Date, Start Time, End Date, End Time and Duration. I need to calculate the duration between the Start Date/Start Time and the End Date/End Time. I tried just subtracting the ...

**-1**

votes

**0**answers

15 views

### excel formula for data with icon sets [on hold]

I need help with excel formula to use in my data
I have data with set icons so what i have to show is percentages of my icon for example if data has all tick signs is 100% or if 3 ticks and 1 cross ...

**-1**

votes

**0**answers

15 views

### Excel - Timesheet query - find first booking in and last booking out in a day

I have a spreadsheet of about 5000 rows as follow
COLUMN A: EMPLOYEE NAME - Jo Bloggs, Sheryl Smith, etc
COLUMN B: DATE/TIME
COLUMN C: EVENT (IE "BOOK IN" OR "BOOK OUT")
I am trying to find the ...

**0**

votes

**1**answer

25 views

### Automatically Copy the only Credit rows into a Sheet

I am trying to use a formula by the below, With out use Developer Options.
I have a excel workbook and there is a two sheets
One is -
One sheet is (sheet1)-
TXN. ID Transection Type After ...

**-1**

votes

**0**answers

13 views

### how to create excel charts having strings in both x axis and y axis [duplicate]

I have a student data with Student Name and their grade (A/B/C/D/E.). Now I want to have a graph for this data.
Description: Hai, I was tried to plot a graph having two fields (NAME and Gradde like ...

**0**

votes

**1**answer

33 views

### How to extract HTML elements?

I have a few hundred of these divs, that I need sort and filter.
I would like to remove ALL HTML and be only left with the following:
Example
Name = Keith
Email = ...

**0**

votes

**1**answer

8 views

### How to modify data in a column from a sheet and have it automatically modify itself in the same column but a different sheet in Excel

Say I have 2 sheets with column A being a list of clients that needs to be identical in every sheet and the rest diferent. What formula do I need to use so that when I modify a name/client refference/ ...

**0**

votes

**3**answers

27 views

### In Excel PivotTables, how do I show items that occur in one category but not another?

Simplified version of my data:
item category number
apples fruit 7
orange fruit 2
tomato fruit 3
tomato vege 9
zuchini vege 2
tomato vege 17
...

**0**

votes

**0**answers

27 views

### Microsoft Excel 2007 - Auto Update in 1st Sheet based on What updated in 2nd sheet (2nd sheet Update will be in Fixed Column but Random Row)

Actually I'm facing a problem now.
I am using Excel 2007.
And, I have two different sheet of excel file with me.
My 1st sheet is my report.
My 2nd sheet is my customer name.
I hope that when ever ...

**0**

votes

**1**answer

18 views

### How can I find all cells in Excel with a particular value and get the sum of all those cells' dependents?

I am trying to find the total number of screws, nuts, washers, etc for a very large assembly. For each part in the assembly, I have the number of each type of hardware. I would like to find the total ...

**0**

votes

**1**answer

21 views

### Count Unique Cells Matching Results in Set

I've got a single column of coded data in Excel like this:
a
b
ab
bc
ad
b
ac
I know I can find the instances of all cells containing "a" with =COUNTIF(A1:A7,"*a*"). That would give me 4. I can also ...

**0**

votes

**3**answers

35 views

### Excel filter duplicate values in column A and filter out rows which have column C blank

Total n00b here.
How to filter duplicate values in column A and filter out rows which have column C blank.
I have 2200 rows in Col A (the first 1400 rows also have data in Col B & C, the next ...

**-1**

votes

**1**answer

17 views

### Find matching data in two different spreadsheets

I am a realtor with two spreadsheets. One is a list of approx 250 names and addresses of people for whom I have phone numbers but no info about home equity. I have another spreadsheet of about 1400 ...

**1**

vote

**2**answers

16 views

### How do I use a range with MS Excel COUNTIF

I have 2 columns of numbers - Columns A and B. I'd like to get a total of the number of rows in which A > B. The COUNTIF function seems right but I can't figure out how to use a range in the 2nd ...

**1**

vote

**1**answer

23 views

### Calculate the APR for a loan with an irregular payment schedule in MS Excel

I'd like to setup an Excel spreadsheet to calculate the APR for a loan with an irregular payment schedule. For example a 12 month loan with 11 payments of $100 and a final payment of $500. I know ...

**0**

votes

**1**answer

18 views

### How to shade the area under a straight line graph in Excel

How do I shade the area under a straight line graph in Excel, along the x-axis? The graph data points are shown below.
0-16.67
170-16.67
170-6.712
187.5-6.712
652-25.352
670-33.408
910-33.408
910-0
...

**2**

votes

**4**answers

56 views

### In Excel, how to count enormous number of timestamps, and arrange counts in 5 minute periods sorted by day of week?

I've got just over 300,000 rows in a spreadsheet, and each of these rows contain a timestamp (HH:MM:SS AM) and a date (DD/MM/YYYY).
I'd like to get counts for these timestamps and group them in 5 ...

**1**

vote

**1**answer

19 views

### VLOOKUP not interpolating all cells?

My VLOOKUP formula is not interpolating all cells
AD AE AF
11-6-2014 15:20 90,4 #N/A
11-6-2014 15:21 89,1 #N/A
11-6-2014 15:22 90,4 Good
11-6-2014 15:23 89,1 Good
AF column is my ...

**0**

votes

**1**answer

17 views

### Excel 2010- long number corruption

I have a set of data, received in .csv format, in which I have a set of long UPRN numbers. I am involved in data matching processes related to new IER voting regulations.
When I open the .csv file the ...

**-2**

votes

**0**answers

10 views

### Creating line chart on the basis of full years time sheet

I am trying to make a chart with full year time sheets of all employees but unable to do it.I have time sheet of each employee including details such as name,date,clock in, clock out
Now i need to all ...

**0**

votes

**2**answers

19 views

### Error when value not present

I am using the code below several times over in one sub for different values not just "CPNEC". It works fine where there is a range with that value on the spreadsheet but falls over it the value does ...

**0**

votes

**2**answers

36 views

### I have a user that is unable to open xlsx file

I have a user that is unable to open xlsx file. Our environment is Office 2007, Win 7. Everyone else can access the file except for her. And it doesn't matter what PC she tries to access the file from ...

**-1**

votes

**2**answers

35 views

### how to create excel charts having strings in both x and y axis

I have a student data with Student Name and their grade (A/B/C/D/E.). Now I want to have a graph for this data.
Kindly help me.

**1**

vote

**0**answers

37 views

### vlookup in a cell that contains mid formula

I am trying to create a vlookup in a cell referencing a specific cell so that I can pull the data from my lookup table. Well this cell that I am referencing happens to have a mid formula in it, and ...

**1**

vote

**1**answer

15 views

### How to remove one column of a calculated item in Pivot?

I have two columns. One with data from this year and the other with data from previous year. I now have added a calculated item in Pivot to display the % delta of these two years. Now when doing this ...

**0**

votes

**1**answer

22 views

### In Excel I need to find data on sheet3 from data on sheet1

I have an Excel workbook with several sheets. The column 'SheetA'!W:W lists text that can be found within a column header on row 'Sheet3'!1:1. For example, SheetA'!W42 contains "B16". Cell ...

**0**

votes

**1**answer

28 views

### Add a row in excel based on criteria

I have a very large excel spreadsheet 2000+ rows deep.
I am organising it by adding a blank row each time the first word in Column C changes; I have been at it for over half an hour now and this got ...

**-1**

votes

**0**answers

17 views

### comparing two excel documents to match row color of first document

say i have two excell documents, .... one was sorted manually the day before, and then color coated in certian colors based on certian criteria, and the next day a different report comes out that ...

**0**

votes

**2**answers

44 views

### Explanation of the dollar sign

When referring to a cell, what is the difference between these?
A1
A$1
$A1
$A$1
For my situation, I need a formula that says "when A equals 8" but more importantly the difference between each of ...

**0**

votes

**0**answers

22 views

### Formula to match date in one column with multiple dates in other column and Increase it to next date if match is found

I need to compare individual dates in row with holidays dates in other column. If date matches with holiday, then increase the date to next date. If there are two consecutive holidays it should ...