Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. If your question is about programming Excel in VBA then also tag it "VBA". If it is about an Excel formula or worksheet function, then also tag it "worksheet-function".

learn more… | top users | synonyms (2)

0
votes
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
0answers
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
2answers
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
1answer
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
0answers
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
0answers
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
1answer
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
2answers
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
1answer
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
2answers
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
1answer
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
3answers
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
0answers
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
0answers
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
2answers
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
2answers
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
1answer
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
0answers
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
1answer
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
0answers
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
3answers
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
1answer
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
1answer
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
1answer
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
2answers
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
0answers
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
3answers
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
0answers
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
0answers
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
1answer
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
0answers
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
2answers
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
0answers
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
1answer
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
2answers
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
1answer
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
2answers
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
1answer
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
2answers
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
1answer
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
1answer
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
0answers
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
2answers
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
1answer
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
2answers
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
1answer
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 ...