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
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). ...
GBKiryu's user avatar
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 ...
Derek Coull's user avatar
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.
Kqtr's user avatar
  • 103
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 ...
Kaundinya Sistu's user avatar
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] ... ...
Francis Cugler's user avatar
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 ...
Tony Garcia's user avatar
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 ...
Therow's user avatar
  • 1
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 ...
Piecevcake's user avatar
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'...
dimthemainsjfdjlks's user avatar
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=...
Qadeer's user avatar
  • 159
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 ...
Hemanth's user avatar
  • 11
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?:\/\/...
mthq's user avatar
  • 3
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. ...
user12487929's user avatar
-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 ...
ganesh26066's user avatar
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&...
Lloyd's user avatar
  • 1
-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:
xyz's user avatar
  • 13
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 ...
user3482383's user avatar
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 ...
AmericanAnalyst's user avatar
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, ...
manamuchacha's user avatar
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 ...
Kenny's user avatar
  • 77
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 ...
Kenny's user avatar
  • 77
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 ...
Kenny's user avatar
  • 77
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 ...
kedar rao's user avatar
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 ...
Skyline's user avatar
  • 23
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 ...
Siraj Multani's user avatar
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 ...
IT researcher's user avatar
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:...
TT13's user avatar
  • 111
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 ...
Sriharsha's user avatar
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 ...
Shashank Vivek's user avatar
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 ...
dakofsta's user avatar
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 ...
dakofsta's user avatar
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 ...
Eric Knight's user avatar
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 ...
Sirmike's user avatar
  • 21
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 ...
nielsv's user avatar
  • 115
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.
Rishabh Shrivastava's user avatar
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 ...
Rockstar5645's user avatar
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-...
Reonaldo Laxamana's user avatar
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 ...
J Collins's user avatar
  • 678
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: ...
PanchoVilla's user avatar
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 ...
Rahul Kalsariya's user avatar
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 ...
aadish jain's user avatar
-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), ...
Gwen Di's user avatar
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 ...
ACPL Researcher's user avatar
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 ...
Pepe's user avatar
  • 13
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)...
Felicia's user avatar
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, ...
Amin-'s user avatar
  • 1
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 ...
Felicia's user avatar
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 ...
LocoVoco's user avatar
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 ...
Basj's user avatar
  • 1,789
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(... ...
Alexander's user avatar

1 2 3
4
5
46