Microsoft Office Excel is a spreadsheet application written and distributed by Microsoft. Use this tag for problems specific to Excel 2007 for Windows.

learn more… | top users | synonyms (1)

0
votes
1answer
60 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
1answer
57 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
2answers
49 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
1answer
96 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
0answers
40 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
1answer
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
0answers
26 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
4answers
206 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
0answers
34 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
1answer
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
2answers
93 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
2answers
647 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
1answer
40 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
2answers
60 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
2answers
54 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
1answer
70 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
1answer
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 ...
0
votes
1answer
25 views

Looking to total cells, but leave some blank in between

I've written a worksheet for selling work. I have one column "C" for the cost, and the column next to it "D" for a subtotal. Depending on the work to be performed, not all rows will have values to ...
0
votes
0answers
11 views

I'm trying this code to create a combobox to list all sheets when start a workbook on Exc 2007. But it's not working.Thanks in advance

Private Sub Workbook_Open() Dim oSheet As Excel.Worksheet Dim oCmbBox As MSForms.ComboBox Set oCmbBox = ActiveWorkbook.Sheets(1).cmbSheet oCmbBox.Clear For Each oSheet In ActiveWorkbook.Sheets ...
0
votes
1answer
20 views

How do I assign a key based on count of available keys and indicator value?

I need some help writing a formula that does the following: Looks to see if an indicator=1 If indicator=1, lookup the key value based on the number available for that particular key Keep looking up ...
1
vote
1answer
23 views

How can I return a value of 1 or 0 depending on conditions of other cells?

I want to return a value of 1 or 0 in cell H1 depending on the following conditions being met - E3>=60 F3>=60 G3>=6 I had used =IF(E3>=60 AND F3>=60 AND G3>=6, [1], [0]) - but it ...
0
votes
1answer
69 views

How can I make Excel conditionally highlight cells based on the contents of cells? [duplicate]

I have a few things that I would like to do on Excel: How do you highlight a row [A-U] if only the first cell A has had text entered in it? When you enter text in cell A cells B-U have a yellow ...
0
votes
0answers
81 views

Color scale based on multiple cells

I have a data sheet with min-max possible values adjacent to each other. I'd like to color the cells based on how close they are to matching (ie the color should be based on their difference) I ...
0
votes
1answer
47 views

How to merge to excel column into one from two sheets in third sheet?

As mentioned in image from the link here How to merge two Excel columns into one? and the solutionis from the same sheet. I am looking for the merging of column A in 'sheet 1' and column A in 'sheet ...
0
votes
2answers
168 views

How to plot positive and negative values on both sides of the axis in Excel?

Could anyone please tell me how is it possible to plot a graph in Excel or LibreOffice in which different values for a single variable can be plotted on both sides of X-axis but in a way that both ...
1
vote
1answer
38 views

Excel on 2 worksheets

I have done this before but have forgotten the steps. Worksheet 1: Data: all Customers, with their sales entries for the month, with repeat on different days. Worksheet 2: I have classified the ...
0
votes
1answer
40 views

Excel formula - Return value from lower row

I'm looking for a way to search for a value in a single column and return a value in that same column two below it. Example: A1: Apples A2: Bananas A3: Oranges A4: Pears If I search for ...
0
votes
1answer
108 views

Create CSV file from Excel with delimiter other than comma?

Is there a way to create a CSV file from an Excel one, but with a delimiter other than comma? I tried changing Windows parameters. In Windows Control Panel -> Click, Language & Region -> formats ...
1
vote
0answers
15 views

excel 2007 MS Query

I have created a spread sheet using MS query. I have added several columns to the rows of data so there can be some manually entered notes at the end of each row. The problem is when I refresh the ...
0
votes
1answer
78 views

how to create persistent random numbers &letters in excel?

Below is link for example sheets https://docs.google.com/spreadsheets/d/1D-D29csRGAAZl_h7fyMwLJ6am0FpZAtCZ5r0XlmQVqo/edit?usp=sharing. This is a live spreadsheet, which can't be pasted in this ...
-1
votes
1answer
37 views

Pad a number with prefix zeros no and decimal place in Excel?

Is there a way of formatting cells to: Add zeros to fill entered numbers that fall short of the required amount. Not round up/down decimal places but display as an entered number. For example, if ...
0
votes
1answer
153 views

Copy Active Cell Comment in Excel into a new word file

i do not know much about Macros, is it possible someone could help me out. I have a simple excel file with names of Clients that have a lot of comments on each name. is there a fast way other than ...
0
votes
1answer
50 views

Excel Data Validation List as Formula in “Source” Field?

I am using Excel 2007. Is it possible to enter a short list of allowed values directly into the "Source" field in the Data Validation -->Settings Tab? If I want to allow a cell to have one of two ...
0
votes
1answer
33 views

How to Lock or password protected specific cell in excel 2010

How can I Lock a specific cell in a sheet of excel 2010 so that any one can not change or input anything in that cell?
0
votes
1answer
233 views

How to keep Excel line graph from incorporating dates that are not in my range

I have created a line graph based on dates and the values associated with those dates. However, it is inserting dates into a graph which I do not want. The dates run in chronological order, I only ...
-1
votes
2answers
59 views

formula to work percentage [closed]

I am trying to find a formula that will perform a specific function. I have two values, for example 15 and 50. 15 (b6) is the number of questions I have correct and 50 (c6) is the total number of ...
0
votes
0answers
43 views

How to optimize Excel 2007 cell width for printing?

I have an Excel spreadsheet with 5 columns. Two columns have cells which contain very little text (e.g., dates or prices) while three columns have cells which can sometimes contain several rows of ...
1
vote
0answers
196 views

Percentage increase between two data points - bar chart / Excel

Please forgive me but I simply do not know how to include these arrow lines displaying percentage increase/decrease between two points on a bar chart in excel. I wish to replicate what is showing in ...
2
votes
2answers
53 views

Excel formula to populate from one column only if another is empty?

I want column U to equal the value of column P. However, if column P says #N/A N/A then I want it to populate from column L instead. Is there a formula that will do this for me? Sorry if I've not ...
0
votes
1answer
25 views

What is the unit of row height in Microsoft Excel?

In Microsoft Excel, Row Height is set as 15. What is the unit of 15? Is it inches, centimeters, etc.? I am trying to compare the height of the rows to a sheet of paper before I print it out.
0
votes
0answers
28 views

Auto create folders using Excel field entries (using a template folder)

I need to generate folders for new job numbers that are generated in excel. Every time the excel sheet is updated with a new job number I need to generate a folder in a set location with the folder ...
0
votes
0answers
80 views

Using icon sets comparing values in two cells (excel 2007)

I am trying to place icon sets in cels with their value, comparing that value to the same data of last month. So for example I have column A contains this months rank (0-10) column B contains last ...
-1
votes
3answers
76 views

excel if statement 0 value

I am creating an if statement which helps calculate the difference between two cells and displays the difference as a percentage- here's an example of the code I am using - =IF(D19=E19,"Values are ...
0
votes
0answers
109 views

Auto propagation of formulas down the columns for each new row

How to propagate those formulas down the respective colums for every new row automatically? There is an webhook which creates new rows with data with those columns (A1, X2, Y2) empty, and I would need ...
0
votes
1answer
57 views

Auto sequential numbering based on cell criteria with two numbering sequences and ability to ignore duplicates

In the example below the numbering in column A skips rows that have the word "TOTAL" in column C but picks right up again in the next rows. The rows with the word "TOTAL" in column C have their own ...
0
votes
2answers
29 views

Excel Search from one sheet to another

I need some assistance with a search - I need to input a postal code in Cell A and if it matches a postal code I have in another tab it will return the Suburb! So - Sheet 1 input Cell A1 will be ...
0
votes
1answer
38 views

how to make a Copy formula, Value from A3 to B3 if z3 = csl

Is it possible to have a formula that can copy text value from A3 drop down list of cars, paste the text Value into B3, once i put CSl into Z3. then i can delete A3 but still have the text Value in ...
0
votes
0answers
265 views

Trying to get VLOOKUP to get data from a table array on another workbook where the worksheet name is variable

I currently pull data in from 4 workbooks using the INDIRECT function, the formula is as follows, =INDIRECT("'[" & $AE$1 & "]" & $AA$13 &"'!" & $AI$1) $AE$1 contains the workbook ...
-1
votes
2answers
42 views

Is there a way i can copy this macro i made but have it change for the next tickbox

I have made this macro to Select cell A3 copy the value and paste it into cell Y3. it then clears cell A3 as that's a dropdown box, by doing this the dropdown option can be now selected in A4. ...
1
vote
1answer
31 views

can someone help me with my Formula Excel need it show blank

=IF(NOW()-B4>=15,"OK","Warning - Time to Renew") that is the formula, but can it stay Blank until a date is put into cell B4 thanks