**0**

votes

**1**answer

12 views

### COUNTIFS Statement Between Dates

I have a report I am creating that sifts through a lot of Data, I have created a COUNTIFS statement that does what I want, but I am having trouble with the dates.
I am trying to find the number of ...

**-1**

votes

**1**answer

42 views

### How to write Excel macro to copy selected row of data between two sheets?

I'm not really experienced in the whole VBA area, i get how macros work but this is just out of my reach.
Basically as i stated in the title i need to write a macro that will copy the selected row or ...

**0**

votes

**2**answers

18 views

### In Excel 2010, how do you format text to string without having to open and enter on every single cell?

I was given an Excel document.
In the data there is a column of dates formatted 5/20/2014. Half the data in that column is formatted as a date. The other half is formatted as text. When I try and ...

**-2**

votes

**0**answers

16 views

### How do I remove icons from ribbon and menus office 2013?

In (Windows 8.1 Office 2013) Excel 2013 the menu caps don't bug me, but how can I have text only and remove the icons? I want text and remove/hide the icons.
Is there a Text Only option?

**0**

votes

**0**answers

23 views

### Rounding Percentages

Okay so I have been having a problem and would really appreciate any help. I have posted a table below with the aim of making this as simple/precise as possible.
Value % ...

**0**

votes

**1**answer

19 views

### What's wrong with this COUNTIFS() formula? [on hold]

Will someone please help me with the following formula
=COUNTIFS('CURRENT LEAD LISTING'!$C$2:$C$378,"ACT",'CURRENT LEAD LISTING'!$E$2:$E$378,"X",'CURRENT LEAD ...

**0**

votes

**1**answer

17 views

### Excel help to lock formulas from adjust on cell insert

I have a excel workbook where there is a hidden sheet that basically pulls data from other sheets in the same workbook just using the = formula.
The problem I am having is if I add a column or cells ...

**0**

votes

**0**answers

17 views

### Why doesn't trace precedent/dependent when using table references?

I almost exclusively use tables when using excel, so my formulas are all using table references. This seems to make the "Trace Precedents" and "Trace Dependents" functions not work though.
Has ...

**0**

votes

**1**answer

15 views

### Autofill in Excel skipping rows

I am trying to accomplish something with excel but I cannot seem to make it work.
In a worksheet I have a simple table with rows and columns. Every row is a new entry.
I then have a template in ...

**0**

votes

**1**answer

21 views

### Assigning a number amount

I know that if I am assigning a number amount to a word that I can enter it in as:
=COUNTIF(D3:H3,"Yes")*20
But what if I also want the same cell to assign 10 if the answer is no? How would I write ...

**0**

votes

**1**answer

25 views

### Creating GANTT Chart (Timeline) From Start Time and Duration

I am attempting to create a daily graphical timeline from start times and duration. I have three columns: Program Name, Start Time and Duration. The data looks something like this...
The desired ...

**0**

votes

**1**answer

23 views

### Automating building a table from web sources in MS Excel 2013

I want to build a table indicating a number of things available in a given market. To do this I access the sites with relevant information and copy numbers to a table each day. I would love to ...

**-3**

votes

**0**answers

22 views

### I need to send an email multiple times to a different recipient each day [closed]

I want to send an email reminder to around 200 recipients that I would like to schedule at the start of the academic year. The problem is, I need to send it to a different person (group of people) ...

**0**

votes

**1**answer

33 views

### How do I lookup and return to multiple value? [on hold]

Please could you advise how could I get a list of expiry dates which matched with Cell A1 =the material number?

**0**

votes

**0**answers

15 views

### Is there an equivalent for Aero Snap for windows in Excel?

I'm running Windows 7 and find Aero Snap really useful. However, I can't find a way to perform the same action within Excel 2010. Is that something that's possible to do?
If I have two spreadsheets ...

**0**

votes

**2**answers

28 views

### Counting Number of unique combinations for multiple columns

I have an excel file with 272,000 lines of data across 5 columns. The data looks like this:
A B C D E
1 1 1 1 1
1 0 1 0 1
1 1 1 1 1
1 0 0 0 0
1 0 1 0 1
...

**0**

votes

**1**answer

17 views

### Apply a formula to an entire column since the number of rows is changing from a source file?

I have a connection to a text file source so the excel worksheet updates automatically. Therefore the number of rows is always growing every time it updates. How can I apply a formula to an entire ...

**2**

votes

**1**answer

22 views

### With PowerPivots, find items that appear *only* in one category

With PowerPivot, how do I find items only in one category? Here's an example:
item category number
obera f6 7
artois f7 2
obera f7 3
ella f6 9
If ...

**2**

votes

**1**answer

13 views

### Use IRR function with discontinuous cells in EXCEL

Is there a way to use a range of cells that are not next to each other with the IRR function?
I'd like to use IRR this way:
=IRR(A1:A3 AND B2) meaning read A1, A2, A3, B2 the same way you would ...

**0**

votes

**1**answer

15 views

### Finding Highest Value Combination From Excel Pivot Table Filter

I'm not sure if I am using the correct technique for this so please forgive me if I am way off.
I have a large range of data from previous email campaigns. I have categorised the campaigns with ...

**2**

votes

**0**answers

38 views

### excel 2010 not inheriting regional settings in windows 8.1

Wondering if anyone else is having this issue. In regional settings on Windows 8.1 i have display negative numbers set to display in accounting mode. eg - (1.0) instead of -1.0
Excel should be ...

**-3**

votes

**3**answers

23 views

### Formula that references two cells [on hold]

I have a chart of nights and people and the rate varies as nights and people. I want a formula that picks up the rate based on te nights and people. See table below. So I want a formula that ...

**0**

votes

**1**answer

21 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

21 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

20 views

### After ignoring DDE function, cannot open separate instances of Excel [duplicate]

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

22 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

19 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

**3**answers

24 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

31 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

10 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

15 views

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

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

35 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

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

**1**

vote

**2**answers

31 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. The times are in the format hh:mm:ss (e.g. 01:15:00). I want ...

**0**

votes

**3**answers

32 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

15 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

12 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

30 views

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

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

8 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

25 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

22 views

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

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

33 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

70 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 [closed]

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

27 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

14 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

39 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

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