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
vote
0answers
11 views

Conditional formatting with several conditions depending on different cells

I currently have a table in excel that looks like . The table shows four projects, each with three stages with each having an expected and actual start date for that stage. I want to create a ...
0
votes
0answers
8 views

Advice making a multi line chart with daily count data

This is what my raw data looks like..... raw data image I would like to use this data to create a chart that display's Install date in the X axis, a daily sum of records for each installed by name in ...
0
votes
1answer
4 views

Excel 2007: View/focus on last rows when opening the workbook

I have about 4700 rows on my sheet. When I open the workbook, it always focuses on the first rows. I want it to focus/view on the last rows of the sheet instead. It doesn't have to select. In fact I ...
0
votes
0answers
8 views

How do I assign a dollar value to a word in a specific cell?

I am trying to assign a dollar value to a cell titled "internal bridge." Cell B4 (Internal Bridge) should equal $500. In cells B5 - B18, I intend to use number values (1-50) to represent the number ...
0
votes
0answers
14 views

Defining a range in excel for index/match

I'm trying to return a "best" value, but there are two criteria for a threading calc. One column has stress, which just has to be higher than a given value, and the other would be where you want the ...
0
votes
0answers
44 views

without iteration condition, =A1+C1 in C1 cell,

I've tried iteration condition, but it is not taking only the 'A1' value, if I put some value in some other cell, C1 is calculating like =A1+C1 in C1 cell,means A1 value is 5, in C1 i put this farmula ...
0
votes
1answer
17 views

How do I return the last word of a string of text?

If any of you have been following the progression of my questions, then this may come as no surprise. Be that as it may, I have to ask it. I really did attempt to find an answer to this online and ...
0
votes
0answers
18 views

How to stop Excel “trying to connect to <my file server>” and make it just save the file?

Client: Excel 2007 on Windows 7. Server: Samba 4.1.17+dfsg-2+deb8u2 on Debian Jessie/AMD64 When opening files from a network location: Excel takes a very long time to start opening the file (...
0
votes
1answer
19 views

How can I remove a cell from a range for a property lookup array

Lets say I have a value, A123456, in a column A, row 1, and i want to check if I have the same value in other rows of the same column, regardless of the length of the values as long as it has the same ...
0
votes
1answer
16 views

How do you return the last letter in a string of text in an adjacent column?

Rather than do 600+ entries manually before seeing if some superuser might be able to answer my question, I'm going straight to "the Oracle" first this time. By the way, @Scott Craner answered my ...
-3
votes
0answers
19 views

please help me to put a formula in this cell?

the calculation in the cell E is based on the net change in F and G. For example "when i enter an amount in the cell F3, then it should add up with the amount entered in the cell D3. and likewise when ...
-1
votes
0answers
14 views

How do I transfer data values from a chart to a table on Excel?

I have data that is listed in a chart, for example Hello1 World2 Biscuit3 I would like to transfer this to a data table, but the numbers follow a specific pattern. For example, the table would be: ...
-3
votes
0answers
23 views

Need a VBA Code for multiple text cell to row in excel

Hi Kindly help me out to resolve this in excel through macro:
0
votes
1answer
16 views

How do I set up a formula that will return a certain value dependent upon a portion of text in a cell?

I've got a column of text. If the text of the cell contains el I want it to return "M" in the adjacent column. If the cell contains la instead, I want it to return "F" in the adjacent column. ...
1
vote
1answer
24 views

Is there any way to separate every four row in a different column in excel?

I want to separate every four row into column. Excel Screenshot Like in screenshot, first 5 row that I bold of A becomes column of C D E F & G I want every 5 row of A becomes column of C D E F &...
0
votes
1answer
8 views

Running Macro disables formula entry

Run a Macro on an Excel 2007 workbook, now formulas no longer work in the modified workbook? I can type a simple (like "=5") in a blank cell and hit enter and what I typed is shown, not the result of ...
2
votes
2answers
36 views

Searching an array from bottom to top

I have a table array $E$14:$G$851. Column E just contains unique identifiers, lets say a/b/c/d etc, column F contains hundreds of numbers all less than or equal to 20 and column G contains the values ...
0
votes
0answers
25 views

How do I add multiple date values?

I already used the function =IF(AG2<(TODAY()+2),"DELIVERY DATE",IF(AG2<(TODAY()-1),"DONE","ON GOING")) but the value of "DONE" is not working. Please help me out. This is the criteria: if ...
0
votes
1answer
21 views

Excel formula to read 2 of 3 cells repeating or not

I am having trouble getting a formula that will work the way I want: IF 2 or 3 of the last 3 cells (A2:A4) were b, AND cell A5 is b, then C5=+, otherwise -. IF 2 or 3 of the last 3 cells (A2:A4) ...
2
votes
1answer
18 views

Is there something about filling Excel spreadsheet cells with CTRL+SHIFT+ENTER that prevents a successful sort?

I have a long list of entries that I want to sort randomly. I highlighted a column, typed in =RAND(), and then pressed CTRL+SHIFT+ENTER, and voilà, my column was filled with random numbers. I then ...
0
votes
0answers
10 views

Why is an embedded object in a hidden cell copied over when I copy/paste only visible cells?

I have embedded pictures in cells in my Excel 2007 workbook. I have already formatted all of them so they "Move and size with cells." The pictures are hidden when I filter in Excel. However, when I ...
0
votes
0answers
17 views

Excel SUMIFS Formula Sequential Date Criteria?

=SUMIFS($I$2:$I$2221,$M$2:$M$2221,"VISA",$B$2:$B$2221,"June 1") This is the formula I am using for a sales analysis worksheet, that takes the clutter from the POS report and breaks it down in a ...
2
votes
1answer
55 views

Macro to autofill columns in Excel

I've recorded a macro in Excel that fills the columns with formulas.  However, it's limited to the range I was using in my test data, i.e., it doesn't fill down to the last row of data when I use a ...
0
votes
1answer
23 views

How can I select the whole string except for the first character from a cell in Excel 2007

I have multiple tables where 1 column contains a string which is a combination of a letter and a number. For example these values can range from B1 to B1000000. My present solution to automatically ...
0
votes
0answers
14 views

Refresh Excel Connection without source being open

Morning all, I have a query regarding refreshing Excel connections. I have a company workbook that has many sheets and is in constant use all day, however I have a connection created to this which ...
0
votes
1answer
49 views

How to change a negative value to a positive number not exceeding 49

Hi I have the following question that I am struggling with solving I have si numbers from a lotto draw to which firstly I would like to subtract each number by 25 and record into cells , therafter if ...
0
votes
4answers
68 views

How can i get one certain row , one line below?

What i mean is that i have an excel doc with 4 rows A B C D 1 Data1 Data2 Data3 Data4 2 Data5 Data6 Data7 Data8 I want every D row data to get on the below line and ...
-1
votes
0answers
33 views

Import images into excel

Import images into excel using empcode to match file name images located in D:\images
0
votes
1answer
20 views

Updating link paths with Word VBA

I have the following links to Excel in a word document: The issue is that when changes are made the document version on both the excel sheet referenced and the word document change. As such I will ...
0
votes
1answer
28 views

How to convert 3 colum in an excel matrix?

I have many data set on 3 column as the tab above and I would like to convert to a like the one in the picture. Is there a function that do this in MS-excel 2007? I think I need to create a ...
0
votes
0answers
13 views

List Sort with New Rows - Excel Macros

I am trying to record a macro that sorts my list, but am currently at a wall - I need this sort to adjust to my list depending on adding/removing rows. My current code scans the list for which cell ...
4
votes
2answers
54 views

How to Use (--) this in Excel Formula

I found (--) this to add criteria in a sum Function, can you please tell me its exact use. And is this function(--) (whatever it is called by) can be used in any other formula?
0
votes
1answer
10 views

Linking Excel Workbooks

I work for a large agency and created a spreadsheet for employees to track time spent throughout the day working on a series of duty assignments. I designed a separate workbook for each employee where ...
0
votes
1answer
21 views

Excel 2007 Custom Data Validation, Excluding characters in large range

Trying to create data validation (absolutely no macros, it is simply not an option), where a user can type in only Basic characters (A-Z,a-z,0-9,-,~,',\,/) So what I tried to do is create a ...
2
votes
1answer
25 views

Counting Divide-by-Zeros

I can easily count number of #N/A's in a column with the array formula: =SUM(--ISNA(A:A)) How would I count the number of #DIV/0!'s in a column ??
0
votes
0answers
35 views

Stumped with how to write Excel formula: How to check if multiple values in a single row are the same in two different sheets?

I'm sorry, I know that title must sound confusing but I'll try to explain it better here. Essentially, I have to check if a row in a Sheet2 has two of the exact same values in another row in Sheet1. ...
0
votes
1answer
14 views

Excel auto Text formatting based on values within a range of cells

Need help finding a way to auto format a text response based on values in another set of cells. There are 3 values in Column B,C, and D and depending on the highest value of the three, the adjacent ...
1
vote
1answer
36 views

Excel replace multiple text options within one cell with other text

How can I replace one set of text options with another? I was thinking that an Index/Match combination might work, but I cant figure it out. Perhaps a VLookup function? For example: My report output ...
0
votes
1answer
38 views

Editing CSV file in Excel always converts number column to scientific notation [duplicate]

I have a CSV file that I'm editing in Excel 2013. In the file there is a column that contains numbers e.g 688087123456789. Everytime I open the CSV file in Excel, it converts the number to scientific ...
1
vote
0answers
28 views

How to add data vertically while xtracting tables from web page to excel

My code Public Sub Raju() Dim alertTime As Date alertTime = Now + TimeValue("0:05:00") ' ' mymacro Macro ' Dim ws As Worksheet Set ws = Worksheets("Sheet1") ...
0
votes
0answers
9 views

Copying Conditional Formatting rule to range of cells and automatically updating the cell references

I wanted to apply Conditional Formatting to range of cells A2:A30 using a formula =Countif(A2:A$30,A2)>1. It works and gave the desired result. However when I go to any cell other than A2 and click ...
0
votes
1answer
12 views

Excel scatter plot with two x series and one y series

My data consists of a y value and the two x values that can be used as inputs to a quadratic equation to give the y value. I'd like to plot them, ideally with separate colours for the positive and ...
-1
votes
1answer
19 views

How do you consolidate “date. Time1 and Time2”? [closed]

How do you consolidate "date. Time1 and Time2" For example: A B C 1 Date Time1 Time2 2 09/04/2016 05:03:15 AM
0
votes
1answer
37 views

Mirroring formulas to multiple sheets in Excel

I have an Excel Workbook with multiple Sheets each using the identical layout, but with different sets of data. From time to time, I need to vary the way the values are calculated, but I don't want ...
1
vote
1answer
43 views

How Can I make an excel column of Hyperlinks open in NON default browser

I have a ms excel 2007 worksheet with a column (A) of hyperlinks using the excel function in this way =HYPERLINK(A2,"url". How Can I make (if this is possible) open all cels on that column in the NON ...
0
votes
0answers
21 views

I am looking to reverse lookup missing numbers from a VLOOKUP in Excel

Hi please let me know if this is a duplicate but I did a brief search and did not find anything that wasn't a ton of code that I couldn't relate back to my spreadsheet. I have excel 2003-2007. I ...
0
votes
1answer
44 views

MS Excel - I wish to count unique values based on a parent column

I am very new to Excel. I need some help in counting unique values in each of three columns (considering them only one at a time) with respect to a parent column (the first one (A) in the image). Can ...
3
votes
1answer
51 views

does Excel copy only visible cells when a filter is enabled

According to MS doc excel 2007 https://support.office.com/en-us/article/Copy-visible-cells-only-6e3a1f01-2884-4332-b262-8b814412847e excel 2013 https://support.office.com/en-ie/article/Copy-and-...
0
votes
2answers
39 views

Apply Custom Number Formatting to Error values

I'm trying to apply a custom number format to cells in Excel 2007 that return an error value. I understand that I can apply custom number formatting to number/text values in the form POSITIVE;...
1
vote
1answer
335 views

Is there an English Office Language Interface Pack?

Located in France, I have only access to a French version of Excel and would like to change it to English for programming purposes. I want to use this model, based partly on Excel VBA code. Currently ...