**2**

votes

**1**answer

10 views

### Tricky cross table excel function

I'm trying to set up a table column in excel to check for matching names between the name columns of both tables, then return the total from the second table.
Currently this works, but I can't sort ...

**0**

votes

**0**answers

8 views

### Formula or function to change part of a text string color not using conditional formating

I have a shape I am using to highlight text. The text is using a formula to get a set of text from the spreadsheet . I need a single word to be a different color than the rest of the text string. ...

**0**

votes

**0**answers

3 views

### How to combine two columns with associated data?

for my term paper i have to compare several algorithms to compute pi, i wrote scripts that use certain algorithms that i want to test, that give me an excel file as output. The excel file contains ...

**-1**

votes

**0**answers

19 views

### SUM IF FREQUENCY MATCH

I'm trying to add another criteria for the below formula. On the Payroll Data tab I have column H that has hours in it, some of those hours may be negative so I don't it to count those rows with ...

**0**

votes

**1**answer

14 views

### IF AND conditional formatting not working - Excel 2013

Okay so I’m trying to format cells that are blank and meet the logical test. Here’s the formula:
=IF(AND($B2="Y", ISBLANK($C$2:$F$172)), TRUE, FALSE)
If both tests are true (B column = Y and there ...

**-1**

votes

**0**answers

10 views

### How to match donor data from year to year (ID Number and Associated Data)

I need to compare donor data from year to year and need to align them on a spreadsheet. For example, now I have the following:
Column A- shows 2013 Donors ...

**0**

votes

**0**answers

7 views

### Task Schedule excel file with ODBC/Oracle connection

I am having problem running an excel file with ODBC connection for Oracle to run via Windows-7 Task Scheduler. It will just say running.
What the excle file does.
After I open the file, it will ...

**-2**

votes

**1**answer

28 views

### How to multiply rows in Excel based on a variable?

last week I found a macro solving my problem, but I seem to have lost the code and cannot find it anywhere anymore.
My problem is the following:
I have table with names and their variables:
Peter ...

**1**

vote

**2**answers

26 views

### Excel Convert the correct Date type

I'm currently following the date type dd/mm/yyyy i need to have another row showing the month in mmm type. E.g. From 13/09/2014 to SEP
My formula is =Text(A2, "mmm") which is the correct formula,
...

**2**

votes

**1**answer

122 views

### Select all cells in a row

How can I select all cells in a row in Excel / Google Spreadsheet?
I know I can select all cells in a column using
A:A
But how can I select all cells in a row?
This doesn't work:
1:1 // select ...

**0**

votes

**1**answer

14 views

### Plotting data in excel grouped by type

Take a look at:
I made this manually. Basically, I plotted a normal bar graph, where all bars were blue color.
I want to get all bars of same type to be represented with unique color (Type 1 - ...

**0**

votes

**3**answers

24 views

### How to lookup a value within a range

I need a formula to calculate values from slab Ranges.
for example
columnA columnB
1-10 A
11-20 B
21-30 C
31-40 D
41-50 E
51-60 F
61-70 G
71-80 H
81-90 ...

**0**

votes

**1**answer

19 views

### Macro to copy distinct values from one Excel sheet to another

I have an Excel workbook that has the following sheets, "Main" and "Count":
Now the "Main" sheet has the column B with list of IDs.
Is it possible to have a macro on "Count" page to copy all ...

**0**

votes

**0**answers

6 views

### Word mail merge and page breaks

Looking for a way to put a page break after a number of rows in an Excel data source for mail merge in Word - the number of rows before the page break can vary, depending on he number of records that ...

**0**

votes

**0**answers

9 views

### equivalent of Crtl+Apostrophe in google docs

In Microsoft Excel I frequently use the keyboard shortcut Ctrl+' (apostrophe) to copy the value from the cell above the current one. The same keystrokes in Google Sheets instead toggles the display of ...

**0**

votes

**0**answers

20 views

### Prevent Excel from changing formula of last row of table when adding a new row

I have a table with columns named "date", "cost" and "daily". "Date" is a date, "cost" is a number and "daily" is a formula calculating the total cost of each day. The formula looks like this:
...

**-1**

votes

**1**answer

11 views

### One of my excel file sitting on my online file share corrupted due to some unknown reason

One of my excel file sitting on my online file share corrupted due to some unknown reason. (User claimed that she cannot save the file back after edit. She ended up terminate excel from task manager. ...

**0**

votes

**1**answer

17 views

### Why is copy paste losing all formatting by default?

Lately whenever i copy paste something (in particular within Office) by default i lose all formatting. To copy the formatting have to retry copying the content several times before it works.
So far i ...

**2**

votes

**0**answers

14 views

### MySQL for EXCEL (2010) - Custom select query

I have the MySQL for Excel (MS E:2010) addin enabled (most current version).
I've tested my connection to my server (non-local), and all is great, however I can't see anywhere to write / insert a ...

**1**

vote

**2**answers

25 views

### Excel '10 Formula to find & sum a row based on the intersection of 2 data points. (ie. Name(row), Month(column)

I need an Excel 2010 array formula that will take 2 given data points, say a "Name" (row) and "Month" (column), and return the sum of a row based upon the intersection of these two points within a ...

**-2**

votes

**1**answer

30 views

### Excel Macros 2013: Is it possible to create a Macro that, with a shortcut key, toggles a selected value between red and black font colours

I have created a spreadsheet with information regarding students grades and wish to be able to toggle the font colour of selected cells to indicate change in data. I have attempted to use "If", ...

**0**

votes

**1**answer

28 views

### Excel Macros 2013: Is it possible to create a Macro that, with the shortcut key, formats an input value between Whole int and 2 decimal places

I am attempting to create an Excel spreadsheet which holds information of students data, currently I have rounded all data to the nearest whole int.
What I wish to know is whether there is a way to ...

**1**

vote

**0**answers

13 views

### Filtering values on Excel Pivot Chart

I'm importing data into Excel Pivot Chart from SQL Server. I'm trying to filter out Values (decimal type on SQL) below a certain threshold.
For this, I click PivotChart filter and see that filter may ...

**0**

votes

**1**answer

29 views

### Excel Opening as a blank spreadsheet, but with values

So when we open an Excel spreadsheet that is populated it will open with all of the cells appearing blank. However if you click on any of the cells you can see in the formula bar at the top that they ...

**0**

votes

**4**answers

34 views

### Getting last cell in row with data and corresponding data in column A in Excel

I have a spreadsheet that in column A lists dates. Column B may or may not have data in each cell.
The question I have is when I grab the last cell with data in column B, how can I also grab the ...

**3**

votes

**2**answers

25 views

### Can I use COUNTIFS where only 1 IF criteria is required?

COL A COL B COL C
ROW 1 Yes Yes
ROW 2 Yes
ROW 3
ROW 4 Yes Yes
I'm trying to write a formula that will count how many rows has at least ...

**-2**

votes

**2**answers

24 views

### Excel - How can I detect the X lowest consecutive values within a column

I was hoping that someone might help me with a problem I'm trying to sort out. Does anyone know a formula that could detect the 10 lowest consecutive readings within a single column.
Thank you for ...

**0**

votes

**1**answer

18 views

### Compare to cells containing text and printing a value from a third cell [on hold]

I want to compare two columns containing text and if there a match print a value from third column see eg:
Column A Column B Column C Column D
BOB Sally 1
terry ...

**0**

votes

**2**answers

11 views

### Make numbers copied from Excel to Word use minus sign instead of hyphen to avoid wrapping

When you copy a negative number from Excel to Word, a hyphen/minus (Unicode -) is used instead of a proper minus sign (Unicode −). This causes text to wrap after the hyphen (you ...

**-7**

votes

**0**answers

30 views

### Need some assistance with Excel VBA [on hold]

Below are two separate Excel files. I want to populate the material and thickness w.r.t part number and CPSC in the first sheet.. Can anyone please write a code for this example?
Part Number CPSC ...

**0**

votes

**0**answers

9 views

### Html controls not displaying when exported to Excel

I have a web app that exports an html table to excel. This html table contains controls such as checkboxes and text areas inside the cells. It works fine on my machine but not on my colleagues. For ...

**0**

votes

**2**answers

36 views

### Remove space before specific text excel

I have a list of 1000s of different labels and need to remove the space between the number and mg. Sometimes the space is present and other times it's not. The position of the text "mg" is not the ...

**0**

votes

**3**answers

48 views

### What combination of keys do I need to enter complex formula in a cell?

I've created a conditional SUM formula:
=SUM(IF($G$14:$G$5002="Liz S Salary",IF($Q$14:$Q$5000>=Summary!$F$6,IF($Q$14:$Q$5000<=Summary!$F$7,$R$14:$R$5000,0),0),0))
The formula needs to be ...

**0**

votes

**1**answer

32 views

### How to increase the excel value 1 after to leave the few cells

I enter the following data on a sheet:
Roll-No:- 801
Maximum Marks
20
20
20
20
20
20
Sig. of Class
...

**-2**

votes

**0**answers

11 views

### Divers Excel versions and language

I make excel sheets and programs used on differend computers with differend languages and differend excel versions.
In Holland the date setup is jjjj
In US is yyyy
If I write VBA code, than I can ...

**2**

votes

**2**answers

23 views

### How can I get the relative position of a cell in a range?

I have a range of cells in a workbook, and I want to dynamically replicate them in another workbook. I don't want to use explicit cell references in case the range is moved, I always try to use named ...

**0**

votes

**1**answer

25 views

### Conditional formatting in Excel according to today's date

I have an Excel file that links to some documents, certificates and such, which are valid for a year. For example, since Feb 20, 2014 until Feb 20, 2015.
To the right, I have a column in which are ...

**0**

votes

**1**answer

17 views

### How to filter months in chronological order? [duplicate]

How do you filter months in mmm format in calendar month order and not alphabetical?
When I do it April as "APR" will be before January as "JAN" for example that is not correct.
(I know that Data ...

**-1**

votes

**0**answers

16 views

### Modify Excel data connection without disconnecting the connection file

I have several workbooks which connect to the same SQL server data source. I would like to store the details of the data source in a file in a central location, so that if the database is moved to a ...

**0**

votes

**2**answers

28 views

### Excel “Print to PDF” creating multiple files

I am trying to print a workbook to pdf, but for some reason, it is attempting to save to multiple files. About 10 pages want to save in 2-3 pages per file, then the rest (another 15) save to the ...

**1**

vote

**1**answer

14 views

### Cell reference formula within formula to pick out a group of similar rows

I have a table with 1000+ rows. One column is the Item Name. Each Item Name is unique, but will appear in 8 to 15 rows contiguous of data (before going to the next item name), the number of rows in ...

**-1**

votes

**0**answers

21 views

### How to iterate creating unique pairs from a list without repeating pairs across iterations [on hold]

I'm teaching a class where the students are matched into pairs each week for 10 weeks. None of the students can be with the same partner twice.
Does anyone have ideas for me to automate the matching ...

**2**

votes

**2**answers

139 views

### How to concatenate values in Excel?

I have a spreadsheet that looks something like this:
A B C D E ...
1| 1 0 0 1 0
2| 0 1 0 0 1
3| 0 0 0 1 0
4| 1 0 0 0 0
I'd like to concatenate row 1 in column F so ...

**-2**

votes

**2**answers

17 views

### Excel help to remove part of a field [on hold]

I have multiple locations that have a distance marker that I need removed. They differ in distance and some just don't have it.
Here's an example: (0m) KISD CTB

**1**

vote

**1**answer

18 views

### How to print Excel worksheet on A2 Paper

I have a wide Excel worksheet. I need to print it on A2 paper so I don't have to split it into two papers. How do I make Excel print to my A2 plotter?

**0**

votes

**1**answer

16 views

### Excel: How to give cells chosen by some criteria as a parameter in Variance (or any other) formula?

For the following Excel table:
A B C
1 Score Category VariancePerCategory(Calculated)
2 0.3146 Orange 0.034214
3 0.5711 ...

**0**

votes

**1**answer

12 views

### Excel: Find&Replace issue

I'm trying to find out, how to replace only those substrings (in my case it is ,_ where _ is a space), which starts at the beginning of the cell.
I suppose, the solution should be like this regex: ...

**1**

vote

**1**answer

33 views

### Return specific value in range [on hold]

Let's say there are two columns: A and B each with five rows. Column A has value P03675 in all five rows and Column B has TRUE, TRUE, FALSE, FALSE, TRUE in rows, just like this:
A B
P03675 ...

**0**

votes

**0**answers

13 views

### Excel 2013 Data Validation List to show all text for selection in drop-down but when selected resize and only show first two characters

I have a sheet that I need the drop-down Data Validation list to show the full text but after selection only place the first two characters in the cell and ensure the cell is sized to only 5 ...

**1**

vote

**1**answer

34 views

### How do I transpose columns in Excel?

I have a spreadsheet that looks like this:
I want to automatically transform it to this:
:
I know I can transpose it using this Window:
But the result is like this:
How can I get what I ...