**1**

vote

**1**answer

77 views

### Lock color scale (convert to fixed)

I have used conditional formatting to apply a color scale to a range of values. Now I would like to permanently freeze those colors. I have poked around a bit, and can't find event the beginning of ...

**0**

votes

**2**answers

23 views

### If/Then (# to Text) With Multiple Number Ranges

I am using Excel and trying to create a formula. Part of the formula works, the next doesn't. I'll explain.
Column P is "BPM" (Beats Per Minute) and will have a numeric value, which will be entered ...

**0**

votes

**1**answer

18 views

### Changing current mail merge to use new source data

I have a mail merge file that I created last year, I would like to use a new source data file to create new post cards.
Can this be done and how do I go about doing it? I really don't want to create ...

**3**

votes

**1**answer

36 views

### Extract content from the formula in a referenced cell in Excel 2007

I have a cell A3 that says Name.
Cell F16 contains =A3, which displays Name, just like I want it to.
I need cell F26 to take the information from cell F16 and display the referenced location. In ...

**2**

votes

**1**answer

136 views

### Looping through master sheet and filter out rows that are needed

I have created a script which I want to allow a user to select a file (Master File) and if a condition is a met I want to Copy the data to the excel workbook (which the script is run on) The code ...

**0**

votes

**1**answer

44 views

### Excel Formula with conditions

This feels like it should be simple but my head is hurting now and I'm struggling.
I need to add a condition to an existing sheet which already contains formulas and references to other sheets.
...

**1**

vote

**1**answer

186 views

### How do I recover a previous version of an Excel file which was overwritten? [duplicate]

Does anyone know of a way to recover a previous version of an MS Excel (2007) file in Windows Vista Home Premium version, which I've accidentally wrote over?

**0**

votes

**0**answers

36 views

### Having trouble graphing big data in Excel (3500+ rows, 2 columns)

I really need with help this issue. I'm trying to show a relationship between two categories but the only problem is there's too much data!
Problem: Is there a relationship between X and Y?
X and Y ...

**0**

votes

**0**answers

41 views

### Is this possible to generate excel combo box based on cell value?

As you can see, Cell C2 got 1,2,3,4. I assume this is a student id. So, I would like to generate a combo box in Cell B8, using Cell C2's data, separated by ,. So, in this case, the combo box should ...

**4**

votes

**1**answer

183 views

### Add multiple series to a dynamic chart

I have a large amount of data stored in a table that is used to update about 8 charts (through named ranges). Each chart has the date and ID as the x-axis with a particular parameter being charted. ...

**0**

votes

**1**answer

112 views

### In excel how could I generate a row of data from another sheet?

In excel I have a sheet named "sales", and another one named "factor".
In factor I have some fields for factor ID, customer name, product code, quantities and price.
I want when I add this data to ...

**1**

vote

**1**answer

41 views

### Excel - pivot date values with max function

I am trying to pivot date values in a pivot table in MS Excel. I am getting incorrect date values. I do not want "Grand Total" as they do not apply for dates. Is it possible to do such pivots in ...

**1**

vote

**0**answers

75 views

### Excel lookup value not on same row

What i`m looking for is that the data will be filled automatically from data table by lookup value in not same row.
See the picture
or xls example https://dropmefiles.com/BDlHe
1st table lookup ...

**1**

vote

**2**answers

135 views

### Bypass Excel file selection confirmation for data connection with non-.txt text file

I have an Excel workbook that processes model output from another program. That program produces space-delimited plain-text output files with a ".plt" extension. I have a data connection in Excel to ...

**1**

vote

**1**answer

36 views

### 2010 Excel formula dilema [closed]

I am trying to set up an inventory spreadsheet using 3 worksheets. the first one has the items in inventory and their counts. the second sheet consists of the number of items used at an event which ...

**1**

vote

**0**answers

65 views

### How to prevent enabling editing in Protected View in Excel 2013 from altering chart formatting of Excel 2000-2003 and 2007-2010 workbooks

In Excel 2013, when opening and enabling editing from Protected View a macro-enabled Excel workbook downloaded from the internet, with two versions in .xls (Excel 2000-2003) and .xlsm (Excel ...

**1**

vote

**0**answers

78 views

### Why am I getting an error in this Excel module that runs access queries and copies results to the workbook?

I have written a module in excel to run 6 access queries and copy them into the excel workbook. My code works perfectly until I get to the 5th and 6th query then I get the error;
Run-time error ...

**1**

vote

**1**answer

56 views

### Conditional formatting based on specific cells

Is it possible to set conditional formatting based on a value written in a specific cell?
I would like to colour the rows of saturday and sunday and not colour the working days.
The condition is ...

**0**

votes

**0**answers

132 views

### Excel formula works on one sheet but not the other. Non-blank max number

I'm trying to calculate the max number between 2 non blank cells in column A, using the values in column B when B>C. There are no blanks in B:B. C is always blank unless C>B.
...

**0**

votes

**0**answers

12 views

### Excel match number in differ worksheets

I have a excel spreadsheet with 2 worksheets. Both contains a column with serial numbers.
Is there a way to create a 3rd worksheet where all serial numbers in worksheet 1 which match worksheet 2 ...

**0**

votes

**1**answer

136 views

### Excel, pair 2 columns, then find all rows where column J is in two different Column D

SO I would like to have a formula or macro, to look at a table in Excel, pair two columns say J and M. Then find rows where M is connected to more then one value of Column J, Column J is Super Group, ...

**-1**

votes

**4**answers

4k views

### How to capitalize the first letter in a cell in Excel

Recently i came across excel with cells filled with small cases,Is it there any easy way or macro to capitalize each word of the excel?
For E.g Consider the below image :
After conversion it ...

**0**

votes

**0**answers

155 views

### How can i sort data with macro in different worksheet?

I use the following code for sorting a sheet in a workbook with a macro but when I open another workbook, it doesn't work.
How I can I change the code so it can run in another workbook as well using ...

**0**

votes

**1**answer

122 views

### VLOOKUP where the column to look for is a drop down list?

I am doing a little format in which I call data from other cells, from other worksheet to fill it out. I am using VLOOKUP to do that.
So as an example I have:
Name: (Drop down list)
Sex
...

**0**

votes

**1**answer

230 views

### Excel max number between 2 non-blank cells A, in column B (given no blanks in B) [closed]

I need to calculate the maximum number between 2 consecutive non-blank cells in A, but using the values in B. ie. use a formula in column C that will give me the results I manually plotted in D. ...

**0**

votes

**1**answer

140 views

### If Column value = string then add row next to column to sum

I want to make an expense chart In Excel.
I have two Columns, one for type of expense and one for cost of expense.
I made a few categories where the types are summed. The types are Entertainment, ...

**-1**

votes

**1**answer

52 views

### Formula issue Microsoft Excel

I need help urgently for a work problem.
So basically, the summation of opening stock and production give total stock.
While closing stock is ((opening stock+production)-sale)) and stock cover is ...

**0**

votes

**1**answer

300 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

291 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

17 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

44 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

73 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

47 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

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

**1**

vote

**2**answers

99 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

122 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

37 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

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

**1**

vote

**1**answer

2k 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

60 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

54 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

96 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

45 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

164 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

117 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

46 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

60 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

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

**2**

votes

**1**answer

57 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

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