# 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

**0**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**0**answers

22 views

**0**

votes

**2**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**3**answers

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

**0**answers

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

**3**answers

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

**2**answers

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

**3**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**0**answers

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

**2**answers

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

**4**answers

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

**1**answer

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

**3**answers

73 views

### How to divide duplicate rows in excel?

Say I have:
==============
| a |
| a |
| a |
| a |
| b |
| b |
| b |
| b |
| b |
| b |
| ...

**0**

votes

**1**answer

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

**0**answers

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

**3**answers

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

**3**answers

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

**2**answers

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

**2**answers

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

**0**answers

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

**1**answer

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

**2**answers

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

**1**answer

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 ...