**0**

votes

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**3**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**2**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

32 views

### Automatically place numbers in cell Microsoft Office Excel 2007

| | A | B | C | D |
|---|--------|-----------|-----------|-----------|
| 1 | Number | First | Second | Third |
...

**0**

votes

**2**answers

70 views

### Excel 2007 IF AND function calculation not copying across

I'm using an IF AND function, which is:
...

**1**

vote

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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 ...