**0**

votes

**0**answers

3 views

### Excel formula related to if statement

I need a formula which satisfy the following condition:
If A1="Yes", then the corresponding cells B1, C1, D1......etc should contain the word "yes"
IfB1="no", then the C1 should be "no" such that the ...

**0**

votes

**0**answers

2 views

### Restrict paste into dropdown cells in excel

I have one excel sheet which contains many dropdown columns. Lets say one column has Test1, Test2, and Test3 as dropdown option values. Cells under this column should not accept the values other than ...

**0**

votes

**1**answer

9 views

### VBA Code for changing background text for any text within a cell

I'm trying to make a row change colour to yellow based on if any text is within the D column. I have already set up 5 different colours for another cell, however need this to over-ride those ones. I ...

**0**

votes

**0**answers

13 views

### Count non-blank values after a cartesian product in excel

I hope my description is accurate; improvements welcome.
I have 2 tables in Excel.
In Table1 there are 2 columns, A and B. It can be a many to many relationship.
In Table2 there are 2 columns, A and ...

**0**

votes

**0**answers

9 views

### Placement of Secondary Horizontal Axis

On the primary horizontal axis I can go to Format Axis > Line Color and Style. There I can choose the color and style of the line that represents 0 on the primary vertical axis.
However, with the ...

**0**

votes

**1**answer

12 views

### Excel VBA: Intersect methode with several names range

The Intersect don't work.
Dim NTit As Range
Dim NInf As Range
Dim NDat As Range
Dim WS As Worksheet
Set WS = ActiveSheet
Set NTit = WS.Range("$A$1:$J$1")
Set NInf = ...

**0**

votes

**1**answer

12 views

### Publishing an Excel Spreadsheet Online

I'm working with a client that uses very sophisticated excel spreadsheets for generating purchase orders. They would like to place these online so a dealer could use it to submit a purchase order on ...

**-3**

votes

**1**answer

20 views

### Removing a column of hundreds of bad addresses from the main address column [on hold]

How do I remove a column of hundreds of bad addresses from the main address column? Do I have to find/delete each address individually?

**0**

votes

**0**answers

36 views

### Daily Calculation Average [on hold]

I have a calculator that I created for my teammates. The calculator asks for 3 pieces of data that outputs 1 piece of data.
The output is then copy and pasted into a daily tracker by the user.
The ...

**0**

votes

**1**answer

18 views

### Select Cells in Column Up to End of Data in Adjacent Column on OSX

I know there is a command to do this but I just can't find it. The answer here should have used this command but did not.
Q: Given an empty column (B) adjacent to a column populated with data (A). ...

**0**

votes

**1**answer

36 views

### Is there a way to record macros to do things I would normally do in Windows explorer? E.g. Open an Excel file read-only?

Countless times a day, I go into Windows Explorer, shift-right click on an Excel file, Copy as path, then go into Run, type Excel /r (paste), which opens my Excel file as read only.
Is there a way to ...

**0**

votes

**0**answers

16 views

### Spreadsheet finding and sorting most frequent appearance of names

I have a spreadsheet that looks like the following:
https://docs.google.com/spreadsheets/d/1BN3GNRFCsBeHu9gQaKzIo7bfFRkcDqMJ6VMtidEwPD4/edit?usp=sharing
There is a set list of names in Column A. ...

**-1**

votes

**0**answers

20 views

### Excel: sumif, index/match: reached the end of my ability

Im sorry to come begging for help and i have been all over the palce trying to find a way around this.
I have tried all sorts and also done a lot of searching on the interweb... what I have vound is ...

**0**

votes

**2**answers

18 views

### Array formula, slowly work on Excel [on hold]

Does the array formula make excel to run slowly? i'm talking about a range that contain 1000 raws and 10 columns.

**-1**

votes

**0**answers

15 views

### Excel- How to use lookup formulas to look up on part of the content of a cell [on hold]

I created a table with a searchable drop down list that gives you all the prerequisites for the class you choose from the drop down list. I chained it so that it gives you up to five prerequisites ...

**0**

votes

**1**answer

8 views

### cumulative profit of each client in table no 2 from data of table 1

I want cumulative profit of each client in table no 2 from data of table 1
formula i use is ...

**0**

votes

**1**answer

14 views

### Where to put the Change Event Code

CHANGE EVENT: I have 12 sheets in a workbook. Do you have to put the Change Event in the 12 sheet, if not, where I must put the code for this event.

**0**

votes

**0**answers

15 views

### Formula to search two columns of a database and return value from different cell in the matching row

I am designing a spreadsheet for scheduling appointments. On one sheet I have all the data but the dates and times are not in chronological order. I am having trouble writing a formula that will ...

**0**

votes

**0**answers

32 views

### Excel, order column elements by row ID [on hold]

need your help for a sec >
so the problem is in the following, I have a column of numbers:
column A
row ----------
1 1.11
2 2.123
3 2.222
4 ...
5 ...
6 ...
and what I want to ...

**0**

votes

**2**answers

28 views

### import text file into excel

I have a text file that has the following text content:
County Name: test county
Athlete ID Count: 280
Activity Count: 574
Average Distance: 35255
...

**0**

votes

**1**answer

27 views

### Duration calculation in seconds [on hold]

This is what my data looks like. How do I calculate the duration, in seconds. I've tried some an answer but it looks complicated -
=INT(E226-D226)&" days "&TEXT(MOD(E226-D226,1),"hh "" hours ...

**-1**

votes

**1**answer

22 views

### Merge Two Dynamic Tables in One Table [on hold]

I have try to merge/combine two tables but I have always fail.
How can I merge/combine two dynamic tables in one table

**0**

votes

**0**answers

21 views

### Excel timeline summing overlapping values [on hold]

I have an excel spreadsheet with the following values:
Start End Value
1/12/15 5/12/15 6
3/10/15 4/8/15 3
I want a timeline that starts at the earliest date out of the entire ...

**0**

votes

**1**answer

19 views

### Filter data for different data serie to display in XY-Plot

I want to paste the date (see image) in my excel sheet a get a XY-Plot with 4 data series, one for each Method
Until now I filter them by Method and copy each result, so I get 4 tables for 4 data ...

**0**

votes

**1**answer

33 views

### Excel combination 6 [on hold]

Good morning,
I am trying to do in excel all possible combination of 1 to 6 without repeating.
6!
How can I list the 720 possibilities
Thank you,
examples
123456
132456
654321

**0**

votes

**0**answers

19 views

### Excel cell value showing when printed despite font colour and fill colour being exactly the same

In Excel, if I set the fill colour and font colour of a cell to be Gray (RGB 217-217-217) and then type "TEST" in the cell, I cannot see any text but when I print it (I made the cell significantly ...

**0**

votes

**0**answers

12 views

### How to open an excel and prevent the automatice convert the numeric fields larger than 15char

We work with a software that we must export data from and use this information for multiple functions, one is the data is reopened in Excel. Excel converts the numeric fields greater than 15 char to ...

**0**

votes

**1**answer

28 views

### Searching for a value across 2 tables in Excel 2010, returning yes or no

I have one workbook with 3 separate worksheets
Sheet 1 contains 2 columns.
Column A has a range of unique alphanumeric identifiers.
Column B has a range of non-unique numbers.
A B
...

**0**

votes

**0**answers

9 views

### Information into multiple sheets

I run a drag racing promotion company and need some help in creating a workbook for shows. I want to put a master list of names in sheet 1, sheet 2 through 20 will be the different classes. Is there ...

**-1**

votes

**1**answer

13 views

### Creating a button linked to tex and not cell [on hold]

I want to create a button in Excel that is linked only to a word, so that if lines are removed, the button is still linked to the text and not the cell. How can this be done?

**1**

vote

**2**answers

32 views

### Column of Text in Excel

I have a column in my spreadsheet in which each cell is either a YES or a NO. I'd like to produce a NO result even if there is only one NO in the column. I tried
=IF(C4+"NO","NO","YES").
This ...

**-1**

votes

**0**answers

14 views

### Formula copy display only formula [on hold]

Suddently I cannot copy formula from one cell to another it just expose the formula.
this formula is correct, it work in original cell. the destination cell is setup on automatic, If I type manually ...

**0**

votes

**1**answer

16 views

### I would like to add specific text to get total count

I am trying to create a holiday calendar for team. We have defined terms like
H= Holiday
B = Business trip
S= Sick
I would like to count total of H , S &B for calendar year.
How can I do ...

**25**

votes

**8**answers

2k views

### How do I insert a new row in Excel via the keyboard?

Right clicking on a row and clicking insert is fairly time consuming. I'd rather not have to take my hands off the keyboard. How can I insert a new row above my current row using only the keyboard? ...

**0**

votes

**1**answer

22 views

### Frequency formula in Excel 2010

I am just trying to figure a way to get the frequency of occurrence of a number within a large array, not the freq of the number in the array belonging to a range.
Eg, how many times does the number ...

**0**

votes

**0**answers

13 views

### Auto populate data from one worksheet to another [on hold]

I have an excel worksheet with a nominal of employees I would like to be able to filter departments to a separate worksheet I have been trying all day but to no avail.

**0**

votes

**1**answer

37 views

### How do I generate random numbers between a range in cells? [duplicate]

I'm wanting to create a button that generates a string of 10 random numbers into cells, and pulls the range for these random numbers from, for instance, in B1 and B2. Basically, I'm looking to use the ...

**0**

votes

**0**answers

19 views

### What do I need to see if there is matching formula between two cells in Excel?

I'm awful at excel and I'm trying to figure out what I need to do to see if there is matching formula between two cells.
As an example D6 has a number 55, P6 has something like mon200055. Is there a ...

**0**

votes

**0**answers

13 views

### Excel automatically applying styles to new data

I'm having a problem with Excel 2013.
I have a spreadsheet filled with names and related information for applicants. When I contact the applicants, I highlight the cells (using the fill tool) so I ...

**1**

vote

**1**answer

13 views

### Excel 2010 SUMPRODUCT FUNCTION - unable to do date comparison

I run a small share investment club and of course use Excel to keep track of our activities. On one worksheet (Asset worksheet) I am trying (for each company we hold) to add up the dividends received ...

**0**

votes

**0**answers

10 views

### How to make Excel scatter plot axis show months rather than days?

I have an Excel scatter graph that is separating months into 20-day segments instead of the entire days of each month. How do I fix this? I want to have it reflect the days of the month by simply ...

**-1**

votes

**0**answers

8 views

### Is there a short cut key to put MS Outlook for text to column option [on hold]

Hi team i am using windows 7 operating system and king office 2013 software. I have a doubt what is the shortcut key for text to columns in king office 2013 spreadsheets. Help me team

**-1**

votes

**0**answers

8 views

### MacBook Air, OS X 10.9.3 - Excel for Mac 2011 [on hold]

I am trying to save a spreadsheet that was built in a different version of excel and the conditioning formatting formulas are too complicated for Excel for Mac 2011.
Any ideas?

**0**

votes

**0**answers

17 views

### Excel locked columns

-Is is possible to lock a column, for example column F, and then set it so if i scroll from column E, all other columns will appear before the F column. I am trying to set F up at the end of a spread ...

**0**

votes

**0**answers

28 views

### Selecting random entries from lists in Excel with VBA

In Column A, I have n number of names.
In Column B, I have n number of Order numbers for each name.
In one cell I will be inputting the number of orders I want to pick randomly.
Once I input the ...

**3**

votes

**1**answer

22 views

### change layout in excel sheet

I have excel sheet (plz visit link below,unable to post img)
http://postimg.org/image/q4nf8j7qd/
which contain first name,last name,city,address, etc of many person..
A | B | ...

**0**

votes

**1**answer

23 views

### Comparison of two files in excel [on hold]

I want to compare two files including ticket number and amount.How to compare?
I can also send you sample files format.The ticket number and amount is same in file 1 and also in file 2.But,they are ...

**2**

votes

**1**answer

27 views

### Excel averageifs multiple criteria on one range

I know how I can use average(if(... etc using an array, however I'm stuck on how to include other criteria in this
This is what I've got so far:
...

**1**

vote

**1**answer

40 views

### Excel 2013 match values in two workbooks and merge one column

I'm running Excel 2013 and I have two spreadsheets open. The first, sheet1, has two columns and 7k rows the columns are:
A B
ID Description
58749651 a ...

**0**

votes

**0**answers

12 views

### Can Excel automatically create an x-axis range?

I'm doing a basic financial analysis with Excel. The gist of it is I have an input parameter (discount rate) plus a bunch of static data that gets fed into the =NPV(rate, x1...x_i) function. I would ...