# Questions tagged [microsoft-excel-2007]

Microsoft Office Excel is a spreadsheet application written and distributed by Microsoft. Use this tag for problems specific to Excel 2007 for Windows.

2,124
questions

**0**

votes

**0**answers

59 views

### How can I fix my Profit Margin formula? [UPDATED]

I have created a model whereby I've got the following:
Cost (column P)
Dealer price (Column S)
Current List price (Column T)
I've then done some market research and have adjusted List pricing (RRP) ...

**1**

vote

**1**answer

117 views

### How to reduce number of formulas and columns?

My goal is to adjust my pricing to match that of the competition, be it by reducing or increasing my current pricing. My model is a bit complicated and messy because their pricing includes tax, while ...

**0**

votes

**2**answers

88 views

### MS Excel - How to drop the character between the concatenated cells

I need to concatenated cells and put a comma between them. But some cells in the concatenated columns are empty and the result shows the commas between them. How to drop the commas if a cell is empty? ...

**2**

votes

**3**answers

109 views

### Check if cell text has a specific format

I am looking for a way to determine if text entered into an Excel cell is following this format: "0000/00/00" (0s can be any one digit number {0,1,2,3,4,5,6,7,8,9}).
Is there a way to check if the ...

**0**

votes

**1**answer

52 views

### Match the entire row from one table with another and then return a value from table 1 in Excel

If I have two tables, Table 1 has the following data
***
CTRL Number DATE MEMO DOLLAR
1 4/4/2014 "xyz" 505050
2 4/5/2014 "fadf" 99999
3 ...

**1**

vote

**0**answers

13 views

### MS Excel 2007 not displaying chart as required

I have Category Names to select from cells A3, A5, A7, & Values from E3, E5, E7. The slices on the pie chart show as appropriate, if I omit the Category Names; but do not, if I include them in my ...

**1**

vote

**1**answer

101 views

### EXCEL - How to use VLOOKUP to get the entire table contents?

I have an Excel sheet with columns:
Screenshot
Data
Table 1 Table 2
METADATA Date ...

**0**

votes

**0**answers

9 views

### Insert incremented value in entire column based on specific cell value

I'm making a sheet where a user enters a starting value in a cell, and the amount of times to increment in another cell. I want the starting value to then show in a column, and the amount to increment ...

**0**

votes

**0**answers

10 views

### VBA - Extracting data from dictionary [migrated]

Stuck on this for 8 hours! Please help.... My database has 100 columns, with column A being a unique list of employee ID and column K being each employee's pay status (exempt, hourly, non-exempt, etc....

**0**

votes

**0**answers

24 views

### Excel 2007 pictures how to change default paste to “Move and don't resize with cells”

Somehow my default paste setting for pictures has changed to "Move and resize with cells" - creating headaches - I need to change it back!
(Google returned less than 1 page of irrelevant results...)
...

**1**

vote

**1**answer

50 views

### Finding the Closest/Nearest value in relation to X and Y Coordinates Excel

I have been struggling with an issue for days now. I have an excel sheet with a lot of data about Airports in Europe. For simplicity sake, i will narrow it down to few columns which are all in the ...

**3**

votes

**1**answer

36 views

### Force Excel to re-parse a whole column of dates

I have a series of dates in a column, currently recognized as text. Thus sorting doesn't work correctly.
When highlighting the column and changing the format to Date, Excel still recognizes it as ...

**0**

votes

**1**answer

41 views

### How can i simplify my code using LOOPS in VBA

I need to copy contents from a column in one worksheet and paste it into another (at the same time making a total of 7 copies of each of the variable). There are multiple columns and each column has ...

**0**

votes

**0**answers

22 views

### Lookup in Tree style table in excel using index match

Company | Sector | Date
ABC XYZ Q1 2019
Q2 2019
DEF KBP Q1 2018
TGH LHK Q3 2020
Imagine "Company" is Cell A1 and "Q2 2019" is Cell C3. I would like ...

**1**

vote

**2**answers

23 views

### Excel 2016 - How to bring up a conditional list

I'm trying to create a dependent list in Excel 2016, but don't really know where to start. I tried following a couple of guides to create a dependent list, but it wasn't doing what I wanted it to do.
...

**2**

votes

**1**answer

36 views

### Percentage increase in excel for cell in hour format

I need to set a formula to calculate a percentage increase/decrease from a cell with hour format.
Now the original cell is like [mm:ss] and I need that the result to be also in tha same format.
By ...

**0**

votes

**1**answer

27 views

### Excel, Split name with more than one words of first name or last name or middle name

How can I separate the last name middle initial and first name
I have a name with two or more given name or last name or middle name for example
Mendoza, John Lloyd Dela Cruz
Torres, Michael Pineda
...

**0**

votes

**0**answers

8 views

### Create Horizontal Table

A table consists of three different values with one unique value in another column, need to convert to horizontal.The highlighted portion is the expected result

**-1**

votes

**1**answer

66 views

### VBA to copy entire cell values to clipboard [closed]

Sub Test()
Dim copycell As DataObject
Dim ws As Workbook
Dim strText As String
Set ws = Workbooks.Open("C:\Users\Desktop\New Microsoft Excel Worksheet.xlsx")
strText = ws.Sheets("...

**0**

votes

**1**answer

10 views

### Separating numbers to single cells

I am trying to separate letters & numbers to individual cells in excel.
My example TYE123 - T to A1, Y to A2, E to A3, 1 to A4 etc.
I have multiple rows with different amount of characters TYE123, ...

**0**

votes

**1**answer

17 views

### Excel how to add spacing between numbers and letters

I have an order number "CP1045" in excel which I need to put spaces between each letter and number. Example : C P 1 0 4 5

**0**

votes

**1**answer

40 views

### Trouble saving an Excel document as tab delimited file with japanese Shift-JIS

Trying to save an excel document containing Japanese characters as a tab delimited file with Japanese Shift-JIS
I have done the following steps.
Change the character encoding setting in the ...

**-1**

votes

**1**answer

40 views

### Pivot table in Excel

I have a pivot table like so:
And I would like to get it like this:
I need to make a pivot table that shows the number of products sold by country. A person should understand where each product is ...

**0**

votes

**0**answers

22 views

### inserting hyperlinks into excel [duplicate]

I need help with inserting hyperlinks into excel. I have the below text all in one cell in excel.
Count of Hyperlink One where the Hyperlink Two valid values are equal to and where the Hyperlink ...

**1**

vote

**1**answer

39 views

### SUM multiple rows when criteria is met and Match a specific column

=IFNA(SUM(VLOOKUP($A4,Consol!$C$8:$BS$222,MATCH(TB!G$1,Consol!$C$2:$BS$2,0),FALSE)),0)
I have a project finance model (PFM) by month and I need the data to feed into a TB (also monthly). So what I ...

**1**

vote

**1**answer

69 views

### VBA - Copy range from 300 closed workbooks onto one main consolidated workbook

Please help with writing the formula to pull data from 300 closed workbooks (and I don't want to open any of those 300 workbooks). Description of project: There are 300 excel timesheets. Need copy ...

**1**

vote

**1**answer

33 views

### VBA excel - Is there any way to ensure the user cannot call/run a macro in the immediate window?

So I have written a VBA application and locked the VBAProject (unviewable). But of course, the user can still have access to the Immediate Window (if they open another excel file for example and ...

**0**

votes

**1**answer

42 views

### Is Excel VLOOKUP the best choice for my application?

I have an Excel file that tracks the maximum elevation of the sun throughout the year, one row per day, given a specific lat/lon. If I edit the lat/lon the daily maximum elevation changes.
I'd like ...

**0**

votes

**0**answers

20 views

### Insert rows option in Microsoft Excel 2007 is grayed out

I am using Microsoft Office 2007 on my windows 8.1 professional computer. Computer is connected to domain. The problem is that when i login to computer with one of my domain account the "insert rows" ...

**0**

votes

**1**answer

29 views

### Need formula to vlookup comma separated values in a single cell

I'm trying to do a vlookup on a cell with comma separated items in it for the lookup_value, referencing another file that has 1 item per cell. My example below has 6 items in the csv cell, and i want ...

**20**

votes

**5**answers

2k views

### How do I get the =LEFT function in excel, to also take the number zero as the first number?

My data contains a column of room numbers. Each room number's first 2 digits is the floor number where the room is located. The =LEFT function works well for data that does not start with zero. The =...

**0**

votes

**0**answers

81 views

### VBA signed macro started showing “Cannot run the macro …” error after Win10 v.1903 upgrade

I had macro in this .xls file in Excel 2007 workbook. The macro was signed by my code signing certificate:
I then have it set up in Excel to open only files with signed macros:
This worked ...

**0**

votes

**2**answers

80 views

### Based on Cell Value matches column with Yes or No

please see the table below. I have Columns like ColA has some value, Store has Store Names. And rest column names defined as unique cell value in Store1 column(Store1 till storeN.
ColA Store ...

**0**

votes

**0**answers

52 views

### Create a calculation based on previous date and specific identifier

I have an excel table that has a list of measurements and dates those measurements were taken. Each measurement is from a specific location. I need to perform a series of calculations that are based ...

**0**

votes

**2**answers

76 views

### Calculate Distinct Values Based On 4 Conditions (Excel Formula)

I have a table structure as per below:
[A] [B] [C] [D] [E]
[1] Dog Big 2018 02 123
[2] Dog Big 2018 02 123
[3] Cat Small 2019 05 123
[4] Dog Big ...

**0**

votes

**1**answer

26 views

### Detection of duplicates in Microsoft Excel

I have dealt with serial numbers that are stored as text in the cells because sometimes the serial numbers have letters. I encountered something that I don't quite understand about duplicate detection....

**0**

votes

**0**answers

34 views

### Excel - Total for range of values accounting for changing annual inflation rate

I have a series of values for previous years along with the inflation rate for that year:
With the above data the formula for the first entry in the Cumulative column would be:
A2*(1+B2)
For a ...

**1**

vote

**1**answer

23 views

### Certain Time Values in a .xlsx not Changing When I convert to a .csv

I am trying to convert from an Excel spreadsheet (.xlsx) file to a .csv file. The software I am using is Excel 2007. The issue I am having is I have a column of date and time values for every hour of ...

**0**

votes

**0**answers

32 views

### How to Select unique values from a list and Transpose Unique values

I have the following input raw table
I am looking for a dynamic way to solve this problem. The original raw data shown above in the picture will be updated periodically so it can have more or less ...

**0**

votes

**2**answers

25 views

### How do I make an IF statement based on if one cell's content is matched within a range of cells

I have a range of values in B5:B30, and have singular values within a list, say one was in D5. What would I put in an empty cell to say;
"IF D5's Content is matched in the B5:B30 range, display Y, if ...

**2**

votes

**0**answers

30 views

### Excel chart complex custom number format

I have an excel chart that is controlled using slicers. The numbers in the y axis range include negative numbers, positive numbers upto 100+ million dollars. The axis has been formatted to display ...

**0**

votes

**0**answers

15 views

### Duplicate a dynamic range of data from 1 sheet into excel table on another sheet

I have to duplicate a sheet populated by a software dump as a report on to the next sheet in an excel table in the same work book. Can not use VBA as the workplace PC does not allow codes to run.
...

**0**

votes

**1**answer

29 views

### Expanding multiple dates in excel [closed]

So i have a list of start days and end days and I want to expand all of them in a different sheet For example:
A1 has a start date and B1 has an end date
A2 has a start date and B2 has an end date
...

**1**

vote

**2**answers

57 views

### Adding line graphs adjacent to each other in Excel

I have a set of data that is grouped by both "Male and Female", and also three different time periods across three different conditions (labeled dft, dt, and ft). Here is the data:
I would like ...

**0**

votes

**0**answers

82 views

### Get Column Heading based on Row value

I have a table with 10 rows and 10 columns.
In Row 1 I have column headings like "Ankur", "Rakesh", "Shyam" etc.
In Row 2 I have the row values "monday", "tuesday" etc.
In Row 3 to Row 10 I have ...

**0**

votes

**0**answers

23 views

### Auto group a sheet in excel

i have a sheet with 1000's of rows with info , most information goes like 3 rows and 10 columns , each of this 3 rows contains work i have done in certain places , and column 1 is the places where it ...

**0**

votes

**1**answer

402 views

### How to sort a column with positive and negative numbers in Excel?

I am having one excel book with few data. One of the columns in the data set contains both the negative and positive values in a percentage format. When I try to sort using excel option, it is not ...

**0**

votes

**1**answer

17 views

### Excel Autoplot calendar

I'm trying to setup make an excel sheet where a certain range would return as true on an IF statement if any of the cell has true value.
It should look like this
...A - B
R1 1 .. 3
R2 2
R3 3
R4 4
=...

**0**

votes

**1**answer

31 views

### How to have a numerical change in one cell affect another cell's numerical value?

I'm attempting to generate an inventory sheet for my work place and one of the columns is the inventory of the warehouse, another is the inventory of what we have in store. When subtracting from the ...

**0**

votes

**0**answers

31 views

### How to highlight a ColumnName in Excel

I have multiple column names and I want to highlight only those column names in which there are multiple rows containing 'False' as value. So that I can easily find out which columns have 'False' ...