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
3k
views
Making X axis be in the exact order and exact value in excel
I'm trying to make a graph in excel where the x-axis is the values of 1/r^2 (The r being the distance in the first column) and the y-axis being the force calculated by Colomb's law (the third column). ...
0
votes
1
answer
66
views
Unable to select range for copying
The behaviour of my excel (2007) changed today, maybe I’ve changed some setting without noticing.
I have a column of values, some values, some formulae. The first cell is a figure (say 100 as an ...
0
votes
1
answer
34
views
Transpose some columns of an Excel table
I am not able to achieve going from this format:
To this format:
I could transpose manually, but there are hundreds of items.
0
votes
1
answer
618
views
VBA code for Multiple inputs search comparison
I need to search from a data in excel using a macro
If for example above image is a default list and if i gave a input using a input box.
Case:1
If input as "a1,a2,b1,c4"
it should reflect ...
0
votes
3
answers
11k
views
How to do hex calculations across multiple cells in excel?
I'm working on a spread sheet and I have a table or grid of [256]x[256] that looks like this:
B c D E F G IY
3 Address: [byte][byte][byte][byte] ... ...
0
votes
1
answer
32
views
Microsoft Excel - getting the right data
I have three 3 lists that a user selects from:
Rating - AAA,AA,A,BBB
Term, 1-3, 3-5, 5-7, 7-10, 10-15, 15+
Sector - Fin,Non-Fin, Sec/Col, Sovereign
I'd then like to pick out the relevant cell from ...
0
votes
0
answers
63
views
Which Excel formula is more elegant for this data?
I'll try to be succinct and I'll provide an image for clarity at the bottom.
The problem:
I have a large set of data consisting of City resources (publicly available) which includes the information at ...
0
votes
1
answer
428
views
Conditional Formatting to show cells with contents overflowing BOTTOM border
I have emails exported to excel and need a conditional formatting rule to highlight cells which have contents continuing below the bottom cell border (for example the cells marked red below:)
I have ...
2
votes
1
answer
626
views
ExcelFuzzyLookUp: Compare Cells In The Same Row
I'm trying to compare two cells that are in the same row and same table. I've been trying to use Fuzzy Lookup to provide a measure of similarity but what happens is that the cells move to match what I'...
0
votes
1
answer
214
views
Requesting Formula for 4-days work and 4-days off including weekends to schedule tasks
Experts,
I need help in formulating the below example for 4-days work and 4-days off based on hours scheduled. I'm able to do for straight days. Please see the details below.
Formulae Used
in cell G9=...
1
vote
2
answers
2k
views
Highlight dependent and precedent cells that are sitting across various worksheets in a workbook
The shortcut Ctrl+], which is used to highlight the dependent cells is not working across different worksheets...though the shortcut works pretty much fine in a single worksheet (where both the cell ...
0
votes
1
answer
925
views
Excel formula to format URL Regex
I need to create Regex for Black listing that takes all variations of URL - http:// or https:// with or without www. I came up with this:
Url:
https://www.example.com/contactus.aspx
Regex:
(https?:\/\/...
1
vote
1
answer
32
views
Excel - Number issues
I am trying to put 13:73 in the cell, but everytime I put that and I click enter, it will automatically change to 0.592361. I went to format cells to see if I can get back 13:73 but that did not work.
...
-1
votes
3
answers
675
views
How to find the value in the cell above 3 searched-for numbers in Excel
I want to search a list of numbers for a sub-list of other numbers. If the sub-list is found, in the same order, then return the value in the cell immediately above the found sub-list.
If I use this ...
0
votes
1
answer
70
views
Excel 2007 Sum, if, and not working
The following formula worked in a previous version of excel but in 2007 returns a value #name?
In cell J17 I have the formula
=IF(H16=""I""I(SUM(H10-H16+2)+SUM(IF(AND(K4<=18IK4&...
-1
votes
1
answer
206
views
How to group by multiple column and perform difference operation and and match the nearest value of column from difference [closed]
I'm trying to get a result which comprises grouping 3 rows and try to minus specific value with a column and try to extract a column value from with minimum difference with the specific column.
ex:
4
votes
2
answers
36k
views
How to have a color-specified scatter plot in excel?
I have a table of information in excel in which I have a column for some attribute and two columns of for example X and Y information. I want to plot them in scatter form but with specified color for ...
0
votes
3
answers
355
views
How to find which column contains the first occurance of a number in a single row? (Excel)
I have an Excel sheet with over 100 dates as column names and hundreds of locations as row names.
There are numbers (could be any number) somewhere in each row that indicate that an event will occur ...
0
votes
1
answer
73
views
How to split and numbering of 2 columns into 4 columns by 50rows each?
I have a list of entries (A2 to A2000 in numbers, B2 to B2000) with headers (A1 and B1). On the same sheet, how do I split them into columns and numbering them in sets of 50 each?
For example,
...
0
votes
2
answers
375
views
Excel Formula to return everything after a specific set of characters in a string up to but not including the next number character in a string?
Excel 2007
I have a string in cell A1 and I need a formula to go in B1 to look at the string and find a specific character ) and the next numerical (number) character after the characters kHz and ...
3
votes
1
answer
374
views
Use IF(A1="" and IF(ISNUMBER and SUBSTITUTE in a complex nested formula?
I have a fairly complex (to me at least) nested IF(ISNUMBER formula that I would like to wrap or include SUBSTITUTE to remove "" from the result of the formula and replace the "" with a space " ".
I ...
0
votes
1
answer
113
views
Excel Formula Select all text between (but not including) two characters and replace all _ with a space?
In cell A1
I have text like AB_CD_(EF_G_H)_1234
I am trying to write a formula that selects the text after (but not including) the ( character and before (but not including) the ) character and then ...
0
votes
1
answer
55
views
Rows to a Pie chart or a table
Sorry if a similar question is posted earlier.
I have a survey output which has rows like shown below
Agree
Disagree
Strongly Agree
Agree
5.Agree
Disagree
7 . Not Applicable
Agree
...
..
...
I ...
2
votes
1
answer
115
views
Excel - How to find a number exist in which sheet
I have 10 sheets in a excel file.
Sheet2 to Sheet10 are raw data, and every sheet A1 has that sheet name, like this
Sheet2
colA colB colC colD
row1 Sheet2
row2 ...
0
votes
0
answers
417
views
Delete Multiple rows based on criteria from Multiple CSV files in a Folder
Option Explicit
Sub Delete_Rows_From_CSV_Files()
Dim source_folder_name As String
source_folder_name = "C:\Users\Siraj\Documents\CSV FILES\" 'change the path to the source folder accordingly
...
0
votes
0
answers
74
views
When opening read only excel file save as dialog box is displayed
When I open read only excel file save as dialog box opens and I can't read file without saving a copy of it.Also a new excel file created in desktop can't saves the modification . Every time save as ...
0
votes
1
answer
72
views
Excel formula to calculate based on another field's contents
What I want to achieve is, to create a universal formula for Bob, George, Charles, to calculate
their balance based on "Affects balance" field.
So in the example below results would be following:
C3:...
0
votes
2
answers
98
views
Excel Large Data to Summary Table
In the attached excel workbook contains 2 sheets, First one is data and second one is Result.
In the Data sheet, "A" column contains the length (10 meter) and "B" column contains the type of pole to ...
2
votes
2
answers
46
views
MS Excel: INDIRECT with an ! (exclamation) followed by some string name
I am new to excel macros I am trying to get my head around the macros. I have figured out that
=INDIRECT(A1 & "!D1")
will reference to A1 cell and then look for that sheetname and find its D1 ...
1
vote
1
answer
74
views
Creating an excel formula to calculate returns
So I have a dataset of monthly stock returns from January 2000 until today for six different stock indices. At the bottom of the page, I want to show the yearly return for each year as a percentage ...
0
votes
1
answer
101
views
How to get the percentage change with intervals on Microsoft Excel?
So I have a dataset of monthly stock returns from January 2000 until today for six different stock indices. At the bottom of the page, I want to show the yearly return for each year as a percentage ...
1
vote
1
answer
106
views
In Excel 2007, how do I remove duplicate lines, while merging data
To help you understand the question, here is a sample:
I have this:
Name - Account# - Address - . . .- phone
Mr. A . . 4278 . . . . 123 Main . . . 555-1212
Mr. B . . 7532 . . . . 435 ...
2
votes
2
answers
86
views
matching all highlighted dates in one column to those of another column
I'm currently stuck on this step of my project. image of my document My ultimate objective is to highlight all highlighted dates in column P in column M. I was wondering if there was a formula so that ...
1
vote
1
answer
39
views
Excel count numbers, with taking day of today in account
I have an Excel sheet that looks like this:
In the column "Total" I have the total amount of minutes that need to be executed.
In the days after the "Todo" column I have the number of minutes that ...
0
votes
1
answer
60
views
What should I do if I have to match one column with another column in excel in the same spreadsheet?
I need to find out how many rows in column B match with rows of column A.
2
votes
3
answers
7k
views
How should I design the spreadsheets for 3 dimensional data?
My supervisor asked me to go through a word document. It's a list of all the issues found in a building by the night guard, sorted by month. Things like, lights were left on in this room, or the door ...
1
vote
0
answers
72
views
Convert two numbers to a range
I want to convert these two numbers into a range so that when I find a number between them, I can still find it.
My data:
[Column 1] [Column 2]
Ticket Start Ticket End
000-000-001 000-000-...
0
votes
0
answers
48
views
Data validation backward compatibility bug
I have been given a spreadsheet made in Office 365 that uses data validation on several cells. The validation uses a range of cells from another sheet in the spreadsheet.
When opening the document in ...
0
votes
3
answers
2k
views
Cell value change with Month
I'm trying to have certain dates out of the week from day 1 to the last day of the month when I type a month in a cell for example:
If cell "I6" Contains "March" or whatever month:
...
0
votes
1
answer
70
views
Filter data issue on a data filtering formula
I want to sort my list in different sheets as mention value in cell. I want same value formula , that list currently I am uploading excel file in which >= formula is working but when I am going to ...
0
votes
1
answer
33
views
referencing cell based on specific data in excel
I want to get the cell address (column number and Row number) based on the data it has.
Example: Cell A1 has value 8 and column B has number 1 to 100 in random order (no value repeating twice). I ...
-1
votes
1
answer
487
views
I want to scan down column 1 and if, for each cell, it matches any of the cells in column 2 I want it to return the entry in column 2 it matches
I want to scan down column A in sheet alpha (alpha!A) which is a list of emails such that if, for each cell A1,A2,...AX, the said cell matches any of the entries in column D of sheet beta (beta!D), ...
0
votes
2
answers
1k
views
Finding Specific Duplicate Text/Strings in Two Different Cells
I had a quick question regarding how I might find exact duplicate text/strings using a formula or macro. Here are two of my columns for example:
With those columns in mind, I would like to have a ...
0
votes
2
answers
1k
views
VBA Save ONLY VISIBLE Sheet as Workbook
I was working with the following VBA (attached below). It works great, and what I like the most is that it is Path/Name independent.
I am now trying to save multiple reports which are based on some ...
0
votes
1
answer
75
views
NOT SURE WHAT IF FUNCTION CAN BE USE
I have this details, And I want my remarks to be automatically populated depends on what kind of PAPER I have.
Example
Column A - (Sales#) : 1234
Column B - (Warehouse) : FLOWER
Column C - (Purchase)...
0
votes
0
answers
72
views
Dependent dropdown list in Excel
I have a table. I have three columns, 1-Company, 2-Product, 3-Area. The data is unordered and duplicate values are also there.
Then below the table, I am doing working... I can use cell validation, ...
0
votes
2
answers
94
views
search value of its corresponding date within the range of date
I want to find if the data of its corresponding date is in the next working date.
I use =VLOOKUP(WORKDAY(A2,1),A:B,2,FALSE)=B2 but the problem is I have numerous data like almost 10,000 rows in a ...
2
votes
2
answers
114
views
Designing student monitoring sheet
I want to design a monitoring Excel sheet to keep track of my students' progress.
It should look something like this:
In the example picture, I'd be interested in assessing each student's performance ...
6
votes
3
answers
478
views
How to merge rows with Excel?
I have a worksheet containing:
ID VALUE1 VALUE2
--------------------------
ABC 8274
DEF 613
GHI 236
ABC 11.13
XYZ 173
GHI ...
0
votes
1
answer
49
views
How do I conditionally format to highlight cells with =-IF in the formula?
I have a large workbook with many sheets, each with two sections in them.
One section, the formulas should begin
=IF(ISNA(...
and in the other section the formulas should begin
=-IF(ISNA(...
...