Podcast #128: We chat with Kent C Dodds about why he loves React and discuss what life was like in the dark days before Git. Listen now.

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.

Filter by
Sorted by
Tagged with
0
votes
0answers
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
1answer
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
2answers
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
3answers
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
1answer
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
0answers
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
1answer
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
0answers
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
0answers
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
0answers
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
1answer
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
1answer
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
1answer
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
0answers
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
2answers
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
1answer
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
1answer
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
0answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
0answers
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
1answer
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
1answer
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
1answer
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
1answer
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
0answers
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
1answer
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
5answers
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
0answers
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
2answers
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
0answers
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
2answers
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
1answer
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
0answers
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
1answer
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
0answers
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
2answers
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
0answers
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
0answers
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
1answer
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
2answers
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
0answers
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
0answers
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
1answer
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
1answer
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
1answer
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
0answers
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' ...