**-1**

votes

**2**answers

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

**0**

votes

**1**answer

267 views

### cell format excel number to text

I have a file with 4 columns and over 7000 rows. The columns are formatted as Number or Geral.
But I'm using a plugging for php (SimpleXLSX) to read the xlsx file and create queries to insert into a ...

**1**

vote

**1**answer

6k views

### Linking dropdown lists

I would want to link a drop-down list to the values of an adjacent cell. Let say, we have two cells A2 and B2. A2 is a drop-down list with values: Agric, school, sme and housing, while B2, which is ...

**1**

vote

**2**answers

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

**1**

vote

**5**answers

17k views

### Sum if ONLY all the cells have a value?

I need to sum 9 cells of data, each one on a separate sheet, but always in the same location. I only want a figure returned when all the cells have data, even if it's a 0. But, if one of the cells is ...

**0**

votes

**1**answer

9k views

### Select Multiple Items from Excel Data Validation List

How can I set up the ability to chose more than one option for a data validation list and list them in one cell? So I have a validation list of A B C D. I want to chose A C D and have those three ...

**-4**

votes

**1**answer

41 views

### Formula to find the upper case in the sentence as true [on hold]

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

**2**answers

7k views

### Is it possible to create a broken X axis in Excel 2007?

I'm trying to find a solution to a problem that I have with my data.
In my data series, I have Temp over Time plotted on a scatter graph in excel. The data plots a period of around a week in the ...

**1**

vote

**1**answer

5k views

### Automatic copy rows with matched column to other worksheet

Now I have a worksheet named sheet1 like the left side of image
I want to automatic copy all rows of sheet1 that have the column C = NO to worksheet sheet2 like the right side of image. And each ...

**-2**

votes

**0**answers

13 views

### macro to collect data from number of sheets to main page and need to add the sheet name that where the data collected

Please help me..,I need a macro to collect data(Student names) form number of Sheets(Class Name).all student names collected from sheet1, then a new column added with the sheet name (i mean ...

**0**

votes

**1**answer

4k views

### Any trick to calculating percentages when the base is a negative number

I am trying to calculate percent change when the base number (at time 1) can be a negative and the resulting number is positive (at time 2). My problem is the percent change from -4 to +4. A change ...

**0**

votes

**1**answer

3k views

### How to Find and Replace worksheet name in a formula?

I have 100 worksheets with different names saved in a folder. I have another worksheet in another folder where I conduct analysis of data from one of those 100 worksheets. In this analysis worksheet, ...

**0**

votes

**1**answer

3k views

### How do I get Excel to pull data from multiple workbooks from exact dates based on an entered date

I am running windows-7 and using Excel 2007 Enterprise.
I am a truck driver and need to catalog my pay based on a changing day to day system. I am paid per mile, per stop, per hour, or per flat rate ...

**-3**

votes

**1**answer

24 views

### I need a help on Excel Function [closed]

Could someone help me with any excel function with regards to list the employee name base on relation(only employee) and put it in another column. i just need to put the main Name of Employee and put ...

**5**

votes

**2**answers

4k views

### Importing multiline cells from csv file into excel

I have a csv file (comma delimited and quoted).
When csv file is opened directly from explorer excel correctly interprets the cells that are mutliline, but it messes up the character encoding (utf-8).
...

**0**

votes

**2**answers

1k views

### Positive result, negative result and current balance. How do you make starting balance show current result?

I have 3 columns:
Column A shows positive result and if the result is negative then it is in a column B.
Column B shows negative result and if the result is positive then it is in a column A.
...

**0**

votes

**1**answer

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

**1**answer

21 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

**1**answer

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

**0**

votes

**0**answers

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

**1**

vote

**1**answer

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

**1**

vote

**4**answers

11k views

### Add more than 20 digits in Excel without an exponential sign

I want to add more than 20 digits in an Excel cell. The current format of the cell is general, and it converts the number to an exponential format. I tried with a number format and accounting, but ...

**2**

votes

**2**answers

4k views

### How can I refresh a document I have open in Excel in read-only mode?

I have an Excel document that is stored on a SharePoint Server, which I always have open on my computer in read-only mode because I need to refer to it.
Every so often, in order to get the latest ...

**0**

votes

**1**answer

35 views

### How can I make Excel conditionally highlight cells based on the contents of cells?

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

**1**

vote

**0**answers

49 views

### Format Excel to Display Second Time Zone in Graph

I need to make my Y axis in a graph show the time in HH:MM (local) format as well as HH:MM +/- offset for another timezone.
Form example:
09:00 EST 06:00 PST
Is there some sort of custom format ...

**1**

vote

**2**answers

7k views

### In an Excel chart, how do you craft X-axis labels with whole number intervals?

I have a sorted list of values that I'd like to see graphed in an Excel chart just to see the shape of the curve. Here is the initial chart:
Looks ok, but the X-axis is ugly, so lets clean that ...

**1**

vote

**1**answer

28 views

### Looking up the same value in a row and returning multipe corresponding values

I am trying to lookup value 1 in the example below and return corresponding column name. When I use index match, it only looks up the first column which corresponds to 1 in the below example, it looks ...

**1**

vote

**1**answer

17k views

### Need a formula that looks at the first digit or letter in a cell

I have a column of numbers. Some begin with the digit 8 and the rest begin with other digits. I want to write a formula that will return "2" if the number in column A starts with 8, and "1" if the ...

**0**

votes

**0**answers

27 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

**1**answer

23 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

**2**answers

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

**12**

votes

**7**answers

34k views

### Table Formatting in Excel 2007: How do I remove it?

I've used the new Table Formatting option in Excel 2007. Now I can't remove it. I've dragged the little blue square up to the last cell on the top left, but it just won't go any further. In fact it ...

**1**

vote

**1**answer

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

**1**answer

7k views

### Reference entire excel 2007 sheet to another sheet

I have one sheet with 100 rows of data.
I have a second sheet that will use the same data but with filters applied. In fact, I will have a dozen sheets, each with different filters.
My goal is to ...

**0**

votes

**3**answers

5k views

### How to use excel to disply a list of cells, depending on dropdown box selection

What I want to achieve:
select list A, B or C from a dropdown, when pressed, list of values displays underneath. I would also like the list to be populated from items in a table (which would have ...

**-1**

votes

**0**answers

17 views

### Creating a specific bar chart

I have a table structured like:
Person Project Range A Range B Range C
Mister X Project 1 100
Mister X Project 2 250
Mister X ...

**1**

vote

**6**answers

4k views

### “Format as Table” Increments Column Names

I love using the formatting styles for tables in Excel 2007, but in my data I'm using the same column name for multiple columns.
When I format my table using the pre-defined styles, it ...

**1**

vote

**2**answers

543 views

### Filter and reorder columns in Excel

I've got a service (phplist, a newsletter manager) that exports a user list with several fields. At the end of it, each user has one or more lists to which he has subscribed.
The problem is, that ...

**2**

votes

**5**answers

4k views

### How to reference a row value in a table in excel 2007 from another row such that sorting table doesn't change it?

Consider a table of employee name, age and employee manager. Employee manager is a reference to employee name in same table but different row. I tried this by referencing cell =A3
Now if I sort ...

**3**

votes

**2**answers

3k views

### Excel chart won't update, based on calculated cells

I have an Excel document (2007) with a chart (Clustered Column) that gets its Data Series from cells containing calculated values
The calculated values never change directly, but only as a result of ...

**0**

votes

**1**answer

20 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

**1**answer

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

**0**

votes

**1**answer

4k views

### Copy/move values matching a pattern to another column

I have a worksheet where we need to move all the values matching a pattern to different columns.
For example, we have a B column with values that are one or more letters followed by one or more ...

**21**

votes

**16**answers

54k views

### How to make cells perfect squares in Excel?

In Microsoft Excel,
I want to make the height of first three rows and first four columns (12 cells in the top left corner) such that these cells are squares. How can this be done?
Surprisingly, ...

**7**

votes

**8**answers

140k views

### How can I get a cell in Excel to automatically adjust its height to fit the wrapped text contents?

I have a cell with wrapped text content in Excel and I want to format the cell so that its height will adjust to fit the content which can span over several lines. How can I achieve this behavior?

**2**

votes

**2**answers

83 views

### Down down list in excel

I am creating a table in excel to capture metadata and I want to allow a user to select options from a drop down list(1=yes,2=no,999=missing).

**1**

vote

**0**answers

12 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

**1**answer

783 views

### Pasting HTML table into Excel 2007 without modifying the format of each cell

I have a table in HTML having cells storing numbers like 123.0,123.00. When I use ctrl-A to copy the whole page into excel, 123.0 and 123.00 are all changed to 123, which is not something I want to ...

**0**

votes

**1**answer

182 views

### Excel or Access: how to group several lines in a table and insert contents in columns? (“split column”)

I have a table containing data of sold products (shown in the example on the left):
Columns:
Number of the order
Product Name
Attribute - specifies what is given in the following field "value", e. g. ...

**0**

votes

**1**answer

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