**0**

votes

**1**answer

17 views

### Change the focus in EXCEL cell

What do I need to change so when I click for example A5 the focus should be changed to B3, So when I click B5 the focus should go to C3 and so forth....
So my code right now is:
Private Sub ...

**0**

votes

**1**answer

18 views

### Within a Cell TEXT then A1 then TEXT

I wrote a function that allows me to pull data from Cell E2 and insert it after text.
Cell E2 has number 555.
In cell E3 I have added function ="Total: "&E2 giving me output Total: 555.
I want ...

**0**

votes

**1**answer

13 views

### Excel use mouse to jump to beginning of range (opposite of double-clicking cell border to jump to end)

In Excel when you double-click the border between cells you jump to the end of the range (equivalent to Ctrl+DownArrow or Ctrl+RightArrow). Is there a way to click somehow to jump to the beginning of ...

**1**

vote

**1**answer

25 views

### Extract all highlighted text of a PDF into seperat Excel cells

I create a lot of spreadsheets in Excel. Basically consisting of various columns. The problem is that one of these columns contains a lot of text (Whole paragraphs worth). The text inserted into this ...

**0**

votes

**1**answer

31 views

### what is an appropriate shape name as my routine does not say?

i have the following routine that i found on the net here: http://www.ozgrid.com/forum/showthread.php?t=77662
this routine isn't working cause i dont know that shape name. can anyone tell me what the ...

**0**

votes

**0**answers

13 views

### Converting traditional pivot table to data model based

When creating a pivot table, there is an option to add data to the data model. If a pivot table was originally created without this option enabled, is it possible to convert it to a data model backed ...

**0**

votes

**2**answers

54 views

### Find the number of cells to sum to reach a certain amount

I have a column of values (they are ordered if that matters): A:A. I have two values: a starting value B1 which is also present somewhere in A:A, and a goal value C1.
Let's say the we can find the ...

**0**

votes

**1**answer

40 views

### Excel Index match returning value that doesnt exist in the table [closed]

I'm using the formula below:
=INDEX('CPI Adjusted Base Prices'!$A$3:$S$30,MATCH('De Beers Data '!M25,'CPI Adjusted Base Prices'!$A$3:$A$30,0),3)
'CPI Adjusted Base Prices'!$A$3:$S$30 - is the array ...

**0**

votes

**0**answers

21 views

### How can I speed up functions in Excel? How I can make my sheet/worksheet faster? How do I know how long took create something in Excel?

I have long functions in Excel that use other sheets in my worksheet for example :
{=INDEX(
Sheet1,
MATCH(
$A2 &
MAX(
IF(
( 1 * ( $A2 =
...

**0**

votes

**0**answers

17 views

### How to highlight (cells from other sheet) while editing formula?

I was searching regarding highlighting cells from other sheet (in edit mode) but could not find any solution to it. When a cell is selected and in edit mode, the cells used in the formula gets ...

**0**

votes

**1**answer

27 views

### How can I combine all of the rows from two Excel worksheets into a third worksheet?

I have two worksheets, containing a list of transactions on two separate accounts (a savings account and a credit card). I want to get each row from the first two worksheets into a third so that I can ...

**0**

votes

**2**answers

24 views

### Strange residue on cell with Data Validation when using Excel VBA

I'm running into an annoying bug with Excel VBA. See this screenshot.
I use an Excel worksheet as a User Input form.
On the form I have several places where I put Data Validation.
After the user hit ...

**0**

votes

**1**answer

21 views

### creating a relative path in .vbs file

I have a pdf file, generated by Latex, which contains hyperlinks to open an excel file (excel 2003).
I posted a question to Latex forums
in
enter link description here
so that I can make each link ...

**0**

votes

**2**answers

28 views

### defining a measure of unique value counts

How do I define a measure in a data model (withing the PowerPivot feature) with a formula that needs to get a unique count of values. For example, something like this:
reset_rate := ...

**0**

votes

**1**answer

15 views

### Add a number above a cell and continuing on in excel (example given)

I am looking for a formula in excel to add the cell above to the current cell. Then in the cell below, add the current cell and the one above and so on. I am currently doing it manually and it is ...

**3**

votes

**3**answers

44 views

### Finding previous row with a given value

Let's say I have a table with three columns (order is important and can't be changed), rows are sorted by A:
A B C
date ID last_date
10/05/2015 ...

**0**

votes

**0**answers

22 views

### Can I change the default excel time format from mm:ss.0 to mm:ss.000? [duplicate]

I work with a lot of datasets from outside sources with times in the format mm:ss.000.
As such I'm constantly copying them into new workbooks, where excel will display the relevant columns as ...

**0**

votes

**0**answers

16 views

### Select all rows with the same text and then the next set of text (alphabetically)

I have a very big spreadsheet sorted by teacher names and I want a way to select all rows with a particular teacher name. Then I want to be able to automatically select the next set of rows for the ...

**1**

vote

**2**answers

32 views

### In Excel how to make a number like 4.246 be shown as a 4.25 permanently? [closed]

In Excel how to make a number like 4.246 shown as a 4.25 permanently and not be shown 4.246 in formula bar?

**1**

vote

**2**answers

27 views

### Convert time duration string to seconds in excel

I have a series of data that is outputted from an application in the following format.
8d 21h 33m
30s
6m 32s
1m 40s
54m 6s
11m 32s
5d 3h 34m
30s
7m 40s
19h 57m 49s
1h 36m 9s
1m ...

**1**

vote

**1**answer

16 views

### Conditional formating of excel row based on the value of the first cell of the row

I want to apply a conditional formating for a row only if the first cell (A column) contains text starting with Volum. Is there a way to do such a thing ? Thanks in advance.

**-1**

votes

**0**answers

8 views

### Extracting Images from URL's in excel sheet to a particular folder with url as file name

I have an excel sheet which contains images Url's of a particular product in column "A". I want those images to be extracted into a separate folder with file name as url itself.
Can you please help me ...

**3**

votes

**1**answer

68 views

### Work out Start Time + Hours with working days and times

I have the following problem:
In G4 I have 19/01/2016 10:00
In F4 I have the value 200 (units)
In E4 I have the value 38 (minutes)
I want to calculate G4 + (E4*F4) i.e. 19/1/16 10:00 + 7,600 ...

**0**

votes

**0**answers

10 views

### grouping columns in pivot table with data model

It seems that I lose the ability to group columns if I create a PivotTable with "Add to Data Model" option (which I need to be able to do unique counts). Is there a different way to do grouping once ...

**0**

votes

**3**answers

25 views

### Attempting to make a multi-column graph

I am trying to make a column graph where the y-axis is the mean grain size, the x-axis is the distance along the transect, and each series is a date and/or number value (doesn't really matter).
Here ...

**0**

votes

**1**answer

34 views

### Calculate hours for time sheet (difference between time, possibly passing midnight)

I'm trying to help a friend with making him a simple excel template for filling out a time sheet, unfortunately it turned out much harder than i expected a simple time-calculation to be.
What i need ...

**-1**

votes

**1**answer

30 views

### how to find a changing value in a row, and get a value in the same colunm

I am trying to create a quick page to view a schedule from a list of teams and dates and locations.
The format of the dates and locations do not change, however the teams (home and away) do.
So ...

**1**

vote

**1**answer

28 views

### Excel: sort according to example row

I am using Excel 2013 on Windows 7.
I have 2 columns of data like this:
Name Value
aaa 1
bbb 123
ccc 81
... ...
I need to sort this data into specific order that looks like random so I cannot ...

**1**

vote

**2**answers

145 views

### Changing Excel columns & rows , from vertical to horizontal order

Currently I have a list of computers with their hardware specifications in a vertially order, this should be changed to horizontally. What I have is:
| A | B | C |
| PC-NAME | ...

**0**

votes

**0**answers

10 views

### MS Office 2000 Excel files not opening [duplicate]

I have MS Office 2003, Windows 7. When I double click on an xls file Excel opens up but it is just a empty excel program. It is similar to opening up excel and then just closing the book1 that opens ...

**1**

vote

**3**answers

58 views

### Display thousand percent in MS-Excel

I have this number:
0.0065
If I format it as percentage, I obtain:
0.65%
Is there any way to get it as 'thousand percent' symbol?
6.5 ‰

**0**

votes

**0**answers

24 views

### How do I calculate the sum of 2 columns using the max from each row based on a condition? [migrated]

I have data in two columns. I would like to sum the two columns (A and B) based on the max value in each row and a condition (c) indicating if the row should be included in the sum. Example:
A B ...

**0**

votes

**0**answers

24 views

### hide filter in pivot table

I created a pivot table from the following data:
Salesperson | Amount | Include?
John | 100 | Yes
Jane | 350 | Yes
Jim | 200 | No
Jack ...

**1**

vote

**1**answer

33 views

### Macro does not run when opening a File/Workbook from within Excel

I'm new to Macros and VBA in general but my goal is pretty simple I believe. My macro should search an opened Excel document (automatically) and create a MessageBox with a warning if the WEEKNUM() ...

**0**

votes

**0**answers

29 views

### I am using VBA for Excel to automatically generate an email with a link to a specific worksheet and cell

I am using excel to automatically generate and display an email in outlook. This email contains a PDF, a link to a folder containing documents, and a link to the file the email is sent from. So far ...

**1**

vote

**2**answers

43 views

### how can i create alphanumeric user id on excel sheet?

The user id must have first three letters of the user first and last name as well as random number as shown below-
User id Fname Lname Langu
AA_RoeDuT449 Roelof DuToit ...

**0**

votes

**0**answers

13 views

### Compare values in different sheets in excel and add an unexisting

I have an Excel (2013) Workbook with two sheets :
Unsorted List
Calculated List
In the Items list I have an unsorted list of products like this :
I want to apply a formula that will support ...

**0**

votes

**1**answer

24 views

### Filter list with condition and return results as delimited list in a single cell

I need to return all values in column A that match a set criterion in Column B.
The returned values need to be in a single cell in a single formula.
In the attached Sample image, I need a single ...

**1**

vote

**2**answers

26 views

### GPA calculator that discriminates science vs non-science courses

I'm trying to write a GPA calculator that can also discriminate science vs non-science GPAs. One column (A) has class abbreviations (MA=math, etc). So, I want to sum the grade credits (column D) ...

**0**

votes

**1**answer

34 views

### MS Excel 2010 merge two sheets

I have an inventory I do each month and have a fairly simple question but not sure what is the best way to complete this task. I have 3 columns. ItemNumber, ItemName, and TotalQTY. The first sheet is ...

**1**

vote

**2**answers

19 views

### Excell: Which values to increment and which to not in autofill

I am trying to make a word encoder that has a column in which you input letters and a column that will be referenced to in the function that detects the letter and encodes it. this is my function.
...

**0**

votes

**1**answer

31 views

### Dynamically populating a pivot table with multiple worksheets in Excel

I have a workbook that contains individual sheets for each month. Each sheet contains these columns:
Publication Title | # of Downloads | Month | Year
Each worksheet has 200+ entries, where ...

**1**

vote

**2**answers

48 views

### Excel formulas for splitting and combining IF, AND, MIN

I am having some issues with a couple of formulas in excel. I have three rows of data for three people that are splitting the values equally until two of the people meet a max number. then the values ...

**1**

vote

**1**answer

14 views

### Flatten/Concatenate an array to a list for match in excel formula

I have a table of data in excel which has double header rows. I would like to perform an hlookup against this table using a flattened version of the two headers. For example, if my data were like ...

**0**

votes

**1**answer

22 views

### Is it possible to use index and match while adding values? [duplicate]

I'm using this formula in my main worksheet in cell N3:
=IFERROR(INDEX(Totals!M$3:M$33,MATCH($B3,Totals!$K$3:$K$33,0)),0)
Details:
$B3 lists first/last names on main worksheet.
Totals!$K$3:$K$33 ...

**0**

votes

**0**answers

14 views

### How do I add data into combo box using vba?

I want to add unique data (From MainMenuData worksheet in same workbook) into ActiveX combo box placed on sheet1. Changed ComboBox Name from Properties to ZoneDropDown. Wrote following code on ...

**1**

vote

**2**answers

21 views

### Adding multiple numbers to existing data

What if I wanted to add multiple numbers in different cells at the same time for example:
Each number represents a cell
5 5 5 5 5 5 5 5
I would then like to add the below in one easy ...

**0**

votes

**1**answer

22 views

### Excel, count characters except a string

I'm using Excel 2013. Basically I'm trying to count the number of characters within a cell, but if the cell contains a specified string to ignore that string but count the rest.
Looking at the ...

**4**

votes

**2**answers

789 views

### Excel “And” and “Or” Command

I have taken notice that the "And" and "Or" command is not consistently give the correct answer.
1) "And" formula =if(And(B2,C2>3), "Yes", "No")
input Cell B2=4 and Cell C2=3, yield answer "No"
...

**1**

vote

**1**answer

33 views

### Parse Excel to xml using VBA

I have VBA code that wirtes an Excel table to an xml file (actually writing the xml file line by line, tags equal column headers).
This is the code, it is quite straight forward.
Sub ...