**0**

votes

**0**answers

4 views

### Web scraping / crawling a particular website

I'm trying to scrape 1265 html files at once to get name and descriptions of items I have on a website.
I have permission from the wholesaler to copy there data but I don't want to spens days just ...

**0**

votes

**1**answer

15 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

**1**answer

22 views

### How to create a relational data table in Excel

If I have the following Table1 in Excel
Name Age Sex
Pablo 28 Male
Victor 32 Male
Juan 33 Male
Pedro 40 Male
Jacinta 24 Female
Laura 39 Female
And Table2
Sex Color
Male ...

**0**

votes

**2**answers

16 views

### Weird File Attributes in Excel Save Dialog

I vertically re-sized my excel Save As dialog today and found a bunch of strange file attributes that I've never seen in the dialog before. They only appear when the dialog is resized small enough ...

**0**

votes

**1**answer

7 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

**0**answers

8 views

### Expand Excel ComboBox on click

How can I set up my combo boxes on the form i am building to open automatically when clicked on the field portion not just the arrow? I have been searching for a while and I can't seem to find any ...

**-2**

votes

**0**answers

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

**1**

vote

**0**answers

21 views

### Avoiding Long Nested IFs in Excel Function

I have a formula that relies on two different inputs: the first is an integer value between 0 and 5, and the second is the rounded sum of values in an array. I would like to have users input values ...

**0**

votes

**0**answers

11 views

### How do compare similar contents AND return a cell's contents?

In Excel, how do I tell it to compare two tables with SIMILAR primary keys, find a relatively close match, and then return the info from one of the cells (more than just a yes/no, 1/0, true/false.
...

**0**

votes

**2**answers

21 views

### Using IF to Place A Value in A Different Cell

Is it possible to do something like the following?
=IF(A1=0, Place "Yes" in B2, Do nothing)
I was considering using =OFFSET somehow, but I'm really not sure how I would implement it here.

**0**

votes

**0**answers

16 views

### Changing what browser Excel hyperlinks open in

Right now all of my hyperlinks in excel open with IE.
I'm hyper-linking Google sites though, and I would prefer that they open in Chrome.
How do I change what browser hyperlinks open in?
There's no ...

**1**

vote

**1**answer

12 views

### Navigating an excel document using excel links

I'd like to be able to click on some text in a cell that automatically moves the insertion point to a specified cell or row.
So ideally I could have a cell (or some text in a cell) say: ["see row ...

**-2**

votes

**3**answers

18 views

### Formula that references two cells

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

**-4**

votes

**1**answer

19 views

### Formula for moving data up in excel

Can anyone help me with a funciton in excel. I have a customer that has their data all in one column. I need a funciton so that its over multiple columns on one line.
Example Below:
Column A
77.12 ...

**3**

votes

**2**answers

97 views

### Flatten Excel Formula (2007)

Say cell A1 has the formula A2 + A3
and B1 has the formula B2 + B2
and C1 has the formula A1 + B1
I need an easy and quick way to create the formula for C1 in the flattened state..
i.e.
(A2 + A3) ...

**0**

votes

**1**answer

13 views

### Excel linking two to three column

i have a table of productid, product name and price. In Excel Productid i want to give as drop down & on selection of particular id the respective name and price should appear in next column ...

**2**

votes

**3**answers

9k views

### Display Blank when Referencing Blank Cell in Excel 2010

I have an Excel 2010 workbook that contains a number of individual worksheets. The cells on one of the sheets are linked to individual cells on two other worksheets in the same workbook. I'm using a ...

**0**

votes

**0**answers

18 views

### Excel function with the same name as cell reference

I'm using an add-in to Microsoft Excel called Isoplot, it's used for analysing and processing radiometric data for dating geological materials etc.
One of the user defined functions is intended to ...

**1**

vote

**2**answers

27 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

**2**answers

22 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

20 views

### How to write the cells in rows one under the other in columns?

I have a list of name, company, phone number, address and e-mail. But each name who works at the same company is in the same cell. Of course, the other informations of those names like phone number, ...

**0**

votes

**2**answers

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

**0**

votes

**1**answer

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

**0**

votes

**1**answer

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

**1**

vote

**1**answer

14 views

### Excel Conditional Formatting Colour Scales highlight group of cells when another cell is a certain value

So I have a document that has 2 drop downs with the first acting as a currency selection and the other acting as a discount selection (0% - 50%). Basically whenever I select from the dropdowns the ...

**2**

votes

**1**answer

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

**0**

votes

**1**answer

12 views

### Trying to sum a column of values between settable dates

So I have a list of costs over a period of time. Each row is a date, descriptor, quantity and value. So looking at the image, all the values in B, C and D are entered manually or through some other ...

**0**

votes

**1**answer

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

**0**

votes

**1**answer

15 views

### What's wrong with this COUNTIFS() formula?

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

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

**1**

vote

**1**answer

8k views

### Plot 2d graph in Excel

I have data in three columns, one for the x axis, one for the y axis and one actual data as:
X Y Value
0 0 1,005155
0 1 2,051385
0 2 1,15305
...
1 0 1,112285
1 1 1,48512
1 2 ...

**0**

votes

**0**answers

22 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

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

**2**

votes

**2**answers

969 views

### Excel Loses Reference to Data to Copy When I Type Elsewhere On the Sheet

I'm making a list in Excel where many rows have the same data in a number of columns, enough so that I'd like to hit Ctrl-C once on this set of common data, and then just hit Ctrl-V every time I make ...

**2**

votes

**1**answer

477 views

### Excel 2010 removes data from clipboard, how can I stop it? [duplicate]

The order of my actions is:
Copy data from pivot table from second sheet.
Paste data as value into first sheet.
Notice that something is wrong in the data.
Go back to the second sheet and change ...

**1**

vote

**2**answers

15k views

### How to apply Conditional Formatting based on previous cell value?

Is it possible apply Conditional formatting based on the value of a cell from the left?
What I need is to apply a red colour if the value is less then previous cell no colour if it unchanged and ...

**0**

votes

**1**answer

19 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

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

**5**

votes

**3**answers

2k views

### How to combine data from two rows, when certain criteria 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

**2**answers

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

**0**

votes

**1**answer

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

**9**

votes

**3**answers

7k views

### How do I enter dates in ISO 8601 date format (YYYY-MM-DD) in Excel (and have Excel recognize that format as a date value)?

I tried to enter this date in ISO 8601 format (YYYY-MM-DD) in Excel 2010: 2012-04-08, but Excel automatically converts the date format to 4/8/2012.
I tried scrolling through the different types of ...

**7**

votes

**4**answers

13k views

### Excel table - delete rows not in filter

i have a very large table in excel (1000's of rows) and i filter it to only show 10 rows. I wonder if there is a way to delete the rows not shown [ ie dont meet filter conditions]? this would enable ...

**3**

votes

**5**answers

6k views

### Excel graphs: how can I extract a graph legend and place it on the worksheet itself?

I have 8 graphs all with the same legend (line colours and meaning), so in order to save space I would like to remove the legend from each graph and create/include just one large one at the top of the ...

**0**

votes

**1**answer

32 views

### How do I lookup and return to multiple value?

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

**-3**

votes

**0**answers

20 views

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

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

**0**answers

14 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

**1**answer

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

**-1**

votes

**2**answers

26 views

### Comparing two columns and extracting the entire row data in excel

The names from a column in sheet1 has to be compared with names from a column in sheet2, and the if a name matches, the entire row data of that particular name from sheet2 has to be displayed in ...

**-2**

votes

**1**answer

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