**0**

votes

**0**answers

80 views

### Excel file is locked by another user on sharepoint and he is not at work and none is able to edit it

as this user is not available now we cant wait until the person comes and need to release the lock immediately for others use.
This file is used by many and one user locking it for edit and leaving ...

**0**

votes

**3**answers

76 views

### Combine rows in Excel

I have data in column 1 and data in column 2 as follows:
1234 eggs
1234 bacon
1234 toast
4321 Orange Juice
I want it to appear as follows:
1234 eggs-bacon-toast
4321 ...

**1**

vote

**1**answer

32 views

### How to print cell value as many times as its neighboring cell value (unpivoting)

I have some data that is pivoted or summarized that I would need to "unpivot". The data looks like this:
1000000 6
1245142 4
1245246 6
I would need it to look like this (each value in first column ...

**1**

vote

**1**answer

33 views

### Return Earliest Date from a range

I have an excel spreadsheet where I want to pull the earliest date in the column based on the criteria in a different column (for a given tech) into a different sheet. Rows on sheet1 contain store ...

**1**

vote

**2**answers

3k views

### In an Excel chart, how do you craft X-axis labels with whole number intervals?

I have a sorted list of values that I'd like to see graphed in an Excel chart just to see the shape of the curve. Here is the initial chart:
Looks ok, but the X-axis is ugly, so lets clean that ...

**1**

vote

**0**answers

62 views

### Microsoft Excel 2007: When trying to save - “File in use. Try again later”

When I open an Excel document from server, edit and then try to save the changed document, I get the message that "path\filename is in use. Try again later".
I can use "save as" and save a new ...

**0**

votes

**2**answers

52 views

### Formatting columns in microsoft excel?

I have a list (.txt document) of telephonenumbers with first and surname and number.
Like this :
123123 john doe
123132 michael jordan
etc.
I want to put the list in microsoft excel that after a ...

**0**

votes

**0**answers

26 views

### Excel 2007 : find the rows depending two date columns

I am having an unorganised table where the leave data of employees is entered through a form. The data is
A B C
empname leave from leave upto
john ...

**1**

vote

**1**answer

336 views

### Conditional Formatting in excel based on another column

I have an excel worksheet and two columns. I highlight the first column if the value of the cells are less than 0.
Now how can I highlight the second column cells based on the first columns that are ...

**1**

vote

**1**answer

107 views

### Need a Excel script to identify email addresses that contain a different variation of the first name of the contact

I have an Excel spreadsheet with 50k+ rows of data, where we are trying to identify within the rows of data where the email address has no match of the first name, etc.
We are basically trying to ...

**0**

votes

**0**answers

47 views

### Displaying some cells data depending on selected text from other sheet

I have an excel sheet which looks similar to below and with some more columns.
Area Branch Empolyees Products Shelfs
Area1 Area1 Branch1 10 Product 1 10
Area1 Area1 ...

**0**

votes

**2**answers

29 views

### Excel Number Formatting - not to be carried into copied cell

Open a new sheet and type in any cell (28.33943576)
Change the format to 4 decimal places to show (28.3394)
Copy the cell into a new cell as value only (copies 28.3394)
Now if you click on the copied ...

**0**

votes

**1**answer

50 views

### Highlight duplicate value cells dynamically

I have stored numbers in nine rows and nine columns.
When I select a particular cell I want to highlight all cells with same value e.g. if I select cell having value 8 all cells having value 8 ...

**0**

votes

**1**answer

376 views

### Populate empty table with data from oter table based on dropdown list selection

I have 3 tables, Tab1, Tab2 and Tab3 containing data and an empty table Tab
The user can select in a drop-down list, option1, option2 and option3.
On the selection from user the empty table Tab will ...

**0**

votes

**3**answers

64 views

### Need help on using a few excel formulas together

I have some particular data in sheet1 and some other data in sheet2.
I need to compare a specific value(Var1) from sheet1 and return a specific value from the sheet2, and return an output for the ...

**0**

votes

**0**answers

286 views

### Fill a web form with data from excel (macro)

I am new to VBA and I am struggling to find a solution for my problem. I have an excel database with UNs and PWs for a number of profiles. I also have an administrator UN and PW and each time I want ...

**0**

votes

**0**answers

34 views

### Conditional filter in excel

In my stock, I have a column for showing location of items:
I want to show specific floor instead of all during print out including blank/a b c d row with single click.
Whenever I select All in ...

**0**

votes

**1**answer

274 views

### Excel 2007 - Using combination of Countif and Indirect

I have numeric data in column P in 50 different sheets ( each sheet has different person name). I have one summary Sheet which has names of all the worksheets in column A. In summary sheet column B ...

**0**

votes

**2**answers

46 views

### Excel 2007 - refering value from other worksheet in another function in excel

I have two worksheets. I have data in Sheet2 in column A for which i want to use average function. In sheet1 i have values in only two cells. B1 cell has value 5 and B2 cell has value 15. Using these ...

**0**

votes

**1**answer

153 views

### Disable custom view in Excel

I am using a shared excel workbook that everytime a user accesses it and saves it, it
saves a Custom View for them. I want to disable this settings so that every one can see only same view of the ...

**0**

votes

**2**answers

41 views

### “#REF!” appears in cell after referred-to cells are pasted in

On Office 2007's Excel on Win7, I have a file with a formula like AVERAGE(A29:A33) in cell A34. I then copy four vertically-adjacent number-containing cells and paste them into cells A29:A33. At ...

**0**

votes

**1**answer

17 views

### How to delete and retain a particular value in a cell based on the value of a certain cell?

How to make a vb code to delete the contents of Column B when i entered a specific value in column A?
Example: If cell A1=apple, cell B1 should delete whatever value it have. But if cell A1=grape, ...

**0**

votes

**2**answers

144 views

### Why is that sometimes the excel goal seek doesn't stop exactly at zero

I am trying to do find a solution of a variable using goal seek. The problem is that the value needs to be zero, but it doesn't stop at 0.It stops at 0.002. Whereas the same goal seek stops at zero ...

**0**

votes

**1**answer

82 views

### Is there a way to reuse a calculated value in a formula?

Take this formula for example:
=IF(SUM(D7,G7:H7)-SUM(C7,E7:F7)<0, 0, SUM(D7,G7:H7)-SUM(C7,E7:F7))
I don't like how I have to specify SUM(D7,G7:H7)-SUM(C7,E7:F7) twice. I'd like to define it once ...

**-1**

votes

**2**answers

428 views

### How Do You Stop Auto Formatting to a Cell I'm Using as a Barcode Number [duplicate]

I am having a little bit of a problem with Excel. I am typing into a cell a barcode number for my products but every time I leave the cell it automatically formats the cell as below.
Number I want to ...

**0**

votes

**2**answers

38 views

### Is it possible to copy a worksheet so that worksheet references are transfered relatively to the new workskeet?

Sheet1 has A1 = 1, B1 = 2.
Sheet2 has A1 = Sheet1!A1, B1 = Sheet1!B1
I'd like to be able to make a copy of Sheet2 so that A1 = Sheet2!A1, B1 = Sheet2!B1. This would basically work the same way as ...

**1**

vote

**2**answers

83 views

### Excel: Check for specific value in a matching row

I want to check which products (listed in rows) are produced by which company (listed in column headings) in order to fill a table like this
Company A Company B Company C
Product 1
...

**0**

votes

**1**answer

124 views

### Calculation of hour in Excel using [h]:mm formula

START END TOTAL TOTAL
21:00 3:15 6:15 6:15
23:25 1:11 1:46 1:46
20:25 5:20 8:55 8:55 ...

**0**

votes

**1**answer

346 views

### Upgrade from Excel 2007 to Office 365: Excel very slow

I have recently upgraded from Excel 2007 to Office 365.
I am finding that as soon as I have a few workbooks open (let us say 6 workbooks of 2MB open without many calculations) or one medium workbook ...

**0**

votes

**1**answer

241 views

### Excel 2007: How to change formulas/multipliers for a cell based on selections made on a drop down list?

I Need help with an excel formula. I made a list with the data validation option. Three options in the drop down list. does not except blank. For each option, I want to change the formula in another ...

**0**

votes

**1**answer

34 views

### How do I lookup using 2 values, Verticle and Horizonal? (Apple Numbers)

I have a sheet that has an individuals info, one table as their Age (TABLE 1). Another Table has a score in cell (TABLE 2). I want to lookup the VALUE that corresponds with their age and score in ...

**1**

vote

**1**answer

40 views

### How to skip empty cells while counting instances of days-of-the-week

I've been using the following function to count the instances of days of the week in a file.
=SUMPRODUCT(--(WEEKDAY(E2:E145826)=1))
Now that I'm trying to count them for the entire file instead of ...

**0**

votes

**2**answers

42 views

### Force a one-dimensional array into a constant in Excel

I have a condition in an Excel IF-statement as follows:
INDIRECT(ADDRESS(ROW(ME3),MATCH("PremiumWaiver",$1:$1,0)))=1
where
INDIRECT(ADDRESS(ROW(ME3),MATCH("PremiumWaiver",$1:$1,0)))
eveluates to ...

**0**

votes

**2**answers

2k views

### Comparing two columns in different Excel spreadsheets

I have two Excel spreadsheets. In the first spreadsheet I have two columns. Column A has 240 Accounts entries and Column B has Values for each account entry. Once again Spreadsheet 2 has its data in ...

**1**

vote

**1**answer

463 views

### Excel custom axis label

I'm having troubles with some charts I'm creating using Excel. Some of the values I'm plotting are too big (264) to be labeled in the axis. Due to this, Excel automatically puts them in scientific ...

**4**

votes

**2**answers

3k views

### Excel-Count number of visible cells containing certain string

I have a sheet in which I first apply a filter to a certain column to show "Unique records only". Now I have a column which contains, for e.g., values like:
Applepie
Applesauce
Crabapple
Banana
Mango
...

**1**

vote

**1**answer

126 views

### How to access the formatted text within an Excel cell with VBA

I have embedded formatting within an excel column. For example, a cell might contain some (but not all) italicised words.
The .Value, .Value2 and .Text properties seem to strip any formattting.
I ...

**-2**

votes

**1**answer

67 views

### Excel formula to calculate taxes

I have the cost of a ticket without taxes on N45. I want to calculate 7% of that (take out comm. %), then add taxes from P45, but what formula do I use for that?
Say I have a ticket price for $100.00 ...

**1**

vote

**1**answer

49 views

### Extending formula down the column without symmetry

Suppose this is the formula for my I2 cell =IF(C2<>C1, N2, K1).
If I extend this formula down the I column in excel, the default behaviour is
I3= IF(C3<>C2,N3,K2)
I4= ...

**2**

votes

**2**answers

153 views

### How to identify if a cell contains any of the values in a column

My question is the opposite (inverse?) of How to identify cells in Column A that contain any of the values in Column B. Specifically:
I have a list of 19,000 first names and 10,000 passwords. I'm ...

**0**

votes

**0**answers

42 views

### VBA Editor on F8 shows outlook insted of Step Into

Excel VBA Editor on F8 shows Outlook insted of Step Into. I don`t use it and it wants me to add my e-mail configuration every time. In other applications F8 works properly. What am I doing wrong?
...

**1**

vote

**0**answers

42 views

### Microsoft Excel hyperlink function to a specific location in a Word doc

I have a long column of numbers in Excel that I have mail merged to a Word doc. I would like to write a function in Excel that will hyperlink each cell from this column to its corresponding mail ...

**2**

votes

**1**answer

33 views

### Vlookup not registering range changes in calculation

Typing the first vlookup yields the correct result. When I pull down the cell reference to use the same vlookup on other cells, the vlookup recognizes that the formula has changed, but still delivers ...

**-1**

votes

**2**answers

59 views

### Excel formula to convert “Today, 10:18:03 AM” or “Tuesday, May 14, 2013 12:06:36 PM” to Excel date

Can someone come up with a formula to convert strings like the following to Excel dates? Note that it will say "Today, time" if the date matches today's date, otherwise it will say the day name. You ...

**0**

votes

**0**answers

43 views

### Excel Macro looping

I used this macro and it worked fine, but I needed a little bit more.
I had to change LookAt:=xlWhole to LookAt:=xlPart and add the color formatting. Now, when I select a column, the Macro appears ...

**0**

votes

**1**answer

362 views

### Excel 2007 adding a percentage increase

Value = 20 is a constant number
Percentage increase to "Value" in levels of 2%, 4%, 5% up to 20%
I would like to enter in a cell the LEVEL of the object and it return the VALUE + the percentage ...

**3**

votes

**3**answers

160 views

### 2 Monitors 2 Excel Sheets? [duplicate]

I have 2 Monitors and want to observe on one monitor 1st sheet and on the other monitor 2nd sheet but no matter how many excel files I open they are all on one monitor.
Can I split them to two ...

**0**

votes

**2**answers

64 views

### Plotting Graphs in Excel [duplicate]

I need to plot these values against time. Y are prices of an stock index and X are given in dates. When I highlight both the columns and insert line graph. The graph turns out wrong. Not sure why. ...

**1**

vote

**0**answers

109 views

### How to stop IE opening Excel spreadsheets in embedded mode?

When we open an Excel workbook with Internet Explorer (D:\Book1.xlsx in address bar) - IE opens the Excel workbook in embedded mode. It triggers Excel with the following option C:\Program Files ...

**0**

votes

**1**answer

136 views

### Excel functions showing wrong results

I have got a strange problem.
I'm using Office 2007. In Excel, I type the formula
=T.INV(0,975;99)
It is giving me 0,013417295 as a result. However, this should be 1,984. What could be wrong?