**0**

votes

**0**answers

6 views

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

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

**17**

votes

**8**answers

1k 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? ...

**6**

votes

**9**answers

13k views

### Why is Excel 2010/2013 taking 10 seconds open any file?

I have a fast Windows 7 PC with two SSDs and 16GB of RAM, so I'm used to programs loading very fast. But recently, for no reason I can figure out, Excel has started taking way too long to open Excel ...

**0**

votes

**0**answers

5 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

27 views

### Duration calculation in seconds

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

**4**

votes

**1**answer

2k views

### Linking Excel 2013 cell to Word 2013 table cell adds unwanted line breaks

I have a problem where I am trying to copy an excel cell that contains content using a formula, into a word document table cell and link them such that the formatting is used in word.
What happens is ...

**0**

votes

**0**answers

8 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.
Thank you
Jane

**0**

votes

**0**answers

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

**1**

vote

**3**answers

40 views

### Excel - stipulate an average for random number function

I am wondering if anyone knows if there is a way to use the RANDBETWEEN function to generate a series of random numbers in Excel but also make those random numbers come out to equal a specified ...

**0**

votes

**0**answers

29 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

23 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

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

**5**

votes

**4**answers

13k views

### Check if Excel cell text is numeric using formula only

I have to find out if my cells text is a numeric value and wanted to use an elegant non VBA method that doesn't impede on its current state or value.
What I've found is that the ISNUMBER() function ...

**-1**

votes

**1**answer

17 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

18 views

### Excel timeline summing overlapping values

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

30 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

14 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

**1**answer

23 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

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

**-1**

votes

**1**answer

12 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

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

**0**

votes

**0**answers

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

**3**

votes

**1**answer

3k views

### Create progress bar or milestone type graphs in Excel 2007

I want to display project progress in Excel 2007. Is there a way to show a progress bar like graph filled for completed percentage and empty until end date for a milestone or the whole project? It ...

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

**17**

votes

**10**answers

52k views

### Why does Excel treat long numeric strings as scientific notation even after changing cell format to text

I'm trying to process some data in Excel. The data includes numeric account numbers and other long numeric strings (like cell phone MEIDs). I am not doing math operations on these strings, so I want ...

**0**

votes

**1**answer

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

**0**

votes

**1**answer

35 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

12 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

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

**6**answers

19k views

### My excel spreadsheet won't sort/alphabetize properly

I have a spreadsheet with multiple columns and over 4000 rows. I need to sort, then alphabetize my report and everytime I do, there are 43 rows that do not sort with the rest of the report; they go ...

**-1**

votes

**1**answer

17 views

### Excel macro to group rows based on a cell value

I have a hierarchical list of items in an Excel worksheet and want to create a macro to group each row based on a cell value that gives the level of indention. The data looks like this:
Index Level ...

**1**

vote

**1**answer

2k views

### Query parameters in an external connection to sql server

I want to do exactly this:http://dailydoseofexcel.com/archives/2004/12/13/parameters-in-excel-external-data-queries/ but I want to do it in Excel 2010 and also I am querying SQL Server instead of MS ...

**0**

votes

**1**answer

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

**0**

votes

**0**answers

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

**1**

vote

**1**answer

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

**5**

votes

**3**answers

4k views

### Colour coding blocks of rows using conditional formatting

My macros have been taken away; never to be used again! I'm gutted. I now need to use formatting to help me highlight the different users and their data. Doing this manually is a chore.
Using Excel ...

**0**

votes

**0**answers

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

**0**

votes

**0**answers

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

**31**

votes

**5**answers

119k views

### How to remove the print preview lines in Excel 2010?

Somehow or other I have managed to switch on the print margin lines in Excel 2010. I cannot seem to turn them off. I went to Page Layout->Page Setup->Print Area->Clear Print Area but the lines remain ...

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

15 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

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

**0**

votes

**2**answers

42 views

### How to get SUM and COUNT in the range

I have dates in one column, names in the next column and counts in other column.
I want the formula to count the individuals as per the date.
1. For example, on 11/1/2014, I want Sum of Kiran's ...

**0**

votes

**1**answer

26 views

### How to constant 0 in the range when the number is not inputed

In cell A1 I have number entered as 10. If I delete the number 10 from the cell A1 I want 0 to be constant in the cell A1 automatically instead of manual entry of 0?

**0**

votes

**1**answer

76 views

### Track username and date when the sheet open

I'm using VBA to display a welcome message with the username. Additionally I want to keep track of the username (taken from environment variables), date and time in one of the sheets.
For example: ...

**0**

votes

**1**answer

23 views

### In excel shared workbook can you insert data and not replace on conflict?

I have 2 users that asked for a shared excel workbook a while back.
Now after the holidays they complain that the workbook creates conflicts and that this issue never happened before. The file just ...

**3**

votes

**1**answer

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

**2**

votes

**1**answer

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

**3**

votes

**1**answer

6k views

### How can I move linked Word/Excel files without breaking the links under Windows 7?

I currently operate under Windows XP and have multiple links between my Word and Excel files. I have to upgrade to Windows 7. When the .doc and .xls files are converted to .docm and .xlsm, ...