Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange
Join us in building a kind, collaborative learning community via our updated Code of Conduct.

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.

1
vote
1answer
29 views

Excel MIN with nested IF statement — Trying to ID a date closest to 30 days after a date

I have 16K plus records with an Auction Date. I need to find the date and amount that is closest to the Auction Date BUT more than 30 days later. I have calculated a row that shows the difference ...
1
vote
2answers
97 views

How to fix Excel and prevent it from converting copy-pasted strings to dates even when cells are formatted as text

Every time I copy-paste some numerical data written as fractions or separated by hy[hens into Excel, it always converts numbers that could possibly be dates into dates. There's no way of getting them ...
0
votes
0answers
16 views

Excel - How do I change the color of a data bar based on its value

I have a column in excel that has been formatted to display a progress bar based on the value in the cell 0 - 100. I did this by going to: Home > Conditional formatting > Data bars > More Rules: ...
-1
votes
3answers
77 views

Excel Formula IF/AND with MIN Calculating Due Dates

I'm creating a spreadsheet for payment plans. I am trying to create a formula to calculate the due date based on the $ amount and enrollment date. I want the formula to calculate for different tiers ...
0
votes
2answers
26 views

Excel offset from two different workbook, create a copy of one without affecting the other

I am using two different workbooks the first one [Excel Data only] created as a databse and the second one [Invoice Template] created to create an invoice. When creating an invoice i am using offset ...
0
votes
3answers
118 views

Excel Formula to Select only items from a list which are within a limit based on selected criteria

We are working with a table of hundreds of projects, with a total value well above our budget. In order to prioritise the projects, we have decided to select the oldest projects first, selecting all ...
0
votes
1answer
13 views

Is there a way to link workbook data without getting REF errors when a row is deleted?

I currently have two workbooks, workbook 1 and workbook 2. Workbook 1 - Sheet 1 is directly linking data to Workbook 2 - sheet 1. I am linking by inputting the below formula into workbook 2. ='[...
1
vote
2answers
86 views

Excel Formula Assistance

this is my first excel post ever so I hope you can help me on this. I'm stuck trying to figure out how to do this formula. In here, I have Form Input where the start date, end date and outlet are ...
0
votes
1answer
46 views

Using formulas in Excel 2007

I'm having a problem which I can't solve. I want to count number of occurrences of multiple cells fulfilling a given criteria. Its something like this- Da Ex Av Da Ex Av Da Ex Av 80 55 ...
0
votes
1answer
30 views

Copying cell from one sheet to another without formatting

probably a simple one to your geniuses however I need a fresh pair of eyes as I've been on this a while and can't see my error. I'm merely wanting to copy the contents of a cell from one cell to ...
0
votes
1answer
45 views

Copying only certain cells from a row to another worksheet

I have a workbook that has a large number of sheets designed to help my team manage their workload more efficiently. When someone requests a job to be done, a row is added to a sheet called 'pending ...
0
votes
1answer
29 views

Input data from one workbook form into another workbooks worksheet

What I am trying to achieve: I have one workbook with an application form to request additional training. A person fills out all the cells on the form and clicks submit. I then want all the data ...
1
vote
2answers
59 views

Separating comma delimited data from one cell to multiple cells when the entry is a live data link

My Excel model imports live data from some trading software. If I insert the following formula, I get the details of current tender offers, which are constantly changing: =RTD("rit2.rtd",, "...
1
vote
1answer
63 views

How do I conditionally format all rows in a table, to display a different colour based on a cells value

I have developed a table (as seen below) which is designed to show a persons duties based on priority. If a person clicks the toggle on/off button, this will toggle colours on the rows of the table, ...
0
votes
0answers
27 views

Extract distinct row values from a sheet to another sheet based on max dates per unique rows

I want to extract rows based on max date or max B per unique values of col A and col c. Doesn't matter if it is vba or excel formula. Help please. Old Sheet New Sheet [2
1
vote
2answers
59 views

Is there a way to use excel's VLOOKUP with multiple criteria?

I'm attempting to create an aggregate of data that looks at a list with a lot of duplication of items and compiles a total number that the duplication appears, and a unique value associated with the ...
0
votes
0answers
7 views

Hide/unhide rows based on cell value in Excel two or more raw

I am using the following code to hide rows if cell values are 0: Private Sub Worksheet_Calculate() Dim LastRow As Long, c As Range Application.EnableEvents = False LastRow = Cells(Cells.Rows.Count, "...
0
votes
2answers
68 views

Excel freezes when running macro

Private Sub Worksheet_Change(ByVal Target As Range) Dim KeyCells As Range Dim i As Integer Set KeyCells = Range("H4:H100") If Not Application.Intersect(KeyCells, Range(Target.Address)...
2
votes
4answers
324 views

Group and sort the rows of a table

I have a table where column A contains a unique value in every cell. Column B is either empty or contains a number. | A | B ---+---------+--- 1 | Gamma | 1 2 | Echo | 5 3 | Alpha ...
0
votes
1answer
28 views

Index match finding the first value only

I have a list of employees with duplicates and each employee has a number which represents the number of sales. I'm trying to use the following formula to extract the highest sale for a given name, ...
-1
votes
3answers
73 views

How to divide duplicate rows in excel?

Say I have: ============== | a | | a | | a | | a | | b | | b | | b | | b | | b | | b | | ...
0
votes
1answer
77 views

Preventing the entry of formulas in cells

I'm using MS Excel 2007. I would like to restrict the data entry of some cells in a worksheet to certain numeric values and also forbid the entry of formulas in those cells. As an example, given ...
0
votes
0answers
28 views

Excel formula problems/questions

My dates in excel is as follow - 01/07/2018 - 31/07/2018 I already have a formula to extract the second date (31/07/2018) with =MID(G4, FIND(" ",G4, FIND(" ",G4)+1)+1,256) But I need to have the ...
2
votes
3answers
36 views

I need an excel formula to tell how many numbers and alphabets are in a cell

Hey Guys I need help sorting series of plate numbers out on excel. so I have a sample BMA759JA, and I need a formula that tells me how many Alphabets are contained in the cell and how many numbers ...
0
votes
3answers
110 views

Office 365 - Excel Advanced Filter - Mass Multiple Entries

I've got over 16 000 line entries (stock). Out of the 16 000 I only want to filter 320 of the multiple stock codes in the "ITEM_CODE" column. Instead of selecting one at a time going through that huge ...
0
votes
1answer
43 views

Excel 2007 Cut and paste formula or value without changing cell formatting - paste options greyed out

I just need to cut cell contents leaving the source cell format unchanged, and paste matching destination cell formatting... I think not an uncommon ask? I have searched but Google search filter ...
3
votes
2answers
146 views

Need help Excel Formula [duplicate]

I need help to compose a formula in excel. Basically picture below explain what i need, this is just a sample. In column E is many different entry. From time to time I need to SUM in column G from ...
0
votes
0answers
16 views

create a diagram per row, use first line as horizontal axis

I have a table like this: with about 20 rows. For each row I want a diagram like that: I only found one way of creating the chars. And this is like that: Select a row (for example A2:F2). Create ...
1
vote
1answer
47 views

How to use if statement to merge cells depending on selected value

I am a photographer and I want to create a weekly time sheet for my photo shoot bookings. Some sessions are 1 hour long, some are 2 hours, 4 hours... etc. So I created a table and a dropdown list ...
4
votes
2answers
29 views

Count non-empty cells that fulfill a criterion

Here is something that should be basic, but I cant' figure it out. So, I have information in columns A:G. Some of the cells in columns B:G are empty, others not. In the following spreadsheet, how ...
0
votes
1answer
62 views

Issues with getting RSS feed from reddit into excel

I have an excel sheet that all of my colleagues and I share and open each day. I have been thinking and trying to get an RSS feed from Top comment on /r/Jokes from the last 24 hours into being ...
0
votes
1answer
72 views

Update table starting from today's date in Excel

I have an excel worksheet similar to the following - Col A - Clients name, Col B - Col D - Cient's info such as address, Phone no etc and Col E - Date of next meeting. I want to create a table ...
1
vote
4answers
129 views

Counting multiple ranged criteria

this is my first post on this forum, so it's probably presented in a very bad way. I am using Excel 2007 to collect some data for my thesis. I have recently learnt how to nest COUNTIFS inside ...
0
votes
1answer
151 views

Remove two or more words in a cell based on lookup value

I want to remove the words "FaKe TaBLet" in B2 into a new desired results like in C2, which is 'great number two' using (as far as I know) Reverse partial lookup or other formula instead of using '...
-1
votes
1answer
22 views

Place a String separated by commas into the Excel rows

I have a String like this separated by the commas: id, payment_request_id, user_id, market_id, exchange_id, type_id, nominal, ask_price, original_rate, min_execution, from_date, to_date, state, ...
0
votes
0answers
156 views

How to return column headers based on VLOOKUP result?

I have a complex lookup problem. I am trying to extract the column header information from qualifying columns of a data table, based on the contents of a row found via VLOOKUP. The images below show ...
0
votes
0answers
11 views

Excel formula to get first non-empty value, looking from right to left, and return that value to a cell

I have increasing dates in a row but each row stops in a different column. I want to find the most recent date, i.e. the date in the fares right column and enter all the dates underneath each other in ...
0
votes
1answer
17 views

Excel 2007 Graph scale showing blank dates

I have the below data: Date Planned Complete Carry Over 11-May-18 1 0 1 15-May-18 3 0 3 16-May-18 6 0 6 When I insert a Bar Chart, it is ...
1
vote
0answers
33 views

Filter data by day, 1 and 2 days before a date in another column - MS Excel

I have a data in two columns. I would like to filter it. First column - called Filter me should look up to the right cell next to it and if the date in the Filter me is the same or 2 days before the ...
1
vote
2answers
33 views

Assign to several cells using Excel If-Else Statement

A number of students are divided into groups for a project. The projects are marked and the group scores are assigned to each student in that group. A sample Excel sheet is attached. The equation ...
2
votes
1answer
26 views

Conditional Formatting - Excel 2007

This is driving me nuts. I have a very simple set of rules I wish to use. The cells show an increase or decrease as a percentage of a previous result. I want: If a percentage is above or equal to 1 ...
1
vote
2answers
340 views

Comparing 4 digits in excel

I need to compare like 3425 with 2478. if the 1st digit (from left, 3 and 2) matches it will check the 2nd digit and go on with 4th digit. IF only 1st digit match assign 1, first 2 match then 2, first ...
0
votes
1answer
117 views

In Excel, how do i create a formula to tell me if the last entry is new from the last 6 results

I'm trying to get a formula that's a bit above my level, and hope someone can help. I have in column "K" numbers, randomly from 1 to 12 depending on other results.ie, column K, row 2 =5, row 3 =8, ...
0
votes
1answer
143 views

Is it possible to remove specific characters from a cell based on color and retaining formatting?

TL;DR: Is it possible to remove specific text in a cell, based on its color without losing remaining formatting other cell contents. Thus far any working solution can remove specifically colored text ...
1
vote
1answer
27 views

Microsoft Excel - How to cumulatively add a range of values with a changing reference cell?

This is not very easy to explain, so let try using an example: Basically, I want to cumulative sum the range of values in column C if the values belong to the same category (in column A). The ...
-1
votes
1answer
59 views

VLOOKUP returning ELSE values for exact matches?

I'm new to VBA and I can't seem to figure out why my code is not working. I'm trying to VLOOKUP values in the Z column to see if there are any "NO" or "NOT SURE" values and return a value such as "N"...
0
votes
3answers
38 views

Compare a date to a list of holidays

In excel, I want to compare a date, lets say column A1, to a list of dates in a matrix, A2:F9 and report if its a "holiday". I have all the holidays in the matrix where the years are listed on the ...
0
votes
1answer
56 views

How to format a cell to auto-highlight a date that is in the past

I am trying to find a way to auto-highlight a cell in a specific color if the date entered in the cell is in the past compared to today's date. If today's date is 4/26 and I enter 4/23 into the cell,...
1
vote
3answers
173 views

Microsoft Excel - merging cells with date and time

I have Columns K and L, each with date and time. I want to merge the cells in the row of the two columns into one. By manually merging takes up a lot of time. And if I use formula such as concatenate, ...
2
votes
1answer
58 views

Making up point from two numbers from different cells in Excel

I have two numbers in two different cells. In cell A1, I have 340. In cell B1, I have 7. Now I want to do calculation like below: =A1/1.B1 The point here is: I want to use B1 as decimal point number,...