**0**

votes

**0**answers

17 views

### Hiding the Microsoft Query table properties in Excel

I have done a data connection in Excel using the "From Microsoft Query" data connection type.
In that i have also set criteria where the values are taken from a particular cell. This is so that the ...

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

**-2**

votes

**0**answers

39 views

### setting up notification by email from excel

I maintain a service schedule in an Excel spreadsheet. I would like Excel to notify a workgroup by email 30 days before a due date that it is coming up. Is it possible for Excel to send, or trigger ...

**0**

votes

**1**answer

18 views

### Excel 2013 scatter plot

Hi I'm creating a sieve analysis graph. The graph is in logarithmic scale but I want the labels in the horizontal axis to be exactly as per the sieve sizes (horizontal data values)
Can I make the ...

**0**

votes

**0**answers

17 views

### Find and replace multiple values within selected cells using another workbook

I was wondering whether anyone could point out what's wrong with the VBA code below. It's based on the following:
Find and replace multiple values within selected cells
I want it to take the find ...

**1**

vote

**2**answers

73 views

### Hiding all but the selected rows of data

I am unable to send any pictures,
The data contains 98 column headings, with the first column being unique identifiers, and 1000 rows of items. I receive commentary on specific items throughout the ...

**1**

vote

**1**answer

39 views

### How to set up data validation to allow only a date or a specific string

I would like to use data validation to ensure someone has entered a valid date, but I'd also like them to be able enter TBD - just those two options. Is this at all possible without VBA? Is there a ...

**0**

votes

**3**answers

37 views

### Excel X Y (Scatter) Chart more than one value per cell

Is it possible to have more then one value in a cell and then use a X Y (Scatter) chart to represent the dots on the X and Y Axis ?
Here is what I mean:
Instead of having just one value per cell ...

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

**0**

votes

**1**answer

28 views

### Copying worksheets in Excel

I have a shared Excel workbook with two worksheets in it named "PREVIOUS" and "CURRENT". At the end of the night, I would like to click a button or perform some action to have the CURRENT sheet copy ...

**-3**

votes

**1**answer

47 views

### How do I get image hyperlink in text?

I have images with hyperlinks (copied from internet). I need to convert those hidden hyperlinks to URL in another row.
How do I do that?

**2**

votes

**2**answers

33 views

### XLS files on website

I have an XLS file, such as www.mysite.com/test1.xls. When clicking on the link it always brings up the spreadsheet inside Internet Explorer, with excel embedded in the browser and in a less ...

**1**

vote

**1**answer

40 views

### Changing a String Value to Date format in VBA

I am working on a VBA scripting in Excel. The following is the code that i am working on.
Option Explicit
Sub MoveThingsAbout()
Worksheets("Sheet3").Cells.Clear
...

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

vote

**1**answer

25 views

### How to show 0 if formula is not complete in excel

I am using the formula =SUM('7-10'!F12+'8-10'!J12-'8-10'!F12)
This is to work out average daily sales in 24 hours.
But if no sale is recorded for 7-10!f12 but sales are recorded for 8-10!f12 it ...

**-1**

votes

**2**answers

27 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

**0**answers

14 views

### Exporting Survey Sheets to a registrar in Excel 2003

I would like to create a Survey Template that gets filled out, and when saved, exports to a different folder, under a name based upon entry number. How do I go about doing this?

**0**

votes

**4**answers

49 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

**0**answers

19 views

### Using Sumif and subtotal with tables in excel

I have the following table in excel
A - B
amount - type - tag
4 - Debit - nice
5 - Credit - nice
32 - Debit - bad
31 - Credit - bad
for calculation of total I used the following formula:
...

**0**

votes

**1**answer

22 views

### Excel formula counting specific cells

=COUNTIF(B25:M25,"S-1")
My question is when a cell contains "S-15", it is being counted as a "S-1".
How can I specify "S-1" only?

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

**1**answer

31 views

### Excel - How to auto-populate from one sheet to another

Here is the scenario. For ease, I will use a Calorie log as my example.
Worksheet1 contains all food consumed for an entire day. Worksheet2 is an index of the foods consumed.
For example, in ...

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

**1**answer

18 views

### Sort one column by another and keep proceeding rows in the same order

So I have this excel spreadsheet that has a few verbs in Spanish as well as their conjugations:
Order Infinitive conjugation1 conjugation2 conjugation3 conjugation4 conjugation5 conjugation6
ir ...

**1**

vote

**1**answer

26 views

### No Startup folder in Microsoft Office for Mac 2011

I'm trying to save a new default worksheet in Excel for Mac 2011. Instructions say to save it in the Startup folder at this location:
/Applications/Microsoft Office 2011/Office/Startup/Excel
There ...

**-1**

votes

**1**answer

15 views

### Bingo Board - Methods to interact with (By Highlighting) multiple cells in Excel

What I'm trying to do is make a bingo board that lists the numbers 1 - 75 in one section and either click them, or highlight them manually and then have it review 5 or 6 cards in the same sheet and ...

**1**

vote

**3**answers

21 views

### prevent excel formatting as number

I have to copy from SQL Server Management Studio often. Many of our ID column fields are filled with numbers but have the data type varchar. When copying output from SSMS to Excel MSOffice determines ...

**1**

vote

**2**answers

28 views

### numbers on x-axis graph in Microsoft Excel 2007

I have a problem with a graph in Excel. Here is how it looks like
The problem is that I need the x-axis to start from 0 to 10
I am using Excel 2007. Basically, what I need is U=f(alpha)

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

**2**answers

35 views

### Extracting a list of values that appear only once in 2 columns

I have a worksheet with 2 columns of numbers (column A and column B) and I want to populate a 3rd column (column C) with values that only appear ONCE in both columns. That means any value that appears ...

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

**0**

votes

**1**answer

17 views

### Excel 2007. Data Tab is grayed out. Nothing on that Tab is available

I'm trying to sort a file to which I add rows daily. I usually have no trouble sorting, but from some reason all the items on the Data Tab are 'grayed out' and unavailable. Any idea what's caused ...

**1**

vote

**1**answer

20 views

### Use LINEST on filtered data - Excel

I am trying to use the LINEST function and then filter the original data to reflect the subset I am interested in. Unfortunately LINEST always uses all originally defined data. Is there a way to ...

**1**

vote

**1**answer

18 views

### In Excel, How do I trap a mouse click in a specific cell to activate a macro?

I have a Excel macro that does a simple sort. I want the end-user to be able to click on a specific call and initiate the macro. I need to trap the mouse-click to respond on it.

**1**

vote

**0**answers

21 views

### Mail merge - Change data in source from merged document

I have an excel file with thousands of records. I want to mail merge and build a directory which I have done.
The problem is when directory was built I noticed that there were some errors. I want to ...

**0**

votes

**3**answers

19 views

### Check range of cells for a string from another cell?

Cell A1 has a string.
Cells B1:G6 contain various strings.
Cell A2 wants to return "YES" if the string in A1 can be found in the range B1:G6, and "" if it can't.
I tried:
IF(CELL("contents", ...

**-1**

votes

**0**answers

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

**2**

votes

**1**answer

25 views

### In Microsoft Excel is there a way to control what part of a cell's data is displayed for cells which have more text that their size

I have a cell in Microsoft Excel with overflowing data. The overflown data is hidden because adjacent cells have some data as well. Is there some way to control what part of the cell's data is ...

**1**

vote

**3**answers

68 views

### Get max value of (X:Y) while cell below = 1

What I'm trying to do is get the most recent date from a row while the cell below it has a value of 1.
I've tried working with MAX and hLOOKUP but neither are doing what I need.
Cell A3 to G3 ...

**0**

votes

**1**answer

25 views

### delimiting text in Excel messes up hyperlinks

I'm trying to paste a table that should never have been done in Word into Excel. Once in excel, there's a column with three separate sets of data that I wish to delimit into three columns. The third ...

**0**

votes

**2**answers

25 views

### Add 00 before a number to make it match required field

I need to look up a matching employee number that is stored in 8 digits. the cells in XLS sheet vary some employees name have 5, 6 or 7 digits stored only in XLS. how do I pad 00 in front of the ...

**1**

vote

**0**answers

30 views

### How to find and replace text in embedded excel spreadsheets in word? [closed]

I need to change the values of a series of tables (about 10) embedded in my word doc.

**0**

votes

**1**answer

35 views

### Editing every cell in an Excel sheet

I have a list of phone numbers in an Excel sheet as well as in Outlook. The sheet only has one column. I need to remove '92' from the beginning of each phone number.
e.g. In a cell that contains ...

**-1**

votes

**1**answer

22 views

### Move the contents of a cell in Excel with keyboard (not cut/paste)?

Is it possible to move the contents of a cell (eg from A1 to B4) in Excel using the keyboard (the arrows) without using cut and paste? Something similar when using the mouse and drag in the edge of a ...

**0**

votes

**2**answers

36 views

### Using the SUM Function in Excel with N/A values

I am trying to create a formula for the Total cell at the bottom of a column. The problem is that some of the values in the blocks I am adding up are N/A values. (All the values in the blocks are also ...