**-1**

votes

**0**answers

20 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

23 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

42 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

35 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

44 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

38 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

30 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

17 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

22 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

30 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

55 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

28 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

35 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

23 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

20 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

26 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

20 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

30 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

79 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

28 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

31 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

36 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

24 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

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

**1**

vote

**1**answer

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

**-1**

votes

**0**answers

36 views

### In need of a formula in excel to pick a day based on it's availability. [on hold]

So what I have is a spreadsheet that ranks a group of technicians from 1 to 23. And I have a list of available days off and a list of techs and there preferences for those days off. What I want is a ...

**0**

votes

**1**answer

43 views

### Compare two excel files

I need to compare two Excel Spreadsheets to see if values of each user in a specific column were changed. The new Spreadsheet may have additional users that were added making the row old users ...

**0**

votes

**1**answer

19 views

### Excel conditional formatting only applies to first cell

In excel 2010 I have a row of content for which I want to define a conditional formatting. So I select the row, say from B3 to K3, and setup a new rule as follows:
Use a formula to determine wihc ...

**0**

votes

**0**answers

17 views

### excel protected sheet keeps crashing in windows 8

An excel file was created in 2007 version ( .xlsx) in Windows XP. A new PC with Windows 8 was installed and all old files and folders were transferred. The folder is shared in the network so that ...

**2**

votes

**2**answers

66 views

### A blank cell not registering as zero in excel

I am running a complex IF equation in Excel 2003 (yes, the computers at work are that old too) and it is important to the equation that blank cells are valued at zero, which is, I understand, how ...

**-3**

votes

**0**answers

61 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

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

**-1**

votes

**1**answer

25 views

### How to specify a month in cell A1 and have all the dates that fall in that month appear automatically in row B?

I have a question about Excel. I am using Excel 2010 and I want to be able to create a table that will auto populate the dates within the month that is specified in cell eg A1 into a row in B for ...

**1**

vote

**1**answer

29 views

### Excel 2007 formula to find out date from year and week number?

I'm trying to make my work hour notekeeping a bit easier. I note my hours by project so that Monday - Friday are in their own columns. I report my hours based on this weekly, so each worksheet has one ...

**1**

vote

**1**answer

11 views

### Graph Excel data based on 2 groupings

How would I use excel to graph based on 2 different segmentations? For example, consider the data:
Time Group Col1 Col2
1pm A 15 20
1pm B 20 30
2pm A 10 ...

**0**

votes

**2**answers

56 views

### Sync Google Form Spreadsheet with MS Excel

Is there some way to pull the responses from a Google form that is on a Google Spreadsheets into MS Excel?

**-1**

votes

**1**answer

33 views

### Excel Average by excluding top and bottom 5 values

Trying to get the average by looking up a text and excluding the top and bottom 5 dates based on worst and best values. I am currently using this formula which gets me the all but excluding the top ...

**0**

votes

**0**answers

23 views

### How can I check that a filter applied to a listobject column with vba is legal?

Filtering a listobject(excel table) with a value that doesn't exit results
all rows instead of none
can I get no rows?
can I get list of optional legal parameters?
example
listobject with col A
...

**0**

votes

**1**answer

32 views

### Why Excel autofills only from T1 to T4?

I have the text T1 in a cell. If I select it and drag the fill handle over multiple rows, then it fills in T2, T3, T4, and then resets back to T1, T2 and so on.
With other text like A1, W1, or Q1, it ...

**0**

votes

**1**answer

53 views

### How to reformulate Excel formula with too many levels of nesting

I need to be able to use the following formula in Excel to choose a formula used on a different sheet based on the values in drop-down menus in cells D2 and D3. The only problem is that the formula ...

**-1**

votes

**1**answer

15 views

### How can I extract total time used by an employee from a record mainted in a different tab

How can I add the time used by an employee for different taks and keep track for the total time used in a particular week? Staff will flight out a few times per week with each flight date and time ...

**-1**

votes

**1**answer

15 views

### How can I merge contents of 2 cells into 1 and shift the remaining columns in Excel?

I'm trying to merge cells in excel that are in the same row into 1 cell and then shift the remaining cells to the left.
Example:
Content | Sample | More | More2
So I want to merge "Content" ...