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
39 views

Copy the content of one cell, and insert within 2 characters, in the middle of a text content from another cell (Excel)

I am trying to batch copy the content of the cells in column A, and insert it within the "><" of the text in the column B. The result should look like the output in column C. Here is an example: I ...
0
votes
0answers
203 views

Return value from table using Multi-dependent drop-down list

I am trying to obtain the value of a column header (or topmost row value for a specific column) based on the selection of properties from 2 drop-down lists. ...
0
votes
1answer
115 views

Hide sheets in shared excel workbook.

I have a shared workbook on which I have hidden some of the worksheets prior to saving. I have closed the workbook. If another user opens the workbook the worksheets I had hidden are visible. If I ...
-1
votes
1answer
48 views

Excel searching column and copying the cell next to it

i need to find the value from column C in the row B, and copy the value from found result in column D. If it's possible with formula and to copy formula to all cells in column D ? without VB? Thanks ...
0
votes
1answer
277 views

Excel 2007 VBA Export range as jpg file is trucating picture

I have a workbook with many different ranges of data with 77 lines or more. I need to copy them and save as JPG files, which will be used by other application. Below is the example of code that I'm ...
0
votes
1answer
25 views

How to match cell to column & return value based on that?

+-------+---+--------------+----+ | A | B | C | D | +-------+---+--------------+----+ | Mark | | Hasan Shahed | 50 | +-------+---+--------------+----+ | Hasan | | Saif Alam | ...
3
votes
1answer
171 views

Excel 2010: Formula for Sum and Return Date

I have a workbook with a Summary sheet and a Data Set sheet with a linked table containing 700k+ records of financial data on investments. (In my particular case, it is real estate properties; but ...
0
votes
0answers
17 views

How do I copy datas with blank/tab into multiple excel cells?

I got a data like: xx5 600 200 xx6 500 100 I want to copy them into multiple excel cells, like: -------------------------------------------------- | xx5 | 600 | ...
0
votes
1answer
240 views

Pie Radar Chart outline series not working

I have been trying to create a Pie Radar Chart as described in answer to this question. Everything works until I get to the section that describes inserting a series to create the chart's outline: ...
-3
votes
1answer
67 views

need vba code to delete all the code after executing all the code

I need a vba code in Excel 2007 which will remove all the vba code after executing all the function. I am drawing an example here: Option Explicit Private Sub Workbook_Open() 'Runs a macro 10 seconds ...
0
votes
1answer
387 views

Microsoft Excel 2007 - Drop down list that grabs multiple columns from another sheet

I've been scouring the internet for this but can't seem to find a solution. Let's say I have 2 Sheets - "Items" and "Inventory". Inside "Items", I have 3 columns: Item Name Item Type Item Cost ...
0
votes
0answers
13 views

How to find which cells in a column have numbers?

I have several name of products in Column A, like this Biscuit Chocolate Hibis400 Cratey Ubbret-131-small Hingley The data runs into hundreds and thousands. IS there a way to quickly identify which ...
0
votes
1answer
271 views

Round Up Date - Require Complete Year

I have a sheet to calculate employees length of service. Now with my current formula =DATEDIF(D2,E2,"y") & " years, " & DATEDIF(D2,E2,"ym") & " months, " & DATEDIF(D2,E2,"md") ...
0
votes
1answer
236 views

When try to open word/excel 2007, I am always getting Microsoft office enterprise 2007 configuration progress pop up. How to get rid of this

I have office 2007 and 2013 in my system. I uninstalled 2013. Now When I try to open word or excel 2007 files, I am always getting installer popup. How to get rid of this pop up once for all ...
0
votes
0answers
25 views

How to search comma separated tags in Excel and get results in a column. [duplicate]

I'm trying to tag items in a spreadsheet, and search through them, in a similar way to Nusantara How to Label / Tag Items in a Spreadsheet I've followed Excellll's brilliant advice and managed to get ...
0
votes
1answer
135 views

Excel: find the cell that another formula found its “answer” in

I made a formula that searches an array to return a value, and now I want excel to "show its work" and tell me in which cell it found that value. I've been fighting with MATCH and ADDRESS but so far ...
0
votes
0answers
64 views

Is it possible to convert one set of data related to static date ranges to date ranges that are dynamic?

I'm looking at converting P&L financial data from a company fiscal year to year post close of an acquisition assuming a dynamic post close date. I have 10 fiscal year columns, for example the ...
0
votes
1answer
241 views

Excel Help: Search Column A, Sheet 1 for same value in Column A, Sheet 2, return value of Column B, same row in Sheet 2 [closed]

I'm surprised I couldn't find the answer on Google, maybe I am being silly. I want to perform this function:- I have two sheets in Excel, lets say they are Sheet 1 and Sheet 2 In Column A, Sheet 1 ...
-2
votes
1answer
26 views

Use of conditional formating using formulas [closed]

In cell M100; I would like to color the cell GREEN if c100-f100+g100 = j100toj109. If they are not equal color cell RED
0
votes
1answer
25 views

Excel 07 - declaring and sorting chunks of arbitrary size

Let's say I have a list of Abbreviations: As you can see, the only layout "rule" is a blank line between entries. I should now like to sort them by their abbreviation: Using Excel07 and having ...
0
votes
1answer
149 views

Excel formula for collapsing adjacent rows with a sum

I have a spreadsheet with values like so: blah 1 12 2 12 3 12 foo 1 6 bar 1 2 foo 1 6 2 5 Numbers in the middle column range from 1 to 8; ...
0
votes
0answers
21 views

Excel 2007 - Links on Network File Work, Then Don't

We have a spreadsheet in a networked folder containing links to other spreadsheets in that same folder. When first established the links are fine, SERVER/SHARED FOLDER/SUBFOLDER1/SUBFOLDER2/SOURCE ...
0
votes
1answer
115 views

How to require a cell input if another cell has a value

I'm trying to edit the VBA for one of my workbooks so that If there is a value in column A, then a value for column C is required or else the file won't save, but i'm having some trouble with this. I ...
0
votes
0answers
63 views

Creating automated Microsoft Excel filtered list

I have the following situation in one of my Excel sheets: I have a table with some values, particularly "date", "stock" and "cost" among other data. The table may contain values from various ...
0
votes
1answer
88 views

How can I sort data that is organized in 4-row chunks?

I have an Excel document with six columns and 57,000 total rows. Each record comprises four rows, that is, each set of four rows goes together. How can I sort this data by one field while keeping the ...
0
votes
2answers
1k views

How to convert a string to a binary, then hex, value?

In one column I have a bitstring encoded as a string type. In a different column I wish to have the same bits (potentially starting with a leading 0), but as a binary value type. Ultimately, I want ...
1
vote
1answer
69 views

Excel - Reuse a trend line to apply to other data

I've obtained a trend line from a particular set of data. What I'd like to do now is to reuse this trend line to predict values from a given pair (x,y) of coordinates. To put it another way, I have ...
0
votes
0answers
27 views

How to Copy/Paste Link data conditionally (or achieve the same results), based on entries from one worksheet to the next within Excel 2007?

I am attempting to create a job log in Excel 2007 with two separate worksheets: Potential Opportunities (source sheet), and Interested Employers (destination sheet). These two sheets have the ...
1
vote
1answer
749 views

Excel 2007 or 2010 copy/paste without merging cells & with shift all down

Let say I have an excel sheet with structure like I select a few cells (at one column) and click Ctrl+C. After that I want to paste it. I select one cell(B116): And click Ctrl+V. It gives me ...
0
votes
3answers
178 views

How to dynamically populate a filter list with “first match” on a row, using excel 2007

The image is an example of what I am working with. I am trying to write a formula in my leftmost column, just under the listbox cell that you can see, which will find a string/value match in that ...
1
vote
0answers
16 views

Embed an dotm file into an Excel document

I have a dotm file( macro enabled word template). I want to insert it into an Excel file and I want to open it by the clicking of a command button in Excel form. The problem is, when I open this dotm ...
4
votes
1answer
2k views

Add/Subtract button Excel VBA

Here is an example of my project in this picture I like collecting, so I am making an inventory sheet in Excel. I want to make a way that I can click a button and it affects the next, or previous ...
0
votes
1answer
172 views

Excel - Sum certain range from pivot table

I have an excel pivot table that looks like the following: Is there any way I can create a formula that will calculate the sales$ for a particular product at a particular store for a particular ...
1
vote
1answer
427 views

Sorting Dates in Excel By Month

My boss has given me a job in which he has given me the names of customers and their wives who has bought our products from 2 to 3 regional offices. My boss wants me to format all this data into one ...
0
votes
0answers
59 views

Cannot “save as” file on Microsoft Excel and Word 2007 running on Vista Home Premium edition

I have Excel and Word 2007 running on Vista home premium edition. After working on a new file and try to "save as" just before naming the file, a window pops up 2 dialog messages "Search online to ...
0
votes
2answers
3k views

How to automatically update values referenced from one sheet to another in excel

Here is my problem . I have 2 to 3 worksheets and I need to make a master worksheet . The 2 3 worksheets are containing the sales made in the day and the customer name . the problem is that new ...
2
votes
1answer
1k views

How do I filter on bold, struck through or italic text in Excel 2007?

Is it possible to filter an Excel column based on the format of the text, such as whether it's bold, italic or struck through?
0
votes
2answers
217 views

Is there one simple formula for Excel that can identify a string contain non-ASCII Characters?

I know that using the clean formula, I can clean up some of the non-ASCII characters (such as additional non-printable ASCII control characters #0 through to #31, #129, #141, #143, #144, and #157 ...
0
votes
1answer
54 views

Why is Excel truncating my normal numbers?

I open MS Excel 2007 and I write: 50 and Excel changes that into 0.5 I write 500 and excel changes that into 5 I write 5000 and excel changes that into 50 and so on and so on. It is driving me ...
-1
votes
1answer
86 views

How to split up above single cell Address value into multiple cell value through macro

How to split up the below single cell value into multiple cell value through macro ? So, this... A1 = MISS FirstName LastName***95*SPECIAL ROAD**LONDON SW92**SW929AB ...should split as below, B1 ...
0
votes
1answer
32 views

Automatically place numbers in cell Microsoft Office Excel 2007

| | A | B | C | D | |---|--------|-----------|-----------|-----------| | 1 | Number | First | Second | Third | ...
0
votes
2answers
70 views

Excel 2007 IF AND function calculation not copying across

I'm using an IF AND function, which is: ...
1
vote
1answer
608 views

Can the data validation list width be controlled in Excel 2007 and greater?

In Excel 2007, I can add data validation to a cell, and supply a list of allowed values. However, experimentation suggests that the data validation drop-down list will never display at a smaller ...
1
vote
1answer
28 views

How to generate a series of growing values and timestamps for cell that updates automatically?

I have a cell A1 which references a sheet that gets updated by an external source (database). My goal is to record a log that traces the growing value of cell A1 at each different time the data is ...
0
votes
1answer
48 views

Can I create a cell with enumerated values in a csv file

Can I create a cell with enumerated values in a csv file? For example, I want a cell that can only get the values: a) "value1" b) "value2" c) "value3" Is this possible? PS: I have used this ...
0
votes
2answers
477 views

Nneed to calculate average of NON sequential multiple cells & I want to exclude values = 0 or Empty Cell with AVERAGEIF

Nneed to calculate average of NON sequential multiple cells and I want to exclude values = 0 or Empty Cell with AVERAGEIFS. There is a mistake in my formula but I can't find a way to have it since ...
1
vote
1answer
48 views

Excel not accessible after import of data through script [closed]

I am using a python script to open up an excel workbook (by creating a pointer to it). After I put some data in the excel and script execution is completed, I tried to access(see note below ) the ...
0
votes
1answer
142 views

VBA Code De-bugging in 2010 excel

Looking for some help in debugging some old VBA/Macro code to work in the newer version of MS Excel 2010. The macro in question is the "Material Rollup" function. The purpose of the macro is after ...
0
votes
0answers
286 views

Can't Find/Find&Replace “Purple, Accent 4, Lighter 40%”, all other colors work - Excel 2007

I have a several large Excel tables that I am managing for my current project. Whenever a metric or value in the table changes, I indicate the change by changing the background color of the cell for ...
0
votes
1answer
28 views

Sorting and showing the most repeated row (value)

I have a sheet containing over 200k+ rows with values like this, 10.10.10.10 11.11.11.11 12.12.12.12 10.10.10.10 10.10.10.10 I want to be able to show the most repeated row at the top or extract it ...