**0**

votes

**1**answer

31 views

### How to use INDIRECT with a SUMIF formula for a date range

I'm trying to get a SUMIFS formula to dynamically work with multiple tabs in an excel workbook. I have numerous tabs in this workbook, each that contains client data I update daily. In the example ...

**1**

vote

**1**answer

34 views

### Excel: Write a 1 or 0 value if condition is met

Sorry if this has already been posted, but I just started today playing with Excel macros and I need a hand. I have a data column with values and I would like that if the conditions were met, the ...

**0**

votes

**0**answers

10 views

### Adding data table onto another table using matching identifiers

How do i add fields in one data table onto another data table using matching identifiers in excel.
I have two data tables in separate sheets that I want to merge adding all of the fields from the ...

**0**

votes

**0**answers

10 views

### open excel using .bat when excel error “file in use” is returned

I have created a .bat file to open Excel, then my Excel workbook which contains a macro which runs on open, all on a scheduled task timer. The problem is that occasionally the Excel files are not ...

**0**

votes

**1**answer

41 views

### Is there a way to exclude keywords in a VLOOKUP formula?

I have 3 sheets in Excel. In the 1st one there is a column with hotel names and another one with ID. I want to get that ID from the ID column on the 2nd sheet where I have the names as well.
The ...

**1**

vote

**1**answer

20 views

### fit a table in a middle of an excel sheet

I have a table in a sheet like this:
I want to place the table in the middle of page. but the number of column is odd (5) and the number of column in the sheet is even (8). there is 2 cols after ...

**0**

votes

**2**answers

45 views

### Excel help - extract info from middle of cell

Is it possible to take the words 'each', 'Any 2 for', 'kg', etc... out of these cells and put them into another cell... leaving only the $x.xx price so it can be sorted.
Examples for above are:
1) ...

**-2**

votes

**0**answers

22 views

### Multiple Function [closed]

I need a similarity function. But I need Column A, row 1 to be an assigned number (i.e. 11013) which is then spread among many worksheets where A2,A3, A4 usually show differing results dependent on ...

**1**

vote

**0**answers

17 views

### Excel shortcut to set font size and bold

I have an Excel budget spreadsheet that as items (cells with numbers) are paid, I make the font bold and size 14.
Is there a way to create a shortcut to do this with one keyboard move instead of ...

**0**

votes

**1**answer

40 views

### How to select only the first max value in excel? [closed]

I need to make an operation on a cell and I choose the one with the maximum value.
If it happens that there are more than one cell with the max value I need to do the operation only to the first one, ...

**1**

vote

**0**answers

23 views

### Opening a file with a # in its path using the default application from Excel 2007

I have a pdf file which is located at "D:\some\#folder\filename.pdf". And want to open it from an Excel worksheet by clicking on a hyperlink (or something similar).
Just creating a hyperlink does not ...

**0**

votes

**1**answer

40 views

### How do I Reference all non-blank cells after row A6 for a Formula

I want to use the following formula:
INDEX(A6:A94,MODE(MATCH(A6:A94,A6:A94,0)))
Except the exact number of rows is ambiguous (imported using VBA).
How can I reference all non-blank cells starting ...

**0**

votes

**1**answer

40 views

### How do you format numbers in Excel for Indian Currency (Rupees)?

Currently the Excel default formatting is:
1,000,000
500,000
How do you format the number to use the comma separator (,) like this
10,00,00,00
50,00,00
This is is how Indian Currency (Rupees) ...

**0**

votes

**1**answer

34 views

### How to prepend numbers to typed values in column [duplicate]

I need to manually enter a list of six-digit codes in a column. Each code starts with the same two-number prefix, 03.
e.g.:
030144
030289
030283
Is there a way that I can type just the last four ...

**0**

votes

**1**answer

20 views

### How to get a formula to extend to new cells depending on pivot table

I have a pivot table with some formulas using the data from the pivot table to the side of it. My problem is that if I add a filter, say city, so that the pivot table extends down, the formulas to the ...

**1**

vote

**2**answers

29 views

### DATEVALUE() gives different values for similar data

In one column, I have timestamps in the format Jun 10, 2015 11:36:51 AM
So, to get the date from that column, I created another column and used the formula
=DATEVALUE(CONCATENATE(MID(D2,5,2)," ...

**2**

votes

**1**answer

35 views

### Not getting desired output with VLOOKUP - Need assistance

I have Table 1, which looks like this -
A1 B1 C1
1 X Date11
2 Y Date12
3 Z Date13
I have another table, Table 2, that looks like this -
A2 B2 C2
1 M Date21
2 N Date22
3 X ...

**0**

votes

**1**answer

27 views

### How to keep pivot table from expanding into occupied rows and columns

I have a pivot table with other calculations surrounding it. My issue is that if more row/column groupings are added to the pivot table, it extends and reaches the cells where these other calculations ...

**-1**

votes

**1**answer

38 views

### Excel Vlookup range or if function

I have been struggling to find a formula that works for the example below (see question mark!). What i am trying to do is merge 2 datasets. The problem is that the common identifiers are not always ...

**0**

votes

**1**answer

36 views

### What formula would you use to add up a column based on results from two drop down menus? [duplicate]

I would like to calculate a column based on selections from two other columns with drop down menus.
For example :
In one column, "C" you have 3 options (A team,B team,C team), In column "F" you ...

**1**

vote

**1**answer

35 views

### Excel SUMIFS based on two criteria

I would like to total a list of minutes based on two criteria to make a graph after the data is calculated.
The item "Department" (Column C) and "Day of Week" (Column F) are both drop down menus.
I ...

**2**

votes

**1**answer

43 views

### How can I use Excel to monitor my payable?

Here's what I wanted to happen, I have five columns
Supplier Amount Payment Supplier1 Supplier2
When I have a receipt of my payable, I'll encode the name of supplier and it's amount. When ...

**1**

vote

**1**answer

34 views

### Need to add newline(s) and space(s) inside a cell in Excel

I have data in an Excel cell which is delimited by ,.
For example: abc,bde,fgh.
I used the formula =SUBSTITUTE(A2, ",", CHAR(10) & CHAR(13)) to change the commas to line breaks. Therefore, the ...

**0**

votes

**1**answer

48 views

### Excel countif formula that will subtract from another number if cell contains certain values

I am dealing with job applications for 8 different sites. People can apply for any combination of sites i.e 1 of them, 2 of them, all of them.
Some applicants have specifically said they don't want ...

**1**

vote

**1**answer

21 views

### Summing up values from a user-defined range

I have a spreadsheet from January 1 to present. and I needed to sum up the value parallel corresponding from the range which the user defines.
For example:
in Column A are the dates January 1 - ...

**7**

votes

**2**answers

92 views

### Conditional concatenate cell content across rows

I have a worksheet with thousands of rows which contain a unique ID A, and one 3 different error codes M. Each individual ID may have 1, 2 or 3 errors. They will always be in the same order.
I have ...

**0**

votes

**1**answer

31 views

### Copy multiple Rows and paste using formula [closed]

In Excel, columnA I have values which need to be tripled in columnB
So I currently have
A
1 val1
2 val2
3 val3
I'd like each value to be tripled in column B, such as
A B
...

**2**

votes

**1**answer

26 views

### How to prevent office 2007 from opening an *.xls file?

I recently installed Office 2007, parallel to Office 2003, so they coexist :)
The thing I didn't anticipate is, that Office 2007 will bruteforce its way around.
I don't want it to open old (*.xls - ...

**0**

votes

**1**answer

47 views

### Microsoft Excel 2010 if(or(and I am confused

I am trying to query two cells by using If function but unfortunately have no luck. I will give you an example below. Please let me know how I can solve this issue.
If C2="Car" and D2="Toyota_Mazda" ...

**0**

votes

**0**answers

11 views

### Finding all entries if one is less than 10

I have two columns. One contains names the other contains times in hours and minutes. There are about five times as many hours and minutes as there are names. So each name has about five entries.
...

**0**

votes

**0**answers

47 views

### Excel: Find duplicates among 2 colums

Giving an excel file with 2 columns:
A: 5000 numbers (some repeated)
B: 525 unique numbers
I want to know if for each number in A there is a instance of that number in B.
Meaning: for A1, is ...

**0**

votes

**2**answers

58 views

### Excel - Manipulating data in awkward format

I have a dataset that I want to analyse, but it is in quite a strange format. See below:
> Account_Details Account_Name
> account # 1 client name
> product 1 name ...

**1**

vote

**1**answer

20 views

### Cell references in formulas keep moving with old data in Excel

When I update Excel to the latest figures my formulas keep moving with the old data. I have already tried using absolute and or relative references like $A$1, $A1, A$1, and A1. I've also tried using ...

**0**

votes

**0**answers

14 views

### How do I split a worksheet into multiple files dependent on the column values, calculate sub-totals and plot graphs?

I have a large data set and would like to split these into separate files/worksheets and perform the same analysis over each data set.
I have found a macro to split the data into separate ...

**0**

votes

**1**answer

20 views

### Word got hidden in cells for long sentence?

When I write in cell of Excel 2007, and the sentence is long, it is hidden.
I want it to return to next line. Is it possible please ?
As you can see in this screenshot, the Hello world sentence is ...

**0**

votes

**1**answer

13 views

### Is it possible to sort a column by word in Excel 2007?

I would like to sort a colomn of my excel file following a "word".
I mean to sorting by word. Is it possible in Microsoft Office Excel 2007 ?
If I have :
AHG hELLO
BFF ...
FOO ...
AHG HI
DCE ...

**0**

votes

**1**answer

50 views

### VBA highlighting a cell if corresponding range in the same row is not blank

I am trying to enforce food name in column B of a file if column D to DX (Qty) has any value in it.
Rational is if any new request of food is received which doesnt appear in the file, the user can ...

**-1**

votes

**1**answer

37 views

### How do I isolate certain characters in cell content of an excel to new cell?

How do I isolate certain characters in cell content of an excel to new cell
Example: I have a big paragraph of information wrapped in a cell and I need to separate only few characters of that data ...

**0**

votes

**1**answer

26 views

### Force external link in Excel to break if the file can't be found

I have an Excel spreadsheet that has an external link to another spreadsheet. What I want to happen is if
Main_Spreadsheet.xlsx
Secret_Data.xlsx
When someone opens Main_Spreadsheet.xlsx and they ...

**0**

votes

**3**answers

67 views

### Compare two sheets in Excel and extract the differences to other third sheet

My situation:
I got a huge excel sheet from a manufacturer of products for my online shop. This format:
product ID | price | name | ...
Every week the manufacturer is sending me a updated list ...

**0**

votes

**1**answer

20 views

### MS Excel cell references shifting after using a macro?

Basically this is what happens:
On Sheet1 I have a column of cells that are linked to other cells on sheet2. Looks something like this.
Sheet1!A1=Sheet2!A1
Sheet1!A2=Sheet2!A2
Sheet1!A3=Sheet2!A3 ...

**0**

votes

**1**answer

50 views

### Why does excel tables break VLOOKUP formulas

I have a worksheet using raw data that Excel does not identify as Tables (ie. plainly putting values in adjacent cells), and on another part of my worksheet, formulas doing lookup in that data, like
...

**0**

votes

**0**answers

52 views

### Display the content of Column A when I put a 'X' in Column B

I have a workbook that contains the projects that I'm working, in many tabs.
Each tab has one column that contains the name of the project and another that is an 'on going' column which I mark with a ...

**0**

votes

**1**answer

31 views

### How can I import a TAB delimited file with double quote text qualifier into Excel if a cell value already contains a double quote?

I am trying to import a TAB delimited file with the following format into Excel 2013
"Column A" "Column B"
"tjc0056421151r" "I\gs]hü"nsf^f\F*lqog\düûWp"
"tjc0058088269r" ...

**0**

votes

**1**answer

25 views

### Excel 2007. I can't enable macro when I open document for second time

The document work perfectly on my computer with office 365, windows 7. But when I copy it to another computer with office 2007 and windows 7, it start normally ( I enable macro and it make everything ...

**0**

votes

**2**answers

29 views

### Month by Month Pivot Table

I have a list of dates and data that go back a year. In Excel, I made a pivot table that shows all these dates. In the columns label under data filters I see a lot of weekly, monthly, yearly ...

**0**

votes

**2**answers

36 views

### Excel - Dynamic Cell Update using multiple criterias

I would like to know if there is a way in Excel to create a cell that will display a value using a formula that will calculate the latest entry by date and campaign.
If I have 3 columns DATE | ...

**0**

votes

**1**answer

82 views

### Is there a limit on the number of rows a sum function can calculate in Excel 2007?

I am trying to sum a column of 50938 values in Excel 2007 but keep receiving a "#VALUE!" error. The cells in the column do contain formulas. I also tried to sum the column after copying and pasting ...

**0**

votes

**1**answer

25 views

### Microsoft Excel 2007

My gradebook spreadsheet has student assignment headings in columns B-H and their final grade average in column I. Student names are in Column A in descending order.
How can I print out Column ...

**0**

votes

**1**answer

114 views

### Sheet name dynamically assigned from a cell value

Sub CreateWorkSheetByRange()
Dim WorkRng As Range
Dim Ws As Worksheet
Dim arr As Variant
Dim template As Worksheet
Dim xTitleId As String
On Error Resume Next
xTitleId = "Select Range"
Set WorkRng = ...