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
1answer
23 views

Excel Formula To Get Last Non Zero or Not Blank Value in Column And Return Value

I already saw a few related questions on here about finding the last item but my question is a bit different because I'm trying to find the last not blank or non zero value in a column and either ...
1
vote
1answer
22 views

How to find “#VALUE” cells in Excel?

In Excel 2007 I have two sheets: sheets1 with data sheets2 links with some formulas data from sheets1 If a formula does not work in sheets2 I have cell that shows #VALUE!, but in the bar I can see ...
0
votes
3answers
46 views

Excel VLOOKUP for range of dates

I have been struggling with VLOOKUP for sometime. I want to use VLOOKUP for a range of dates using the two tables I have given. I want to get which Term each row belongs to. Basically I want to check ...
1
vote
3answers
106 views

Average of rows averages does not equal average of whole table

I am averaging a group of numbers in Excel 2007 that have 21 columns & 42 rows. When I average all the cells at once I get one result, 59.25183, but when I average each row & then average ...
0
votes
1answer
19 views

Excel - Macro - Data copying with values

I have a macro where it copies a range from a sheet and pastes it into another sheet. Sheet name - MAIN Range - C4 - D26 Date sheet - DATA Then when you enter new data and use the macro, it copies the ...
1
vote
2answers
32 views

How to calculate average and standard deviation from the same range in excel

I have an excel sheet in which there are there are groups of 4 values in column H. So H7 to H10 contain 4 values relating to one sample. H11 to H14 contain 4 values relating to another sample. In ...
1
vote
2answers
13 views

Disable automatic VBA window opening while opening an Excel document

I have an excel document and I added some vb script to find the password of the protected file. I took this script from some internet forum. After that, whenever I open this excel sheet the vba window ...
0
votes
1answer
45 views

OFFSET function in Excel

I'm having some trouble with the OFFSET function in Excel. I'm modifying a file created by someone else, the code was not written by me. So in one sheet of the file, in the cells it applies the ...
0
votes
1answer
59 views

Macro to create Line graph for each row in my table?

I've got a monthly spend table with almost 800 rows (one row per customer), and I'd like a line graph, with trend, for each customer. Is there a Macro that will help me do this for every line, and ...
1
vote
3answers
110 views

Selecting the first row in excel where a column value equals a certain value

I have a excel sheet which displays the status of various products on my website throughout the day, along with the timestamp of the status as so: | Timestamp | Product 1 | Product 2 | ...
0
votes
2answers
34 views

excel - group sheets by columns

I have a bunch of .csv files with the same structure, but it's not guaranteed that they are in same order row-wise. I would like to group them all in a single spreadsheet. The following image draws ...
0
votes
1answer
27 views

Excel: Simulating multiple recalculations (F9) and then pasting outcome into a table

TL;DR: Want to recalculate a model based on random variables and take the result and put it in a table. What's best way to do that? Longer Explanation: I have a model that is built upon multiple ...
0
votes
1answer
110 views

Is it possible to know if the field in Excel is raw value or two numbers added together

Meaning... I have b5 with value 345,33 and b6 with value 22,00+12,00 which Excel correctly calculates as 34,00 BUT I need to know if the 34 is result of adding or just a plain number like in b5 ? ...
0
votes
1answer
26 views

Excel transpose function returns a 0, multiple worksheets

I do have two worksheets. In worksheet 1 I do have the following values horizontal listed: A1 = 2010 B1 = 2011 C1 = 2012 In worksheet 2 I would like to list the values (2010, 2011, 2012) vertically. ...
0
votes
0answers
41 views

I need to compare a previous cell value to the current cell value after refresh. Then, I need to run a Sub

I have an excel spreadsheet that updates its values automatically every 3 seconds or so. I want to compare a cell value to the previous cell value (same cell). Here's the step out: Get and store cell ...
0
votes
0answers
6 views

copying existing data in a column downwardly over the blanks in the same column without overwriting and existing data - uneven spacing to start

trying to fill data in a column that has some cells populated (not equally spaced) and some cells blank. If the cell is populated (the first row is), then I want the data to remain. If the next cell ...
0
votes
0answers
4 views

How to have multiple answers in same cell data pulling from multiple worksheets

I know it's possible to have multiple answers in same cell, but when answer is FALSE it breaks the calculation. How do I get around this, so that it continues to run and verify each answer and return ...
1
vote
3answers
55 views

Subtraction formula which ignores or treats any non-number precedent cell as 0 (to fix #VALUE! error)

I need to subtract cells, but when one or both of them is blank, or contains text, the subtract formula returns a #VALUE! error. I am using =SUM(A1-B1). Can anyone please help with the formula which ...
1
vote
1answer
58 views

I want to combine multiple Excel files

I need assistance with the issue that I have multiple Excel files which are being updated on daily basis but for the analysis part I have to combine them all; and then perform the analysis. Is there ...
0
votes
0answers
16 views

Excel: convert IMAGE cell to txt cell?

I download an excel file from web. In this DB file I have photo linked to some records but in the file each photo is linked in an IMAGE cell. I would like to insert the name of the photo instead IMAGE....
0
votes
1answer
31 views

Excel Database for Questionnaire Results

I need to make an ongoing database for a questionnaire with 12 questions. The tick box options are Certainly True, Somewhat True, Not True and Dont Know.Each of these has a value. So if you select ...
0
votes
0answers
6 views

Excel 2007 automatically multiplies numbers after formatting decimal places from 2 to 3

After changing in Excel 2007 decimal places from 2 to 3 in: Format cells - Number - Decimal places, the cells begin automatically display numbers multiplied by 1000. For instance if 15,46 needs to be ...
0
votes
1answer
17 views

How to show a column name in excel if a condition is met (eliminating the blank ones)

I have the following table: I need the Result row to show the name of Fruits if their value is greater than 1. I have the following function for R18, it gets dynamic when stretched to the succeeding ...
0
votes
0answers
23 views

Microsoft office 2007 Excel graph

Graph Hello everyone, I want to draw a graph using Excel office 2007 where multiple independent events are shown along a single timeline. All these variables have their own reference ranges. I want ...
0
votes
1answer
25 views

Get count of categories present in a column in separate columns in pivot table in excel

I have a pivot table which looks like Now I want to get count of each category in State column in a separate column. Something like this. I tried creating a pivot table, but the format is not what I ...
0
votes
0answers
16 views

Excel chart with many series: legend is completely unreadable

I have an Excel chart with about 10-20 series. The series names are quite long. And the legend of the chart is damn near unreadable, unless I make the chart huge. It's not that you can't read the ...
0
votes
1answer
29 views

Excel If-Else formula to capture ''hour“ and ”min" across an excel row

I have a row of "h min" values (eg:2h 15min) across a row. I need to capture the 'hour' and 'min' separately for which I'm using "=LEFT(B2,(FIND(" ",B2,1)-1))" and "=...
2
votes
0answers
41 views

Open Colon delimited file from command line in Excel

I want to create a shortcut or a command to open a file that uses a colon : as a delimiter in excel. I know via the UI I can click "From Text/CSV" select a file click Import select a ...
0
votes
0answers
10 views

Excel - Trigger action when new data is added

I have an excel sheet that stores the Purchase Order(PO) conditions like vendor name, PO number, PO Date, and most importantly payment conditions i.e. credit period (after how many days, what ...
0
votes
2answers
93 views

How to get Dynamic Cell Value from another Sheet to an Excel Sheet Cell?

Hope You all doing good .I New to Excel. What I'm Looking for is to get a Cell Value from another sheet on the same work book. But the address of the cell cannot predict initially, It depends upon the ...
0
votes
1answer
21 views

Excel 2007 Need to copy column B to new row in Column A

I need help. I have several 2007 worksheets with two column of data and many rows. I want to take the information in each row of column B and add it/move it as a new row under column A. Is this ...
1
vote
0answers
32 views

Formatting cell to show text in a text box. Excel Sheet

I have this sheet. The Product details section and the price section are not visible because of large amounts of text in them. When I manually make the size equal to the text..It becomes very ugly and ...
0
votes
1answer
43 views

Excel - How do I distribute rows to 5 columns?

I copied data from a 5 column web table that unfortunately gave me only a "line-break"-separated list. Pasting in Excel gives 1 column with many rows, where a set of 5 rows represents 1 row (...
0
votes
1answer
19 views

Apply macro on all worksheets except specified sheets

I have developed a excel workbook which contains macros that will copy data from a Data Summary worksheet to duplicate templates (a template is created for each data row) and then it formats each ...
0
votes
0answers
19 views

excel how to search content text from multiple that opening file

I have one folder that content many excel file in it(share drive). file opening by user using it. How we can search text in each file. I trying search by ''content:"str search"'' but result ...
2
votes
1answer
33 views

Excel 2007 “Arbitrary” #NAME? Errors

In the midst of writing the first question I had, I accidentally found the solution (sort of). The issue I was having was when pasting texts that started with hyphens, Excel would (seemingly) randomly ...
0
votes
1answer
28 views

Trying to have a formula that only works if cell greater than zero

I am working on a formula to try and include a formula only when we have identified additional items for one supplier and if there are no additional parameters it should just return the original score....
0
votes
1answer
15 views

How to count values, and then return a number as a value changes

I have a list of grades, which are worked out against grade boundaries in a table. I would like to give the student extra information on how many marks they would need to get the grade above the one ...
0
votes
1answer
39 views

Two formulas into one cell

I am a novice user and have a question to calculate the days between two network days. I would like to have a result, if one cell does not have a date, a result would be "0." based on ...
0
votes
1answer
76 views

Excel: Calculate the number of loan payments between two dates

I have problem I need help with. I have two dates for loan: current date and the maturity date. I also have information about which day of the month/quarter/year payment will be transfered. So the ...
0
votes
0answers
22 views

Two sets of identical rows in two worksheets (different row numbers): addition or deletion of rows in first worksheet gives same result in 2nd - How?

In my workbook I have two worksheets. Let's call them Primary Sheet & 2ndary sheet. In each worksheet I have a set of 20 identical rows with the data in each of these rows in the 2ndary sheet ...
0
votes
2answers
89 views

Find duplicates within each subset of data

I have Doubt in Comparing two Columns. Column B must have Unique Data's with in Column A Duplicates range (range highlighted different colours). Column A have Duplicate Data's > That is need to ...
0
votes
1answer
41 views

If a cell contains an item from a list then print value

I've been searching for this answer and can't seem to find it. If a cell contains an item from a list then print value. A1 = POS Debit - Visa Check Card 5909 - DOLLAR TR 2422 WESLEY PARK B1:B4 LIST = ...
0
votes
2answers
74 views

Return text string for highest duplicate values

I've been battling with a google sheets conundrum so hoping someone can help. In a nutshell, I'm trying to achieve the following based on the image below: Where the name is the same in column C ...
0
votes
1answer
130 views

Count consecutive values in row > 0 being able to control how many values in a row (2 - 3 or more..) and then SUM it

I'm kind of stuck with this I hope you could help me. What I want is to: -SUM but only when there are values in consecutive cells greater than zero. -I would also like to identify and command the ...
1
vote
1answer
53 views

Excel: Match a value from a column and then collect values from a row

I want to enter a value in G2, then it will search from column A. In the picture attached it is A26 cell. Then I need to fill up G4 and G5 cell from column B and D. How can I do it?
0
votes
3answers
71 views

How can I order data from several columns into a new sheet alphabetically?

How can I order data that I have separated in different columns into a new sheet, and order those alphabetically? I would prefer them to be in different columns (one per letter) but if not, having ...
0
votes
0answers
19 views

Compare values in two different sheets, and post a third value from one sheet onto another

I'm to achieve the following. I have two sheets in excel Sheet 1 and Sheet 2. Sheet 1 has 5 columns, with 2 columns for a persons name, one for the DOB, one for a code, and one for when the code was ...
0
votes
0answers
17 views

Excel cell formatting not working for some cells when trying to write in paragraphs

I have an excel sheet and I want to write content in a cell. There are around 2-3 paragraphs and bullet points. When I using the cell formatting feature, it works properly. But once I closed that file,...
0
votes
1answer
233 views

How to run multimple timestamps in an excel sheet

I would like to find a formula to generate a timestamp when a specific cell is updated. The difference is that I need to be able to log MULTIPLE timestamps that would not be changed if another cell is ...

1
2 3 4 5
44