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)

-1
votes
2answers
20 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
0answers
9 views

Which formula can deliver Cell References?

Is there any formula that can deliver Cell References instead of cell value? I know that Index can deliver cell reference but what about other formula?
-1
votes
1answer
18 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
1answer
8 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
2answers
19 views

Array formula, slowly work on Excel [on hold]

Does the array formula make excel to run slowly? i'm talking about a range that contain 1000 raws and 10 columns.
0
votes
0answers
18 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 ...
-1
votes
1answer
22 views

Merge Two Dynamic Tables in One Table [on hold]

I have try to merge/combine two tables but I have always fail. How can I merge/combine two dynamic tables in one table
0
votes
0answers
52 views

Selecting random entries from lists in Excel with VBA

In Column A, I have n number of names. In Column B, I have n number of Order numbers for each name. In one cell I will be inputting the number of orders I want to pick randomly. Once I input the ...
0
votes
0answers
15 views

How to perform calculations based on multiple conditions involving current cell cell color and the value or color of other cells [closed]

I have a color coded spreadsheet for rental properties that I downloaded from a software program. The spreadsheet basically has 3 colors, green means the property is booked, white means it is ...
-1
votes
0answers
24 views

HyperLink to Another WorkBook based on a cell value [closed]

I have two Workbooks. WorkBookA.Sheet1 and WorkBookB.Sheet1 In WorkBookA.Sheet1 in cell S1 I have the value of US1000. I would like to hyperlink to the cell containing the Value of US1000 found ...
0
votes
1answer
16 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
1answer
25 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
1answer
9 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
1answer
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
0answers
16 views

Scores results needs updating as you type in the answer- excel lookup or similar [closed]

I have a two tables the first is a table where results get typed into Table Name Rounds 1 2 3 4 5 6 7 8 9 10 bonus Round played ...
0
votes
3answers
27 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
0answers
14 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
1answer
25 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
1answer
27 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
34 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 ...
-2
votes
0answers
17 views

Excel 2007 VBA help requested for counting Yes/No

I hope someone can help me with this problem I have? I have a text files that contain multiple columns. Two of the columns I have analyse the results of. My issue is that these two columns vary in ...
1
vote
2answers
20 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
47 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
27 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 ...
-1
votes
0answers
38 views

Identifying and highlighting non-matching text across 2 columns

Hope you can help a first time poster (self taught at Excel). I am working in Excel 2007 and have data in 2 columns (approx. 70000 rows) which contains details of 500 current & historical: ...
0
votes
0answers
16 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
65 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
26 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 ...
0
votes
1answer
39 views

Drag a forumla, so that it increases by 17 each time

I have the following formula on the second sheet of my workbook. On my 'output' page, I want to display every 17th cell of the first sheet. However when I drag the formula down, it goes up in 2's. Any ...
1
vote
2answers
45 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
85 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
35 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 ...
-1
votes
2answers
37 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
43 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 ...
-4
votes
1answer
53 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
24 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
10 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
15 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
50 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
41 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
32 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
60 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
27 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
59 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
46 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 ...