# Tagged Questions

**0**

votes

**1**answer

17 views

### Text function in Excel isn't formatting year

I've got a problem with the text function in Excel (2007).
It doesn't format the year, it just states yyyy instead of e.g. 2014.
If I have a cell with 23-7-2014 and use the formula ...

**0**

votes

**0**answers

30 views

### Microsoft Excel 2007 - Auto Update in 1st Sheet based on What updated in 2nd sheet (2nd sheet Update will be in Fixed Column but Random Row)

Actually I'm facing a problem now.
I am using Excel 2007.
And, I have two different sheet of excel file with me.
My 1st sheet is my report.
My 2nd sheet is my customer name.
I hope that when ever ...

**1**

vote

**0**answers

41 views

### vlookup in a cell that contains mid formula

I am trying to create a vlookup in a cell referencing a specific cell so that I can pull the data from my lookup table. Well this cell that I am referencing happens to have a mid formula in it, and ...

**1**

vote

**1**answer

15 views

### How to remove one column of a calculated item in Pivot?

I have two columns. One with data from this year and the other with data from previous year. I now have added a calculated item in Pivot to display the % delta of these two years. Now when doing this ...

**0**

votes

**0**answers

17 views

### How to Group and Layout Pivot Table when Values is in the Row Labels Field?

I'm attempting to present large amounts of data in a report using a Pivot Table to allow for dynamic filtering/categorization. The data in the table is of the form:
Year Month Category Region ...

**0**

votes

**0**answers

15 views

### Split apart and remove data in Excel 2007

I receive orders for telephone service for between 15 and 30 stores in a single email in regular text format. The stores are separated in the email by one blank line. Each store begins with ...

**1**

vote

**2**answers

19 views

### Single formula to search column and return corresponding fields

Am having issues creating a single formula to search the billionaires list by name and autofill the rank, age, net worth, and citizenship field in the search spreadsheet.
This is the formula I have ...

**0**

votes

**0**answers

9 views

### Excel workbook contains a userform which opens up black on 8.1 office 2010

The userform within the worksheet opens black on windows 8.1 office 2010, yet it opens fine on XP with office 2010.
It's a excel 79 to 2003 xls file.
We checked trust centre on 8.1 but no joy, ...

**1**

vote

**0**answers

16 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**

votes

**0**answers

16 views

### Excel 2007 function keys not working

In Excel, the F function keys are not working. I am looking for "toggle" for this function.
For example, F4 will not cycle through absolute and relative cell references.
How can I troubleshoot/fix ...

**0**

votes

**0**answers

21 views

### EXCEL: I have a column of single-word strings and would like to see if any of these strings are contained in a column of multi-word cells

Example:
In column A I have a list of words "Apple, Banana, Orange, etc." each in their own cell.
In column C I have a column of multi-word strings like C1="I ate an apple", C2="Bananas are gross" ...

**-1**

votes

**1**answer

18 views

### Deleting range of cells based on criterea

I have an Excel file with several macros, used for data processing.
The masterfile reads one or more .csv files and copies all data it needs into a tab (lets call it sheet1) within the masterfile. ...

**1**

vote

**0**answers

13 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**

votes

**0**answers

23 views

### comparing 2 columns in excel and return the same result in a group

hi m new in excel function,
i have a problem like this. i have 2 lists of data
DATA I
NAME SCORE
----- -----
ANA 10
BUDI 20
TINA 30
DATA II
NAME SCORE
----- ...

**0**

votes

**0**answers

17 views

### Convert COUNTIFS formula to SUM(IF) to enable external workbook references?

I need to convert the following formula to one that uses SUM(IF), as I am given a #value error when the external data source is closed.
...

**2**

votes

**1**answer

44 views

### Replace cell references with values without F9 using macro

This is an Excel macro question. Given a series of formulas such as the following:
= A1 + A2
= B2 + B2
etc., ...
I would like to replace each of these cell references with the values without ...

**0**

votes

**1**answer

31 views

### How to I use SUMIF or SUMIFS to automatically add the values of different cells when they meet they meet multiple criteria

Basically I have a spreadsheet with three criteria columns.
I would like to be able to recognize duplicate HTS codes that also have the same country of origin and add the sum of those values, which ...

**1**

vote

**0**answers

27 views

### Excel: Replace Number Format in Diagram

I have an Excel Workbook which will be sent to a client and I need to get the thousands and decimal seperators right.
I have a Workbook.Open routine which will change to custom formatting (and back on ...

**0**

votes

**0**answers

35 views

### VBA Code to update data in closed excel files within a folder by clicking a button

I have a code which works really well that updates values of closed excel files in a workbook. What I want to do is alter the code so I can create a on my worksheet where I can make y changes I ...

**0**

votes

**1**answer

22 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

40 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

23 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

18 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

27 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

20 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

105 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

15 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

53 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

24 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

26 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

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

57 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

**1**answer

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

**0**

votes

**1**answer

44 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

**1**answer

59 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

34 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

51 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

**1**answer

71 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

60 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

**2**answers

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

**3**

votes

**1**answer

176 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

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

**2**

votes

**1**answer

72 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

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

**-1**

votes

**1**answer

41 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

30 views

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

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

**0**

votes

**2**answers

45 views

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

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

**1**

vote

**1**answer

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

**0**

votes

**1**answer

35 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

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