**0**

votes

**0**answers

3 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

**1**answer

13 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

10 views

### Compare to cells containing text and printing a value from a third cell

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

8 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

28 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

8 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

**3**answers

27 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

39 views

### saving a formula in excel

I've created a sum if 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))
That needs to be saved to an excel ...

**0**

votes

**0**answers

28 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

22 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

18 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

15 views

### How to filter months in chronological order?

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

15 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

23 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

18 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

129 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

15 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

32 views

### Return specific value in range

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

9 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

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

**0**

votes

**1**answer

15 views

### Excel horizontal only sum of an array (matrix)

I have a formula which generates a 2D array result. For example:
{=ROW(4:6)^TRANSPOSE(ROW(1:3))}
(the curly brackets are added by excel when you hit CTRL+SHIFT+ENTER
)
I need to sum only the ...

**0**

votes

**1**answer

33 views

### Formula to update cell based on user changing another cell's content

I want to know if there is a formula to update a cell in Excel with today's date
when a user changes any value in the row that contains that cell
OR
when a user changes the value of 6 / 7 / 8 ...

**0**

votes

**0**answers

18 views

### Excel Index match formula [on hold]

How can I use Index match formula to lookup and match below column B value of sheet1 to column A value of sheet 2 if column C in sheet 2 is having a value? and display that in sheet 1 column C either ...

**0**

votes

**0**answers

9 views

### How to aggregate a column based on another - excel 2013?

I am using excel 2013 to try to make a chart like this:
with this data (tried to do some formatting on it):
Date ...

**-1**

votes

**0**answers

13 views

### Microsoft Excel 2007 Formula for mileage over 4,000

I am needing a formula to calculate mileage for the next oil change on our company vehicles. I want the mileage for the vehicles to change red after exceeding 4,000. For example if we have 11,900 ...

**0**

votes

**2**answers

23 views

### Higher Dimensional Trendline

My data is in multiple dimensions, as below. Rather than a trendline, I guess I need a trendplane. Is this possible in Excel or a similar tool?

**1**

vote

**1**answer

25 views

### Excel - Comparing two columns and extracting data from one into another

I need help with an excel formula for a project I'm doing. I can't find the one that I need.
I have 2 lists of data in different tabs in Excel (Tab 1 and Tab 2). Both Tab 1 and 2 have a column with ...

**1**

vote

**1**answer

22 views

### how to find partial text in excel

I have two columns "A" & "B". Column "A" contains Complete Text (1000 line items) & Column "B" contains partial text (250 line items). How I can find & place all Partial text(Column B) ...

**0**

votes

**1**answer

33 views

### Count filled cells in row, given from adjacent column not being empty in Excel 2010,

I have a two worksheets, one in which I have a list of tasks as well as several other columns listing the status of the task and one column listing if the task is imortant or not. In the other sheet, ...

**0**

votes

**0**answers

18 views

### Delineate Excel Formula Without Using Wizards

Is there a combination of excel formulas that I could use to do this without using VBA or the import wizard? I know how to insert comma delimited data from a text file and to split a cell into ...

**-1**

votes

**0**answers

10 views

### Excel - Formatting one cell from a series of cells

I am trying to format one cell (H) from a series of cells (C, D, E, F).
For example
if column C = "x" then column H = 120
if column D = "x" then column H = 160
if column E = "x" then column H = 200
...

**0**

votes

**1**answer

26 views

### sorting column data into a raw by unique data [duplicate]

How do I sort in a row by the unique value of such data? For instance, I would like to compare the data on the value column, such as 2,3 4, or more values depending on the unique ID? This is 14 unique ...

**0**

votes

**1**answer

18 views

### Copy down formula using VBA starting from different cells [on hold]

I have a set of data that I add to weekly. In the data I have multiple columns that I need the formula to copy down to the bottom.
I have formulas in columns (for the sample piece below) B-D and I ...

**0**

votes

**2**answers

17 views

### Excel formula to generate a custom array result

I have a formula in excel which contains an array; {1,2,3} its use can be seen at
I would like to generate it dynamically eg arrayfun(4) would generate {1,2,3,4}.
I can generate a very long array with ...

**2**

votes

**1**answer

40 views

### How Are Integers Stored In Excel

I wrote a python script that uses the CSV and xlrd packages to convert a .xlsx binary excel file to a tab delimited .txt file. Unfortunately, every cell is converted to a string (which is ...

**0**

votes

**2**answers

20 views

### How could I set a Text Highlight Color—not cell shading—for a specific text within an Excel cell?

How could I set a Text Highlight Color—not cell shading—for a specific text within an Excel cell?
Illustrative Example:
This is a screenshot from OneNote of what I need to do on Excel also: link
...

**1**

vote

**1**answer

18 views

### In Excel, populate array based on table with value (and coordinates for desired array cell). All array cells are populated (default to be zero)

I am reasonably good with Excel but a near novice at VBA. I have a three column table. Column A & B have coordinates for an array, with column C having the value to be placed as defined by the ...

**0**

votes

**0**answers

8 views

### Calling IMPORTRANGE inside of REGEXMATCH function? [migrated]

I'm interested to know whether (and how) can i call IMPORTRANGE function inside of REGEXMATCH function.
I want to get root domains from list of URL's and use REGEXMATCH to do this but want to get ...

**0**

votes

**1**answer

23 views

### h:mm:ss for workout data in MS Excel for Mac

I am trying to store my running data in an Excel spreadsheet, but Excel keeps formatting it as a date and time. For instance, I enter in 30:00 for 30 minutes and 0 seconds, and Excel converts it to ...

**-1**

votes

**0**answers

16 views

### How can I lock an Excel file in Windows for Excel Mac OS X users

How can I lock an Excel file in Windows so that when people open it in Excel for Mac OS X it doesn't change format and only lets the user add text.

**1**

vote

**1**answer

23 views

### How do I use fill color for negative values in spider chart?

Is it possible format the Spider Chart so that the negative area is always filled with red color and the positives with green.
For clarification:
The color filling is done manually and if the ...

**1**

vote

**1**answer

22 views

### Excel: combine strings based on duplicate keys

I have two columns
Key and Value
(standard map)
There are duplicated keys. It is trivial to delete the duplicated keys (namely the delete duplicates button). But that would delete some useful data in ...

**0**

votes

**2**answers

38 views

### Compare lists and add missing

I have 8 Spreadsheets on one workbook. The first one is a weekly overall view. The other seven are broken into days. Each day lists some names of people that came on site. So Monday might have Joe, ...

**0**

votes

**1**answer

15 views

### Update one sheet with another with new data

I want to know if its possible to compare two excel sheets and update the one with new data from other.
sheet1 (source list) contains list of suppliers with invoices (and prices). sheet2 contain the ...

**0**

votes

**1**answer

66 views

### Excel table: Add only certain values (Oscar predictions ballot)

So for tonight, me and friends made a spreadsheet with oscar nominations and predictions of winners. What I'm trying to achieve is that I just put a '1' or an 'x' or something behind the winner in ...