**0**

votes

**0**answers

21 views

### Matching words from two title and calculate %

I was trying to automate an Excel file which has title in both A and B columns and I have to search each word from A within B and calculate the % by using the "no of words matched/total no of words ...

**0**

votes

**2**answers

38 views

### Calculate Total Number Of Days Per Specific Month

Cell A1 shows the Start Date, e.g. 17/09/15
Cell B1 will need to reflect the End Date.End Date need to be based on 3 months of Start Date.
I can't just use 90 days as standard days to add to the ...

**-3**

votes

**0**answers

49 views

### Excel Spreadsheet

I am not sure how to keep a formula going when at the end of my column so that it doesn't keep pasting the same number until data is entered.
My formula is: F9=D10-E10
It is repeated for the 11 rows ...

**0**

votes

**1**answer

28 views

### How do you find the total numbers of times a word has been used?

For example, say I'm trying to total yes/no questions. I want to be able to go down a column and see how many times the answer was yes and how many times the answer was no. I'm also using a drop-down ...

**56**

votes

**2**answers

3k views

### Excel - can I set a cell to equal a certain value, no matter what is typed in it?

This is to play a joke on someone...not sure if it's possible to do what I want. We are circulating an Excel file among friends to select players for a golf tournament. I would like to set a cell ...

**1**

vote

**0**answers

35 views

### How can I ensure that a formula that I have written to calculate the difference between time values applies only to the filtered values?

I have two columns of data:
Member Time
A 09/24/2015 09:48:36
A 09/24/2015 09:47:40
A 09/24/2015 10:11:06
A 09/24/2015 10:08:47
B 09/24/2015 10:28:45
B ...

**0**

votes

**1**answer

25 views

### Excel - Count matching Items, comparing a row with a column

I am trying to compare the similarity of a series of sets of data...
I have a series of columns of 20 values (numbered 1-20), and corresponding rows of 20 values (also numbered 1-20).
The columns ...

**0**

votes

**1**answer

17 views

### Highlight row if ID is found on other sheet

I have one Excel file that contains 2 worksheets.
Worksheet 1 columns:
computernames Username E-Mail
comp1 username mail@mail.de
comp2 username2 mail2@mail.de
Worksheet 2 columns:
...

**1**

vote

**1**answer

24 views

### How can the placement of data points in a graph be adjusted?

As part of an important presentation, I've created the following diagram showing statistical data over 5 periods of time.
The data for each period consists a pair of a bar charts with a ...

**0**

votes

**1**answer

21 views

### Filtering Out data as part of a VBA macro

I'm trying to create a macro that will automate a report. Issue is, the source data brings through data we don't need, and the report itself does lots of calculations based on the table as a whole. ...

**0**

votes

**1**answer

14 views

### Reference a cell with input from another cell

The final objective is to reference the last populated (higher row number) cell from a column (its value).
I found a function that returns the row number of the last populated (higher row number) ...

**-1**

votes

**2**answers

27 views

### extracting a line of data from an excel spreadsheet

I need to extract a line of data from a excel spreadsheet and transfer it to another sheet. I need to search for a series of dashes (- - - - -) and then extract the line of data that is 2 lines below ...

**0**

votes

**1**answer

25 views

### Changing the “file opened by another user” warning timeout

This is an almost opposite to this problem - My workmate keeps an Excel spreadsheet open for a whole day (she has good reasons to do so) without editing. Now if someone else would like to access this ...

**1**

vote

**1**answer

31 views

### Excel 07: Sum Cells of Column B By Date in Column A And Report To Cell C

So basically I have a worksheet like so,
The data is manually entered in, column A is the date, the values are column E. Everything else is arbitrary and filled with x's. Basically what I want to ...

**0**

votes

**1**answer

50 views

### How can I convert colums to rows in Excel? [duplicate]

Below is a sample of a spreadsheet I have (fig 1). It has been exported from an asset tracking system and provides me a list of information about the hardware we have.
Each asset "area" uses the same ...

**0**

votes

**0**answers

31 views

### Separating concatenated name, address, and phone number

I imported company names, addresses, and phone numbers into a cell. Due to the different number of characters, I cannot separate the fields of information with text to columns; for example:
ABC ...

**1**

vote

**2**answers

26 views

### How do I extract a parameter within a URL in Excel?

I have the following URL in my Excel sheet rows:
www.test.com/folder1/?tagid=1234567
How do I extract the tagid value into a separate column so I simply have "1234567".
Thanks!

**-1**

votes

**0**answers

24 views

### Different results on the same PC with the same software

I have a user on Windows 7 and his Excel worksheets (Office 365) do not open in Share Point (2010) but if he logs out of windows, I can login and open the same worksheets that did not open under his ...

**0**

votes

**1**answer

26 views

### Combining multiple Excel rows based on similar contents then incrementing a column in VBA

I'm trying to set-up a VBA routine that will check all the rows of a worksheet and then combine two rows that are identical, then once it does that increment the "QTY" column.
Below is a before and ...

**1**

vote

**0**answers

24 views

### Excel 2015 error - no message

I have a strange error on Excel, that has no error messages. Screenshot below.
I'm using the following:
Software: Office 365 Plus
Version: 15.0.4753.1003
OS: Windows 7
The problem only occurs ...

**1**

vote

**1**answer

31 views

### Can I use this macro to convert first letter to UpperCase after comma?

I use this little macro to convert the first letter to UpperCase in a specific range
Sub TitleCase()
Dim rng As Range, cell As Range
enter code here
Set rng = Range("D4:D999")
For Each cell In rng
If ...

**0**

votes

**1**answer

22 views

### IF X and A display area “A1,G20” If X and B display area “A1,G20” but on a different sheet

I'm trying to put together a excel spread sheet for our quarries.
but we have a lot of different pits along two rivers that we collect our raw material from each with its own set of sieve results. now ...

**0**

votes

**1**answer

28 views

### How to modify these VBA codes to save excel sheet in excel format (.xlsx)?

I have added a button in excel sheet and now when I click that button it saves the sheet at specific path with specific name but in pdf format.
I want to save this sheet simply in excel format ...

**-2**

votes

**0**answers

36 views

### Reconstruct which values were in a total in Excel

I'm looking for a function in Excel to help with allocations. For example Column A will have invoice numbers and Column B will have amounts, with a total of 15 rows.
I received payment for 3 of those ...

**0**

votes

**0**answers

31 views

### How do I delete if is a duplicate of multi columns? [closed]

How do I use a macro to delete colum a if it is a dplicate as well as if column be is a duplicate - they both need to match this for the macro (or formula)
----------edit
columns a has phone number ...

**0**

votes

**0**answers

19 views

### How to read the data from multiple sheets of an excel file?

I have an excel which contain approx. 25 spread sheets. One sheet is for data entry and 5 sheets showing the result. On other sheets there are lot of calculations. So to track down the output value of ...

**0**

votes

**1**answer

12 views

### Getting the name of a named cell in MS Excel 2011

I am using a formula in Excel, which involves cell names.
The formula is
=MIN(name1,name2,name3)
name1 is the smallest, but it shows name1's value. I want it to show the text "Name1". How do I do ...

**0**

votes

**0**answers

7 views

### Excel hyperlinks with software switches attached

I want to launch an application in this case VNC and add the IP address of the tool I want to connect to.
It looks like excel tries to verify that the whole thing is a valid application rather than ...

**-2**

votes

**1**answer

37 views

### How do I add a button to a spreadsheet and remove borders from a particular cell?

I have two queries regarding the following Excel file:
I would like a button on this excel sheet whose name should be “Save as PDF”.
When I press this button it should save the excel sheet’s ...

**-1**

votes

**2**answers

41 views

### Returns a specific text if a cell in a row contains a specific letter

How do I get a specific text if there is a specific letter in the row.
E.g. row A1:A6 contains a letter "c" in any cell. It return the Text "Catch" in column A7. and if there is "b" then it should ...

**3**

votes

**1**answer

17 views

### Excel INDIRECT function referencing cell with variable row from another worksheet

I cannot get the INDIRECT Excel function to reference a cell from another worksheet.
I've tried many variations of the following formula but always get an error
=INDIRECT("'Form Responses ...

**0**

votes

**0**answers

35 views

### Sub-divide huge spreadsheet into groups of rows

I have a series of spreadsheets (Excel 2013), with huge lists of data (18K to 100K rows, many columns). I need to analyze this data in isolated chunks of 500 rows each. I'm looking for a way to ...

**-1**

votes

**1**answer

18 views

### Activate a sheet in excel 2010 vba using a variable name [closed]

I am trying to activate a sheet using a variable name and am getting a subscript out of range error
the variable is declared this way
Phonecall = Phones(i) & "-UnbilledData"
when i is 1, ...

**-1**

votes

**1**answer

22 views

### Excel formula need formula for if value in A1>0 we need A1, but if value in A1 is 0, then we need the lowest value of A2 and A3

A
1 5000
2 10000
3 12000
4
I need a formula for if value in A1>0 we need A1, but if value in A1 is 0, then we need the lowest value of A2 and A3.

**4**

votes

**2**answers

44 views

### How to Export — not Save As — to another format?

How can I Export a sheet or table or selection to another file format without changing the currently active document ?
Our primary data operation environment is in Excel, where extensive use of ...

**5**

votes

**2**answers

47 views

### Can Excel perform a count-if-like sum mixing absolute and relative cell coordinates?

Suppose I have a spreadsheet structured a bit like this
_A____B____C____D____E____F_____
1 |XFoo|XBar|YFoo|ZBar|XBaz|Result
2 |8 |3 |0 |1 |100 | (*)
3 |2 |1 |1 |20 |10 | (*)
I ...

**0**

votes

**1**answer

27 views

### How do I use today's entered data in excel for a formula?

I have a table that is 30 rows long in a column. Every day I enter my weight. So day 1 I entered my weight into A1, day 2 into A2 and so on.
Now I want to calculate some things based off of this, ...

**0**

votes

**3**answers

19 views

### Consolidate data from several worksheets with same columns but different number of rows in Excel

I have an Excel workbook with several worksheets. They all have the same column names. However, the number of rows differs from sheet to sheet. I want to create an overview sheet where I can see all ...

**0**

votes

**0**answers

33 views

### Split cell data into multiple cells

I have a database in which the most part of cells have multiple data inside. So what i need is something that split every cell into multiple rows. I found different VBA codes that solve similar ...

**0**

votes

**1**answer

22 views

### excel: how to place rows at the bottom of list in sort and filter options?

Here is what I have at the moment:
Click on home ribbon button
click sort & filter drop down box
I have a sort option as follows:
As you can see the rows have been commanded to go to the top ...

**0**

votes

**3**answers

24 views

### How to get a particular y value on a graph from Excel

Here below is my Graph:
Let's say I have a reading of 1.02 ml (the x-value from the graph) from my buret, how do I find the corresponding y-value?

**0**

votes

**2**answers

19 views

### Excel function to add incremental number based on conditions

Would appreciate any help please. I have a column that contains text values and a column that contains dates. I am trying to add an incremental number in the third column based on first finding ...

**0**

votes

**2**answers

30 views

### Excel Formula - Budget Structured Tables - Monthly View

I've been searching around and I am struggling to find why my formulas are not working.
Before I post my formulas I need to explain what I'm trying to do and it is a bit complicated (At least, this ...

**0**

votes

**1**answer

29 views

### How to find character front of instr in vba

Problem Description: Find a instr(which is number) then check if the instr value carrying any character front of it or not.(for ex. 123, x123). If instr or instr with character matches the value from ...

**-3**

votes

**0**answers

16 views

### screen flash in excel 2013 when hitting enter after filling out a field, on windows 8 [closed]

The screen flashes when I hit enter after putting information in a cell. We have tried a quick fix, and no results. This is using windows 8.1, excel 2013.

**2**

votes

**2**answers

31 views

### Highlight duplicates only if the header is the same

I'm attempting to use Conditional Formatting to highlight a duplicate entry if and only if the Header to both columns are the same.
In my example below, this is a season long NFL contest of picking ...

**0**

votes

**2**answers

63 views

### In Excel 2010, how can I subtract two times when I also have the date in the cell and get the value in seconds?

I have a column of data as follows:
09/22/2015 10:25:22
09/22/2015 10:27:00
I want to subtract 09/22/2015 10:27:00 from 09/22/2015 10:25:22 to get the value of 98 seconds.
I tried formatting ...

**0**

votes

**1**answer

16 views

### Excel 2010 - Stop solver when trying to find subset that adds to total

I found how to use the solver to find a subset of numbers that adds to a given total - very nice.
Now, I sometimes am not certain there is a solution. When Excel takes too long, is there a way to ...

**0**

votes

**1**answer

25 views

### How to remove the title from a data table in excel?

Is there a way to keep the data table but remove the values' title (highlighted in red)?
I would like to keep the legend however..

**0**

votes

**1**answer

24 views

### Excel formula for check first 2 digits in a code and returns a different text in another cell [closed]

I want to a formula in excel to check first 2 digits in a set of a long code in one cell and returns a different specific text for different numbers in another cell