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

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.

0
votes
0answers
11 views

Formula to ignore or treat as empty a cell that contains another formula with no result?

I'm using Excel 2007 I have a Cell B14 which contains a formula getting data from a different worksheet and sometimes this formula may have no result. I need a formula to ignore Cell B14 or treat it ...
0
votes
1answer
21 views

How to multiply a row of values to a table with the same number of fields?

I have a row of value from A2:H2 and then I have a table of values from B7:E8 (both the table and row have 8 data points). How do I go about multiplying them? Please see the bellow illustration: +---...
0
votes
1answer
22 views

How to reference a shape by name and what else can be used in .Select?

I use MS Excel 2007 My question is in two parts I have a form option button called "Option1" How do I refer to that button in other macros? I know that I can select it using: ActiveSheet.Shapes("...
0
votes
2answers
58 views

Tell a macro to check if object exists and if yes do A. but if no then do B.?

I use MS Excel 2007. I have the following code in a macro that creates two Option Buttons (not active X) into Cell B25. Range("B25").Select ActiveSheet.OptionButtons.Add(129.75, 540, 24, 20.25)....
0
votes
1answer
14 views

Macro/VBA Code to List and print names and code of all macros in a workbook

I am using Excel 2007 For this question the name of my workbook is PrintCode.xlsm Is there a Macro or VBA Code that will print all of the macro names and code within the open workbook? I have found ...
0
votes
1answer
17 views

Exactly position new option button in VBA

Is there a way of exactly positioning and sizing a new option button in VBA or a macro? The code I am using inserts a new Option button in which ever cell is currently selected within a worksheet. ...
1
vote
1answer
83 views

Excel 2007 - Can't combine these three formulas into one cell

I have three separate formulas each in it's own cell. Each formula has multiple criteria looking at data within a workbook. The way the formulas work is that only one should produce a result and ...
0
votes
2answers
47 views

Microsoft Excel 2007 - Formula To Populate Cell C1 based on Cell A1 Without A List?

I am trying to write a formula make excel place data in a cell based on the contents of a different cell BUT the formula cannot be in the cell where excel places the data. If we take the below simple ...
-4
votes
0answers
22 views

Pulling equal Random sampling [closed]

How do i pull random samples in equal proportion?
0
votes
2answers
41 views

Is there a quick way to do a common date-time format in Excel?

Can someone please help me find, built into Excel (any version) a ready-made format for Date/Time like: MM/dd/yyyy hh:mm AM/PM I can't imagine this is not a common format? 10/05/2018 05:03 PM I like ...
1
vote
1answer
30 views

Speed up Excel Index Match - First Instance

I'm using the below formula to look up the first instance of a name appearing in an email (Column L). I have around 40,000 rows and the formula is getting slower and slower as new rows (emails) come ...
0
votes
0answers
15 views

excel 2007 hyperlink function to link cell to pdf in same folder

I am completely new to this and trying to find a way to save time creating hyperlinks so I can quickly find drawings. I have a spreadsheet which lists drawing numbers in one column, has their ...
0
votes
1answer
40 views

Replacement for 'sum_range' in SUMIFS formula that can match automatically with source data header

Need your help, through SUMIFS formula, I need the result to be like the one in D5 column. From the formula box in picture, we can see that I wanted to know the ad cost between July 6 to July 8 which ...
0
votes
1answer
25 views

compare 2 values within 2 ranges

I have 2 columns with both positive and negative values. Let the columns be A and B. I need to find a condition that matches both values of A and B. i.e. if -3.485 < a < +2.1254 value and -4....
1
vote
2answers
84 views

Filtering Excel Data by Column Value and Saving Columns to Individual Files

Many years back we had to come up with a solution to survey results that we were getting via CSV. Back then we'd get data where the first column was e-mails, and subsequent columns were 1's or null ...
0
votes
1answer
63 views

Excel: Is it possible to bind cells in a row together based on value?

I have recently used this solution to create a dynamically generated list of uniques. What it does is it takes cell values (here: list of names) and generates another list without repetition. Let's ...
0
votes
1answer
42 views

How to keep references unchanged after sorting

In the following spreadsheet, the references will change after sorting and break the calculations. Absolute referencing is not an option. The table has to be copied periodically to another sheet and ...
2
votes
2answers
44 views

Finding specific seconds in a cell with time

I have a column of times in hh:mm:ss format. I need to identify each cell in the column that ends in :01 (XX:XX:01). With Excel's time function, a =right(cell, 3) search doesn't find them. Any ...
3
votes
1answer
65 views

Trying to use the dates on the first column and have them separated into month, day and year in another column

Trying to use the dates on the first column and have them separated into Month, Day and Year in another column. The dates on the first column has random blank spaces in between and on the results ...
1
vote
1answer
42 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
3answers
353 views

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

Every time I copy-paste some numerical data written as fractions or separated by hyhens into Excel, it always converts numbers that could possibly be dates into dates. There's no way of getting them ...
0
votes
0answers
27 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
83 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
31 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
162 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
33 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
106 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
75 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
32 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
49 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
36 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
68 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
71 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
1answer
37 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
36 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
165 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
390 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
35 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
39 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
111 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
2answers
49 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
154 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
18 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
51 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
64 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 ...