**0**

votes

**0**answers

4 views

### Tex-style keyboard shortcuts for inserting symbols to MS Excel and Word documents

I've used Latex before in Linux and I loved it. My favourite thing about it was the reliance on the keyboard. For example, if I wanted to insert a 'sigma' symbol, I would simply type '\sigma' and when ...

**1**

vote

**2**answers

12 views

### Run-time error '1004';

I was trying to copy the formula from N39 up to the last row but I'm always getting a Run-time error '1004' refer to this line:
n.formula = ...

**1**

vote

**0**answers

9 views

### Filtering values on Excel Pivot Chart

I'm importing data into Excel Pivot Chart from SQL Server. I'm trying to filter out Values (decimal type on SQL) below a certain threshold.
For this, I click PivotChart filter and see that filter may ...

**0**

votes

**1**answer

32 views

### How to increase the excel value 1 after to leave the few cells

I enter the following data on a sheet:
Roll-No:- 801
Maximum Marks
20
20
20
20
20
20
Sig. of Class
...

**0**

votes

**0**answers

19 views

### Excel formulae to select cell and cell header

I have a spreadsheet of student data. I want to be able to look up a student and return the grades for the students with the subject header. Students do not take all the subjects.
Name Maths ...

**1**

vote

**1**answer

20 views

### In Excel, populate array based on table with value (and coordinates for desired array cell). All array cells are populated (default to be zero)

I am reasonably good with Excel but a near novice at VBA. I have a three column table. Column A & B have coordinates for an array, with column C having the value to be placed as defined by the ...

**1**

vote

**1**answer

31 views

### 'IF" Formula in Excel with additional conditions

I am working on a template which calculates the cost/price of a cabinet and I'm stuck at a certain point. There are 3 types of cabinets and there is a condition where a particular cost is applied to ...

**0**

votes

**0**answers

21 views

### Error when running a VBA in Excel

I am trying to merge 150.000 different .xls files into one only one master sheet. I have done this many times before but I am suddenly receiving a error in the middle of the process.
Here is the VBA ...

**1**

vote

**2**answers

20 views

### How do I Calculate Variance with Missing Values coded as -99?

I am trying to calculate individuals' variances on multiple measures, however, if they skip a question it is coded as -99. I would like my formula to calculate the variance for these measures while ...

**0**

votes

**1**answer

23 views

### Formula for COUNTIFS excluding another column

I'm trying but failing to work out a formula in Excel 2007. I have an large area of data that isn't in a table format. The main columns I care about are: chapter title (text), number of tasks ...

**1**

vote

**2**answers

59 views

### Need an Excel Macro to sum a variable length range

I am trying to create a Macro that is able to recognize how many rows have values above it and only sum that range. If you look at the attached image, I need to be able to click in cells B4, B10, and ...

**0**

votes

**0**answers

59 views

### Excel 2010 shared workbook - image buttons disabled

I have several Excel workbooks which were originally created in a 2007 version.
They are shared workbooks, and contain some VBA code, and are protected to prevent users from changing certain content.
...

**0**

votes

**1**answer

19 views

### How to trigger a letter in a cell when something is put in another cell

Example: when I enter 24 in A1, I would like the letter "x" to appear in B1. I hope this makes sense. I don't know a lot about macros or would a simple formula work?

**-1**

votes

**0**answers

9 views

### Excel file unlocking in another PC (2010 to 2007)

I have locked an excel file in 2010 version, I am unable to open same file in excel 2007 version.
File unlock option not coming to enter password.
Pls help me open the file

**0**

votes

**2**answers

29 views

### In Excel, how do I get a list of cells to display based on an if function?

I have a list of quantities with a description column. It's counting doors based on size. I'd like to output a list (preferably separated by commas) of the description numbers with applicable numbers. ...

**0**

votes

**1**answer

38 views

### How do you plot time on the X axis in excel?

I need to plot the decay of my phone's battery against time over night. My starting time is 23:17:47 and my ending one is 07:05:49. I don't have any issue in changing the time format in the current ...

**0**

votes

**1**answer

19 views

### excel 2007 updating new adjacent cell value when reference cell i s updated

I have to copy or update cell value to new adjacent cell every time when reference cell value is updated.
I have Cell A1 with some formula, which updates it value frequently. what i need to do is, ...

**1**

vote

**1**answer

43 views

### VBA - Populate cell if adjacent cell is not empty

I have created a macro that opens and edits excel workbooks for me.
Firstly, it adds a new column A and then changes the title for A1, B1, C1, D1.
After this, I want to create some sort of formula ...

**4**

votes

**1**answer

33 views

### Formula bar view changes when document is saved and reopened

I have an Excel 2007 document with a lot of formulas of the format:
SUMIFS(view1[COLUMN1],view1[COLUMN2],$C13,view1[COLUMN3],I$10)
but when I save the sheet and reopen it each formula is changed to ...

**0**

votes

**1**answer

18 views

### How do I replace one argument in each formula in a column of formulas?

I have a column of formulas like this:
=VLOOKUP($C3,Sheet4!$A$1:$H$50,7,0)
picking up the details in column 7, as you can see. But I have now removed two columns from sheet 4 and the pertinent ...

**0**

votes

**1**answer

32 views

### How to preserve custom number formatting after closing a workbook?

I have created a custom format ##,##0.0,,, CTRL+J %% in Excel 2010 to display
10000 as 0.1
100000 as 1.0
1000000 as 10.0
10000000 as 100.0
100000000 as 1,000.0
and so forth.
The problem I am facing ...

**0**

votes

**1**answer

28 views

### How to use =sum function properly in excel 2007?

In the above picture, for the column G7, I wan sum of D7, E7, F7. So, I am using =sum(D7:F7), but excel is showing error for the formula by highlighting a green flag. If I ask it to correct the ...

**-1**

votes

**2**answers

31 views

### seperate text to columns in excel

How can you separate text into columns from right to left? My data has an inconsistent number of spaces per row, e.g.:
Hernandez Landscaping Gus Hernandez 1 Neurys Lane Newark, DE 19702
Hershey's ...

**-1**

votes

**1**answer

22 views

### Excel Files Temporary Exist?

I need to find out where an Excel workbook exists BEFORE it is ever saved? I've searched for it using the time and date of creation but wondering if creation really means first save? Appreciate the ...

**2**

votes

**1**answer

47 views

### Restrict paste into dropdown cells in excel

I have one excel sheet which contains many dropdown columns. Lets say one column has Test1, Test2, and Test3 as dropdown option values. Cells under this column should not accept the values other than ...

**0**

votes

**0**answers

26 views

### Formula to search two columns of a database and return value from different cell in the matching row

I am designing a spreadsheet for scheduling appointments. On one sheet I have all the data but the dates and times are not in chronological order. I am having trouble writing a formula that will ...

**0**

votes

**1**answer

18 views

### Excel formatting: how to format time periods?

I would like to format a time period like:
10:00 - 16:00
How do I?
And can I do it without dates?

**0**

votes

**1**answer

40 views

### In excel shared workbook can you insert data and not replace on conflict?

I have 2 users that asked for a shared excel workbook a while back.
Now after the holidays they complain that the workbook creates conflicts and that this issue never happened before. The file just ...

**0**

votes

**1**answer

12 views

### Conditional formatting, one Column based on another

Cells in column A will contain dates. There will be dates in column B as well. I need the cells in column B to turn red if the date is after that of column A.

**0**

votes

**1**answer

22 views

### Filter a pivot table based on the values in specific columns

I have a pivot table where there are multiple column labels:
group
subgroup
subsubgroup
status
The last label, status, has only two possible values, ACTIVE and DORMANT. I need to show only those ...

**0**

votes

**3**answers

32 views

### Excel pivot and chart - hiding field from the chart

Hi have this pivot table
the pivot table is basically as follows
Project1 - 01/01/2010 | some data
Project2 - 01/06/2010 | some data
Project3 - 01/05/2010 | some data
Project4 - 01/04/2010 | some ...

**0**

votes

**0**answers

18 views

### Excel 2007 freezes hangs when I enter an email address

I don't know how this started. But anytime I enter an email address, excel freezes. It never responds no matter what option I choose.
I have tried it with one cell and nothing else. I have tried it in ...

**1**

vote

**1**answer

27 views

### How to count number of unique buyers in excel? [closed]

I am creating a workbook for sold items of my company. and I have a list of items in column O of one of my sheets.
now I want excel to count the number of total buyers and number of unique buyers.
I ...

**0**

votes

**1**answer

36 views

### Double click on one cell to change text bold and font color of another cell on the same row

I have some code written that was given to me by another user, Twisty (who I seam unable to reply to in the page that was used), which is amazing and what I needed. However, I need it to do a little ...

**1**

vote

**1**answer

41 views

### How to return a value from a range if cell contains that value

I have a list of Names (First and Surname) in A:A. I also have a range called 'Surnames'. How can I apply a formula so that B:B returns the surname only of A:A if that name is found in the range ...

**1**

vote

**2**answers

26 views

### When I copy table data into excel, it ONLY pastes it into column A! How to fix this?

If I use the following link:
http://web.utk.edu/~dhouston/excel/exam1.pdf
to copy the table and paste it into excel, it will only paste the values into one long column in Column A (and each row has ...

**1**

vote

**1**answer

72 views

### excel vba userform/button coding

I have created a workbook in Excel. To navigate I have inserted a userform. I have code which takes me to a spreadsheet once a button is clicked on the userform.
Now I would like a button on the ...

**0**

votes

**0**answers

33 views

### Excel error – command sending fails

Everytime I double click .xls file I get error window: "There was a problem sending the command to the program". There is no problem if I open the file by “File-Open” command..
I tried to copy and ...

**1**

vote

**1**answer

19 views

### Hide a number in excel 2007 spreadsheet

I am using excel for a mileage log. I want to be able to hide the "Daily Accumulated Odometer" number if there were no kilometers put on that day but still need that number to add to the next time i ...

**0**

votes

**0**answers

21 views

### How to have excel 2007 userform stay on top of all other windows

The title says it all really. I have a modeless form generated in excel 2007 that'd ideally stay on top of all other windows (not just excel).
I know other applications can set this, but I'm unsure ...

**2**

votes

**4**answers

108 views

### Using COUNTIF in Excel to count number of “Greater than” values in an array of values

So here is my situation. I'm a principal creating a tracker for my teachers to use to track student growth on assessments. In the current tracker it is set up like this:
% of ...

**0**

votes

**0**answers

30 views

### Sharepoint Excel file synchronization

I recently found a problem with Sharepoint and Excel with concurrent changes:
Person A created an Excel file with, let say, 2k inputs and uploaded it to Sharepoint with website
Person B did not open ...

**1**

vote

**1**answer

52 views

### Drag a formula, so that it increases by 17 each time

I have the following formulas on the third sheet of my workbook. They are simply cell references to the first sheet; on my 'output' page, I want to display every 17th cell of the 'input' sheet. ...

**1**

vote

**2**answers

65 views

### How can I make a Msgbox pop up over other application?

I have an Excel macro that deals with thousands of lines in several tables and do some copy/paste/analyze/combine... operations. it takes almost 10minutes to run it fully.
I added a MsgBox "Job Done" ...

**2**

votes

**2**answers

262 views

### Add button to copy Excel rows

I want to add a button on a row in a spreadsheet that copies the contents from one cell to another if and when I click the button. I already have found the code to do this, however, I want to be able ...

**0**

votes

**1**answer

37 views

### Search given value in table and return value from first row

In this scenario I can see that the last time Mickey appears on the rota is 06/01/2015 and say Sue last appears on 10/01/2015.
Is there a formula that can automatically collate that information for ...

**0**

votes

**2**answers

45 views

### Formula to extract the string between the Nth square brackets

Cell A1, A2, A3, etc contain strings similar to the following...
1 x Product A [SG014] 1 x Product B [SG026] 1 x Product C [SG023]
Each cell in column A could be a string of up to 20 different ...

**1**

vote

**2**answers

49 views

### How do I identify duplicate rows in an Excel cell?

I have an excel file with thousands of rows of contact info.
I need to get a list of all the rows that have duplicate first and last names.
I have been able to use conditional formatting to ...

**-5**

votes

**1**answer

64 views

### Formula to find the upper case in the sentence as true [closed]

i have one worksheet which has a sentence in-between uppercase words, i want to know which cells has a uppercase word in the sentence. Please someone help me out with the right formula to find.
I ...

**0**

votes

**1**answer

19 views

### Conditional formatting issue in 2007 version

In excel 2003,when i select range of cells in a column and goto conditional formatting and given a formula that checks cell value in a given range.(cell address i gave as first cell address).
After ...