# Tagged Questions

**-1**

votes

**1**answer

21 views

### How can I merge 2 sheets in excel?

I have to update a defect database in excel that is filled with data that fluctuates between 160 to 700 rows every day. This database has 19 columns, some of which are numerical and some are ...

**0**

votes

**1**answer

7 views

### Create custom parts for the header and footer in Excel

I have a spreadsheet with several worksheets. On each printed page of each worksheet I would like to have references to some fields that i define somewhere in the document.
More specifically, i would ...

**0**

votes

**0**answers

11 views

### Horizontal/Column filtering in Excel? Should be simple

In Excel it is straight forward to apply a filter on a column (mark the region of interest, klick on data>filter). This way you get the handy option to show the content corresponding to, e.g., a value ...

**0**

votes

**1**answer

16 views

### How can I return corresponding value from Master List by comparing Child List?

I have 3 columns MasterList, Value and ChildList. Now I want to compare Childlist against Masterlist and get the value from corresponding MasterList.
I have below values in worksheet.
MasterList ...

**0**

votes

**1**answer

18 views

### Convert Array to String with Excel Formula, is it possible?

Convert Array to String with Excel Formula, is it possible?
I know how this would be done with VBA, but I have to share my workbook, and I have to assume that other people will not be able to enable ...

**0**

votes

**2**answers

27 views

### Find most frequently used value

I know that that question has been asked before but my question needs more scalable solution!
I have a column G with States, there are 10,000 States in that column.
I need to find out what is most ...

**0**

votes

**2**answers

27 views

### Excel: Do not open files in multiple instances

How do I open all excel files in the same instance/window by default (happens only when I open from the menu, but not from the windows explorer)?
I have this option unchecked, but is still not ...

**0**

votes

**1**answer

31 views

### How to disable specific Excel 2010 add-ins at startup?

I want to disable specific add-ins from loading in Excel 2010 every time I open up a new workbook or instance. How do I achieve this?
When I disable the specific add-ins by unchecking them in the ...

**0**

votes

**1**answer

42 views

### Compare Excel Columns A & B and return C

I am a High School Principal and I need help figuring out how to use excel to create a class tracer for my students. A tracer is a spreadsheet that tells you what classroom a student is in during a ...

**0**

votes

**1**answer

19 views

### LO Calc / Excel - Dropbox change another cell

I am creating a simple Point of Sale System for a store using an excel/libre office spreadsheet.
The spreadsheet has a sheet called "Inventory" which has the following columns:
Name
Price
This ...

**1**

vote

**2**answers

31 views

### How to highlight calendar cells based on given start and end date

For a while now, a coworker has been using a chart similar to the one shown below and wants to automate it (i've already added the days before/after due date).
The chart is printed or worked on at ...

**-3**

votes

**0**answers

28 views

### I need to know the formula for below [closed]

I need the formula to find the intersection value on table.
now when i enter the zone & billable weight, then it want to show the correct intersection value & one more trick is also know the ...

**0**

votes

**1**answer

32 views

### in Excel, Can I replace “sheet1!” with a formula?

I have 100 sheets named as 1,2,3....100
then in each sheet, there's a value in cell A1.
I am building a summary sheet now, in the summary sheet, I want A1 = 1!A1, A2 = 2!A1, A3 = 3!A1 ...... A100 = ...

**-4**

votes

**0**answers

24 views

### Excel copy paste if macro vba [on hold]

In excel, can you help me build a macro/vba for this task:
Copy-paste $M$1:$N$1 to Column M:N, if Cell in column C="price".
Thank you all!

**0**

votes

**0**answers

47 views

### Plot two time dependent series in Excel 2010 when the number of data points are different but start and end time are same

I'm trying to plot graphs for pressure and temperature recorded on different devices.
The number of data recorded for each device is different (Eg. pressure has 1 reading per second while temperature ...

**0**

votes

**1**answer

24 views

### Highlight Duplicates Not Next To Each Other Using Conditional Formatting

We have a list of parts in Excel in a certain order. For reasons I won't get into, we need to highlight when there are duplicates that aren't next to each other. Currently, I'm using this formula in a ...

**0**

votes

**1**answer

24 views

### How to compare a column with previous column when the new column has more data sets in it?

I am trying to compare weekly account sales numbers to their previous weekly amount. However the new week has more accounts in it (on average 50 more) than the previous one, how can I add these ...

**0**

votes

**1**answer

27 views

### How to apply formula to a cell dependent on data from drop down list

I hope I can word this to where it makes sense. I'm working on a budget. Basically broken down by month. So in the budget, if it is February, I have to estimate the remaining months of the year. I ...

**0**

votes

**1**answer

23 views

### Chart the TIME something happened on a series of DATES

I have two columns of data.
Column 1 is the DATE (i.e. 1/5/2011 )
Column 2 is the TIME a thing happened on that DATE (i.e. 16:42 )
I need the DATE to be on the X axis and the TIME to be on the Y ...

**0**

votes

**1**answer

25 views

### Random Sampling in Excel based on specific criteria from other colums

I have a list of file numbers in Column A, a code associated with the file in column B, and a number of days in column I. Example:
File Code Days
12345 AAAA 100
54321 AAAA ...

**-2**

votes

**1**answer

19 views

### Return segment of statement that makes it TRUE

H I J K L M
Lenght Width Height Compare_Length Compare_Width Compare_Height
3.750 3.750 4.500 3.750 3.750 ...

**0**

votes

**2**answers

20 views

### Sort Excel Row Based on Values in Another Row

Sorry if this question has already been answered, I looked but I didn tfind anything that was quite what I am trying to do.
I have a lot of spreadsheets where I have something like:
A|B|C|D|E|F...
...

**1**

vote

**2**answers

117 views

### How to fit mm/yyyy in SUMIF criteria

I've looked around for answers regarding this, but am still a bit confused. I have a column A in Excel with dates in the format mm-yyyy (i.e. September 1014 is Sep-14). I want to add all the values in ...

**0**

votes

**0**answers

31 views

### how to get exact value from Y axis and X axix for any point in chart

I have a chart with line graph. now for a particular point on the line how can i get the exact co-ordinates from Y axis and/or X axis.
For example if the major unit on Y axis is 200 and Minor unit is ...

**2**

votes

**1**answer

26 views

### Excel 2007 Formula Issue - Newbie

I have a cell containing 5;9;11;13;15;17. There could be upto 15 different numbers in the cell. These numbers represent attributes.
For example 5 = Padlockable, 9 = Keylock etc. There are around 50 ...

**-1**

votes

**0**answers

21 views

### Standard deviation per month in certain year excel

So I have a dataset containing daily stock prices of over 20 years. The dates are the top row and all the companies in the first column. And per date per company is a certain return. Now i want to use ...

**0**

votes

**0**answers

18 views

### link excel sheet to word doc and be able to change multiple cell values at one time [closed]

I would like step by step instructions on how to link excel sheet to word doc and be able to change multiple cell values at one time. I have linked up several tables but then if I move to another ...

**2**

votes

**2**answers

34 views

### How can I get information from one cell in a row, based on the clue of 2 other cells in the same row?

I'm trying to get Excel to give me information in Column C based on the values in Columns A and B.
Cell A and Cell B will contain duplicates, and what I'm trying to do is build a formula which finds ...

**1**

vote

**1**answer

28 views

### Openoffice / Excel combine multiple worksheets into one

I have not yet found the exact answer to my specific problem, so let's give it a shot :
The Layout :
1 SharePoint Farm on which a report was run, returning 6 Excel Files with each containing 250 ...

**1**

vote

**1**answer

30 views

### Excel formulas: Dates A, B, C and D. How many days between A and B also fall between C and D

Example:
A1 = 8/5/2004
B1 = 29/12/2004
C1 = 1/1/2003
D1 = 21/11/2004
I want to work out how many days between A and B also fall between C and D. I can't get my head round what the formula to work ...

**1**

vote

**0**answers

15 views

### How do I change the function field in excel to show Bengali Characters?

I received an excel file that has columns translated from english to Bengali. I have a Bengali font installed and it shows up in the main body of the spreadsheet but the characters are not showing up ...

**0**

votes

**0**answers

13 views

### Dynamic Scenario output in excel

I have a model where in the input numbers going into the model depend on the cases/scenarios i select from a drop down menu ( Base, Best and Worst). These numbers are then used across all remaining ...

**1**

vote

**1**answer

23 views

### Flip x and y axes in Excel graph

This should not be very difficult, but I cannot figure out how to do it.
I have a table similar to this
%low %high
0 0 12
1 13 26
...
19 90 94
20 95 100
When I graph it, excel ...

**0**

votes

**0**answers

21 views

### direction does to RTL in Excel when I add sheet

When I add a new worksheet to my workbook in Excel 2010 (by clicking the button insert worksheet next to sheet names), one sheet will be added and the direction goes to RTL from LTR automatically and ...

**1**

vote

**1**answer

41 views

### Use data from a drop down list to populate table

I am trying to make an employee recognition tracking tool. I would like to have in sheet 1 a drop down list of all the employees in the hotel and a drop down list of the month.
When an employee ...

**-1**

votes

**2**answers

28 views

### Excel: Complete row Hash Value calculated as a Numeric value in a cell on same row

I have to manage "Change Control" on Excel spreadsheets comprised of 1000's of rows and dozens of columns.
Downstream Teams often submit revised columns that I have to incorporate into a master ...

**0**

votes

**4**answers

50 views

### Excel - How to add cells that have letters and numbers

For example:
A1 - "AA123"
How do I get B1 to read "AA124" and C1 to read "AA125"?
I know that in A1 I can drag the box to the right and it will populate with this, but I need a formula for this. ...

**-1**

votes

**1**answer

38 views

### Closest thing to variable in Excel formulas( not VBA)

I have following formula
=MID(G34,FIND(" ",G34),FIND(" ",G34,FIND(" ",G34)+1)-FIND(" ",G34))
G34 ="begining middle end"
The goal of this formula is to return "middle" and it achieves it, but the ...

**0**

votes

**3**answers

42 views

### group values in set of 5 and then return the first value from each group

I have a long list of values of a stock in minute format. The column C shows the open values(per minute) and column F shows the corresponding close values
Now I want to covert this data into 5 min ...

**-1**

votes

**1**answer

32 views

### Excel conditional formatting based on time values

Hi i need to create an Excel template like the cells will be loaded with a timestamp like
2014-09-29 16:02:59.112213
I need to provide a condition like, if the timestamp is less than 3 AM, its ...

**0**

votes

**2**answers

54 views

### Is there a way to use Regex( or comparable solution) in Excel formulas?

I have a spreadshet that requires me to do some matching,namely speaking its a list of bonds, their tickers(names) and some data about them. I want to match their tickers(names), I know how would ...

**0**

votes

**1**answer

24 views

### Adjust sequence position of barcode scanning result

I've been improve our warehouse record method by barcode scanning.
But the problem defaut scanning result inside excel format is after scan cursor will move to below cell ( ex : A1 to A2 to A3 etc).
...

**-1**

votes

**2**answers

32 views

### larget/smallest number in a range in excel without overlap

I have a sheet with 1000 rows and 5 columns.
1) What I want to do is in a cloumn find the biggest number in 5 adjacent row (e.g. row 1-5 in column A). then find the biggest number in next 5 rows (i.e. ...

**-1**

votes

**1**answer

19 views

### Microsoft Excel 2010 Search for Specific Text and copy it to new cell

I have a list of single words in a column A1:A10.
In row A11:G11 I have words which could include a word from the list. If it does it could be the only word or appear together with another word in ...

**0**

votes

**0**answers

27 views

### I need a macro to separate a column of names into 4 different shifts

Our system creates a report for accuracy. Our manager wants it separated by shifts. From those lists, it will go to a report 'by shift' along with the information on the row with each.
I need a macro ...

**-1**

votes

**0**answers

26 views

### vba method cells of object _global failed

I have this vba code. In the conditional statement, if the met condition is in env2, the code works fine. however if the condition met is in env1, the code fail with the error run-time error 1004. Why ...

**1**

vote

**1**answer

75 views

### Plotting multiple datasets of different lengths on the same scatter graph in Excel 2010

I have two data sets each containing 10 coloumns of data.
X values in data set 1 go from 380 - 750 in steps of 5
X values in data set 2 go from 250 - 2500 in steps of 1
Data set 1 is permanent and ...

**-3**

votes

**0**answers

57 views

### I want to compare two different columns and get a value from another workbook using VLOOKUP

I want a value from the workbook(2) by comparing two different columns from workbook(1) using VLOOKUP.
I want a VLOOKUP coding like, if WorkBook(1)columns A matches with workbook(2) columns A then it ...

**-2**

votes

**1**answer

51 views

### Excel, using cell text references as input for formula

First of all thanks for your help. I have a problem regarding the use of text into formulas. I am working on a huge dataset of stocks of several years. The stock are not correctly grouped. I used an ...

**0**

votes

**1**answer

27 views

### Massive number of obsolete defined names in Excel = huge file

At my current job I discovered that many Excel files were unnecessarily large, a file with a single worksheet and simple table can be more than 2 MB and Excel seems to be very sluggish at times. After ...