# Tagged Questions

**0**

votes

**1**answer

23 views

### Need help creating an Excel formula involving dates

I have a list of 18 varied dates which as they pass, I need to know how many of the 18 dates are left. Can I do this with an excel formula?

**0**

votes

**1**answer

17 views

### Excel 2010 Conditional Formatting - cell/text colours based on value

I have a query regarding conditional formatting in Excel 2010. I have a date in cell P2.
The function I would like is:
In cell Q2 if a date is entered that is 7+ days after the date in cell P2, the ...

**0**

votes

**1**answer

11 views

### Excel auto Text formatting based on values within a range of cells

Need help finding a way to auto format a text response based on values in another set of cells. There are 3 values in Column B,C, and D and depending on the highest value of the three, the adjacent ...

**0**

votes

**1**answer

43 views

### Create graph of values, mean per day, grouped by variable

I have a spreadsheet containing the following values (slightly simplified):
Date - day in number - Temperature - Windspeed - Hours of sun. Data example:
01-09-2000 - 01 - 20 - 15 - 9
02-09-2000 - 02 -...

**1**

vote

**0**answers

14 views

### Need to select only one classification out of multiple values

I have a list of clients, products and their classifications in a Pivot Table
(Client Number) (Products) (Classifications)
--------1-----------------A---------------High
--------2------...

**0**

votes

**1**answer

25 views

### Execute batch file on computerA to open excel file and trigger macro on computerB

So basically, the reason why I need this is because we can't install excel in the server, so we will have to use another server(computerB) to host all our excel files and macro.
Current process is ...

**-1**

votes

**1**answer

32 views

### How to change the fill color of a shape using an excel 2013 button in vba?

I'm trying to develop an excel version of a baseball scorecard with diamonds representing first through third base and a pentagon for home plate.
Currently I'm working with just the first players ...

**0**

votes

**0**answers

23 views

### Get distinct count based on different parameters

I need to get the distinct count (how many times does a unique value occur) based on a few parameters. The table looks similar to this:
Getting the Amount is not a problem, I use SUMIFS() with a ...

**0**

votes

**1**answer

32 views

### Excel function: How to convert text data into numbers?

I have a paragraph of words that I want to filter and rank them in numbers accordingly. For instance, in one cell I have this:
"Apple; banana; orange; pineapple; watermelon". And in return, I want to ...

**1**

vote

**1**answer

24 views

### excel create a custom vba function?

Can anyone help me create a vba function to execute the following?
In Sheet1 I have 3 columns A(product) and B(price) which are populated with 3000 items and 3rd column C(quantity) which is not ...

**1**

vote

**1**answer

14 views

### How to prevent duplicated data in multiple Excel documents?

I am running company stats in multiple Excel sheets, such as budget, expenses, personnel data, subsidy data, etc.
I have separated them in order to prevent having zillions sheets in 1 document. I ...

**0**

votes

**0**answers

66 views

### Microsoft Office VERY Slow Opening Files on Network Shares

I manage several computers running Windows 7 with Microsoft Office 2010 and Microsoft Office 2013. Our users store and access many of the Microsoft Office files on a network share. For a typical file ...

**0**

votes

**1**answer

35 views

### How to add prefix or suffix to range of cells in Excel?

I have cell A in excel full of images name without the extension I want to add ".jpg" as a suffix to these ranges of cells however I need to skip non text cells by not adding anything. Any help to ...

**0**

votes

**0**answers

13 views

### In Excel 2013 PowerPivot, Table Properties button is grayed out. Why?

I have created 3 demonstration tables in Excel Pro Plus 2013: Items, Sales, SPerson. I have added each table to a data model, so they appear in PowerPivot. I have created 2 one-to-many relationships ...

**0**

votes

**1**answer

39 views

### Formula for Ascending Sequence

I am trying to help someone generate a formula to return a simple sequential series of values. For example in cell C6 we inserted the formula:
=ROW(A1)
and in cell D6 we inserted the formula:
=...

**-1**

votes

**1**answer

44 views

### Change number in a word to a letter in Excel cell

Is there a formula that can make the number in a word in the cell change to a letter in a word in excel?
For example:
P0rcupine → Porcupine.
Parr0t →...

**1**

vote

**1**answer

33 views

### How to generate an excel chart that includes aggregating and grouping

My data looks like this
Date Time Person Logged in
June 1 2PM John
June 1 2PM Chris
June 1 3PM John
June 2 2PM Chris
June 2 3PM Bill
June 2 4PM Bill
I want to ...

**1**

vote

**0**answers

27 views

### How to change the background of a Row, based on a choice in the Row?

I am trying to make it so when a choice is selected from a list, it will change the color of the row, based on the choice made. I am using conditional formatting, using a formula to determine which ...

**4**

votes

**2**answers

47 views

### Excel row sampling

I have an Excel table with a large number of rows.
I would like to take a random sample of say 100 rows and hide the rest, say display 1 row per 500 rows or completely random selection of the entire ...

**1**

vote

**1**answer

29 views

### Excel replace multiple text options within one cell with other text

How can I replace one set of text options with another? I was thinking that an Index/Match combination might work, but I cant figure it out. Perhaps a VLookup function?
For example:
My report output ...

**0**

votes

**2**answers

23 views

### Pasting Spreadsheet from Excel to Outlook, chart gets distorted

I have been able to copy a full workbook in the past and simply paste it into outlook to send the data set that I need to send. I recently updated the data set and included more data and now when I ...

**1**

vote

**1**answer

27 views

### Excel, assigning text a number and summing them

I am making a recipe spreadsheet. What I have is an amount column and a measurements column. For example an amount of 1 and a measurement of cup (for a 1 cup measurement), an amount of 4 and a ...

**0**

votes

**2**answers

31 views

### How do I compare a cell value with a range of values on 2 dirrerent sheets and return a Text I specify

In Excel I have 3 sheets in the same workbook.
I want to compare column A on "Sheet 1" with Column B on "Sheet 2" and Column b on "Sheet 3".
If I find an exact match on anywhere in column B "Sheet ...

**-3**

votes

**0**answers

32 views

### Excel/Word Table Relationship

I am trying to provide greater efficiency for coworkers with regards to writing reports involving unemployment data and as of right now we take monthly updates from pdfs and manually input them into ...

**0**

votes

**0**answers

42 views

### How to create stacked bars with timeline in Excel?

Here is the data:
I want to make timeline in Excel with stacked bars so that each stack within a single bar corresponds to a given time period. As such, instead of having separate bars for all the ...

**0**

votes

**1**answer

24 views

### For 2 columns of data (wlog A, B), make a third column with entries that appear in both A and B

Apologies if this has been asked before.
Suppose we have 2 columns of data, without loss of generality A and B.
I would like to be able to produce a column C which contains entries that appear in ...

**0**

votes

**1**answer

24 views

### Remove space in cells that is creating a new paragraph within the cell

I have few cells in my .csv file that has space between lines that is creating a new paragraph within the cell. So when I click on that cell only the first line of the cell is displayed in the formula ...

**-2**

votes

**0**answers

14 views

### Comparing two tables with one column of each containing some common values and some different

Given two tables, whose second columns data's value changes periodically. Also new entries of first columns data happen and their deletion also.
I want to compare these two tables. If possible I ...

**0**

votes

**1**answer

55 views

### Make a formula that has specific-cell-references change every n'th row in Excel

I have a big Dataset it is structured in such a way that always 16 rows belong to the same group. (e.g.: A1, A2, A3, A4, A5, A6, …A16 -> Group1; A17, A18, A19, A20,…,A32 -> Group2..etc.)
I would like ...

**4**

votes

**1**answer

66 views

### Make dropdown list show hyperlinks

I have a collection of all the different part numbers for different versions of a single part, and each of them is hyperlinked to their specific different drawing in pdf form. I would like to put them ...

**0**

votes

**1**answer

51 views

### Why does Excel give me a false value? [duplicate]

2,5+4,5=7, right? I didn't understand why Excel is giving me a false value in this case.
I'm sorry my Excel is in Portuguese.

**0**

votes

**0**answers

17 views

### Macro to Split data by filtering 2 columns [closed]

I want a macro to split data by filtering 2 columns and paste it to New sheet one after the other with Header.
In the above example I want to first filter column 3 for 1 value and then column 6 for ...

**1**

vote

**1**answer

66 views

### Deriving elegant or 'nice' axis values on graphs using Excel - lookup function or formula

I am trying to automatically calculate the most elegant y-axis scale (maximum, and division value) for some bar charts. I'm using Excel integrated with a dashboard tool (SAP Dashboards) to display two ...

**0**

votes

**0**answers

24 views

### Excel Data Organization In Single Column

I am working in Excel 2016 and I have a list of data that is all in one column. There are 17,000 rows and I can't take the time to go through and manually edit and reorganise the data line by line. ...

**0**

votes

**1**answer

23 views

### Editing CSV file in Excel always converts number column to scientific notation [duplicate]

I have a CSV file that I'm editing in Excel 2013. In the file there is a column that contains numbers e.g 688087123456789. Everytime I open the CSV file in Excel, it converts the number to scientific ...

**0**

votes

**1**answer

23 views

### Excel Spreadsheet data movement

I have copied data from a main list on one tab on to another list on the next tab of the same sheet. I have done this by copying each cell across individually. Now, when I sort the original sheet (...

**0**

votes

**0**answers

16 views

### Excel reconcile encodings

This question is more tricky than other questions related to encodings
The story is, a csv was exported without the utf8 BOM, and opened in Excel. The data was not recognized as utf8, and accents ...

**0**

votes

**1**answer

11 views

### How do I add a data point to an already existing line graph?

I have an already existing line graph with monthly data from an excel worksheet. How to I add the next month's data to the worksheet?

**0**

votes

**0**answers

12 views

### How to avoid obligatory scrolling difficulties when filtering large amounts of data in Excel 2016 for Mac?

Here's a hypothetical scenario in which filtering works well in almost every other spreadsheet software, but not Excel 2016 for Mac:
You have a large set of data (let's say 1000 rows), you scroll ...

**0**

votes

**1**answer

37 views

### How to copy multiple lines from MS word and paste them into Multiple lines in Excel?

I have a MS word file containing names and emails each name and email is in a separate line, I want to copy it into excel, is there any way that I can copy the whole page and have it pasted into ...

**-3**

votes

**2**answers

44 views

### Using the syntax IF THEN ELSE, to calculate Tax charge

1) If the total amount to be subjected to tax is 30,000.00
2) The first 2,200.00 to 3,000.00 is taxed at 25%.
3) The second 3,000.01 to 5,900.00 is taxed at 30%
4) The remaining amount is taxed at 35%
...

**1**

vote

**0**answers

33 views

### Excel - copy text from url to cell

I've got an excelsheet containing url's like so:
| column A | column B |
---------------------------------------------------
| www.example.com/page1 |
| www.example.com/...

**-1**

votes

**1**answer

65 views

### Division formula in excel

I have 2 column Price, % of Total Price how do I get the value of % of total price using VBA.
I notice that there is no divide function for excel WorksheetFunction.Divide
so how do I loop thru my ...

**0**

votes

**1**answer

35 views

### How do I set up a macro where it will do the following actions each time

I'm a complete newbie here and am stuck with a task I have to repeat over the next few days. I would very much appreciate your kind help.
Thanks so much in advance.
Setup:
There are 2 sheets.
...

**0**

votes

**1**answer

23 views

### How to find what causes the privacy warning in Excel?

There is this Excel file I made, it has no macros or any such things, it's just all formulas, and I copied some data into it from various sources (ERP Excel export, copy-pasting from web applications.....

**0**

votes

**0**answers

17 views

### How to count each value occurrence within group of arrays in Microsoft Excel 2010?

I have a network related spreadsheet, and the part I need to work on is multiple groups of arrays that contain values (port numbers). I'm trying to figure out a way to make a pivot-table that counts ...

**-1**

votes

**1**answer

44 views

### vlookup - Is it possible to use vlookup to pull specific info like this?

I am trying to pull the following from each group of Numbers -
CHG000509443 05-16-2016 22:48:41 for the Requested
CHG000509443 05-17-2016 13:14:35 for the Approved
Note 1 - It is always the first ...

**-1**

votes

**1**answer

21 views

### How can I combine the contents of two cells in excel? [duplicate]

I'd like to combine the contents of A1 "Hello," with the contents of B1 "It's Me" in the cell C1 so it will read "Hello, It's Me."
I know I can do it manually, but I have to repeat the process ...

**0**

votes

**0**answers

18 views

### PERSONAL.xlsb not opening automatically

For some reason, my PERSONAL.xlsb file is no longer opening automatically.
I've checked the Trust Center and the file location (C:\Users[user]\AppData\Roaming\Microsoft\Excel\XLSTART) is a Trusted ...

**0**

votes

**1**answer

21 views

### Auto refresh Excel worksheet after changed by external application?

I have a question similar to this one but I'm just using an Excel file, no CSV involved:
Open a .csv file in Excel and have it update whenever .csv file changes
I have an Excel file that I ...