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,267
questions
0
votes
1
answer
363
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
10k
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
65
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
2
answers
540
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
2k
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
43
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 ...
1
vote
2
answers
75
views
How do I find matching data in Excel?
I am trying to find some files listed in a big Excel workbook.
On Sheet 1 I have the list of all the files with full path.
C:\A\B\01.xlsx
C:\A\C\02.xls
C:\A\D\03.zip
C:\A\E\04.jpg
C:\A\...
1
vote
0
answers
96
views
Excel dates with standard format (*) become custom when opened in another country
Here in the USA, I have created an Excel 2007 spreadsheet with a table that contains several columns with dates. I have formatted the date columns using the standard short date format (with the ...
1
vote
2
answers
1k
views
In Excel, checking if a cell matches one item from a named constant string list
This question is an expansion on In Excel, how do I check if a cell is in a list of values (a range of cells) .
I'm trying to do =COUNTIF(name,G6) and when name refers to some cells, it works fine, ...
1
vote
2
answers
3k
views
Excel SUM function for whole column?
How can I sum the whole column without freeze head?
I have a situation: I need to SUM each column, but the total rows in each column will keep changing. users are keep adding data in each columns, ...
-1
votes
1
answer
743
views
how to copy data from on cell to diferrent cell using command button
for example the first thing i put in cell b1 has "='Ex-post'!C172"which has value "1" and c1 has "=OFFSET('Ex-post'!$B$4,MATCH($H$1,'Ex-post'!$B$5:$B$542, 0),4)" in which the value is 2300 and i want ...
2
votes
2
answers
12k
views
Superscripts in Excel chart labels
I have data like this in two columns:
2 | 5
4 | 6
8 | 7
I want to plot them (scatter plot) with x={2,4,8}, y={5,6,7} but in the x-axis show 2 as 2^1, 4 as 2^2, 8 as 2^3, but not with the ^ symbol ...
0
votes
1
answer
57
views
Excel 2007. Write changes back to extern file source
it's possible to import data into an excel sheet from an external (csv) file.
Every time content of this external file will be changed, we'll see these changes in the excel sheet.
But is it ...
0
votes
1
answer
6k
views
I don't want Ms excel to scroll down by cell units [duplicate]
When I scroll down (or up) in Ms Excel 2007, it scrolls down so that only whole cells (or at least it tries to do so) could be displayed next in that page. And it keeps jumping down one complete row ...
1
vote
1
answer
4k
views
Microsoft Excel lookup match without sorting data
Have a value list and need to insert points by looking up the data table. Data table has value for points in 1000 increments. Actual value that I lookup will not be rounded to 1000 so I tried using ...
0
votes
2
answers
353
views
Concatenate a range with values in between
I work with ranged data and want to populate a cell that includes values at set increments between the min and maximum. For example, the minimum outer diameter is 1 1/16" and the maximum outer ...
1
vote
2
answers
2k
views
Excel Lookup adds double quotes to string
I'm using this formula to get value form a table
=LOOKUP(C11;Alias[A];Alias[B])
where C11 = 12354567
But when I use
=LOOKUP(LEFT(C11,7);Alias[A];Alias[B])
where C11 = 12345678, the formula does ...
0
votes
1
answer
2k
views
Defined Name to give text or date value instead of numeric value
I had been trying out Define Name in Excel. I defined a name for a cell in which I would put a text or date value or I may leave it blank.
But when I use this defined name in another cell, the second ...
0
votes
1
answer
2k
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 ...
2
votes
1
answer
5k
views
Excel - sum values based on a column that match another column in another table
I've been working my head around this, but haven't figured it out yet, and I'm sure it's dead simple.
Suppose the following example:
There are two tables, one containing animals, and the other one ...
1
vote
2
answers
12k
views
MS Excel Column content replication across two sheets
Microsoft Excel functional Question
How do I replicate (copy a column contents of Values to another sheet column) of a whole column (with data content) from a primary sheet to an secondary sheet in ...
0
votes
3
answers
8k
views
In Excel replacing a column with another column
I have a list of Variables in Column A > list of items
another list of variables in Column B > with corresponding Item Codes for >> column A
And in Column C > I have list of item codes randomly ...
1
vote
0
answers
274
views
Make Excel 2007 pivot tables default to Classic View
When I launch a new pivot table in Excel 2007 (.xlsx file format) the defaults appear to be:
New view (not Classic view)
Autofit column widths on update = on
Subtotals = on (top of group)
I end up ...
0
votes
1
answer
194
views
excel - if value grater than, use that value
I am having problems with my excel function. I want to:
if value 1 is greater than value 2, then write value 1 in a cell. If value 2 is greater than value 1, then write value 2 in the cell.
...
0
votes
3
answers
124
views
How can I work out days, hours and minutes from a total number of minuts?
In Excel I have a number of minutes that I need to convert in to days, hours and minutes, but I cannot figure out how to get the minutes. Here is how the data must be presented -
Total Minutes Days ...
2
votes
0
answers
322
views
CTRL+SHIFT+DOWN not working in Excel 2007
Ctrl+Shift+↓ is not working in Excel 2007. I have unchecked:
Options → Advanced → Tools → Options → Transition Navigation Keys
Ctrl+Shift+↑ is working fine. If I ...
0
votes
1
answer
1k
views
How to change the size of my 'glow' effect on excel, when I use custom color?
When I create a shape in Excel(2007) I apply some effects in it on Format > Shape Styles > Shape Effects, with one of them being "glow" with some predefined colors and sizes.
What I'm trying to do is,...
0
votes
1
answer
85
views
New instance of Excel does not see already opened instance
I have Avizo.xlt with one Worksheet and a code which intended to put this WS inside already opened document, which is SLK report made by our ancient ERP system, and close this document.
Everything ...
2
votes
1
answer
1k
views
Sumif range of criteria
I've checked different questions and answers on the site, but couldn't find what I'm looking for.
I try to have a sum of values, using multiple criteria (OR): When I use, e.g.,
=SUM(SUMIF('2014-02'...
21
votes
18
answers
123k
views
Get rid of extra space in cell when using Text Wrap
When I type a long sentence (or more than one sentence) into more than one cell in a row and apply the Text Wrap option to these cells, the cells have an extra blank line on the bottom of them. There ...
1
vote
1
answer
9k
views
Show or hide rows in an excel sheet subject to the value of a particular cell (excel 2007 & Windows 7)
I have made a spreadsheet to specify decoration selections from a range of standard options.
There are five separate ranges so this is the first selection then within each range there are additional ...
-1
votes
2
answers
157
views
Referencing cells from a different worksheet
Im trying to reference data within a cell of first work sheet (active) on a second worksheet (trucks). When I use =active!$L$34 on my second worksheet (trucks) it bring the right number over. However ...
0
votes
1
answer
75
views
How to match Reg No. in one workbook to another
I want to find out a formula to match Reg No. for two workbooks.
First work book is a master book I update everyday almost, next workbook I have employees name and ID numbers only, nos are in ...
2
votes
1
answer
2k
views
Excel inconsistent date conversion
I'm running Excel 2007.
I've done a dump of data from a MSSQL database into a CSV file, then saved it as part of a larger Excel book. One of the fields is a date, which downloads as: 39262....
1
vote
1
answer
130
views
What's the best way to merge 2 tables keeping 1 column aligned?
What's the best way to merge 2 tables keeping 1 column aligned?
Example: I have these 2 tables from which I want to make table 3:
TABLE1
color name1
red apple
orange orange
yellow banana
...
0
votes
1
answer
100
views
Method to Consolidate Cell Contents from Two Excel Files into One Excel File
I translated an Excel file in Chinese into English with OmegaT, a CAT (Computer-Aided Translation) tool, and a pure English file was generate by OmegaT.
However, the customer wants me to submit an ...
0
votes
1
answer
4k
views
Can Excel's Find formula have multiple find_text criteria?
I have a list of names on a NAMES tab range A1:A100.
On another tab 'Data Export', in column A I have an export of thousands of comments where one of those names from the NAME tab can be found within ...
1
vote
1
answer
20k
views
VBA Excel: Function to find a string in another workbook
I'm trying to create a function that searches a string (bom) in two different workbooks and returns a value next to that string. I know the ranges in those workbooks where I want to perform the search,...
0
votes
2
answers
11k
views
Excel - column width differences in copied worksheet
I have a workbook that I created using Excel 2007. In Excel 2007 I can copy one of the worksheets to a different workbook with no problems. However, using Excel 2010 I'm getting odd behavior. I open ...
0
votes
1
answer
61
views
Separate cell content after "-" for multiple columns at once
--------------------------------------------
| Visible | Actual formula | I need |
--------------------------------------------
| 0 | =500-500 | 500 |
| 0 | ...
0
votes
1
answer
3k
views
VBA Excel: How to select only numeric values in a range?
I used Range.Find to locate a string called "Qty", now I want to select all the numbers in that column.
I would use .End(xlDown) to get the last row, however the last used cell in that column is not ...
0
votes
1
answer
4k
views
Deleting entire row in excel if missing data in certain column or columns?
I just downloaded a Micosoft CSV file from Google Contacts and I would like to modify it so that I can organize the contacts in my phone. I am going back to my "dumb" phone as part of an experiment of ...
2
votes
1
answer
16k
views
Horizontal Index Match Excel 2007
i have a list of customers rows 1-500 column B, with their purchases showing in columns u-AB
and based on the maximum purchases done under a specific column (u-ab), the customer will be tagged as such....
0
votes
1
answer
8k
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 ...
0
votes
1
answer
2k
views
VBA string search within files in directory not working in Excel 2007
I'm trying to look for a string within a folder containing several files. Once the string is found it should select and copy a value in an adjacent cell 5 columns to the right(Offset(0,5)), then paste ...
-1
votes
1
answer
58
views
Conditional Formatting from Helloh, for a Noob
I'm going to try my best to explain what I need to figure out. Also, for you to understand exactly how mind bending this is for me, I haven't used an Excel formula since 2005/2006ish. We're doing a ...
1
vote
0
answers
1k
views
Excel: cannot remove advanced filter
I added Data->Sort&Filter->Advanced filter to a cell that allows me to quickly choose a name from a range of names stored in another sheet some time ago.
Now I would like to remove the advanced ...
0
votes
1
answer
3k
views
Excel - Script that search a sheet for a cell containing specific text, and replace the text with a specific value
I want to split a cell with data into other cells based on the data in the original cell. The data from the original cell looks like this (all content in a single cell):
Field95-4,Field97-4,Field98-0,...
-1
votes
1
answer
1k
views
Invalid date value in csv file
I export data in csv format from sql server database. It contain 5 column. one column have date and time value. When i checked the date -time value i found date time value is in wrong format. I add ...
1
vote
0
answers
97
views
Excel, sort through columns
I need to sort through a a few excel columns and can't seem to nail down an easier way besides manually going through line by line. Column A has names where names can repeat, column b has state ...