# Tagged Questions

**0**

votes

**2**answers

29 views

### Excel - how to make alphanumeric cells work for =sum

I am trying to work out how to add up a list of cells that all contain alphanumeric values. For example, if the cell data is 3.098 GB (3,326,698,574 bytes)
I am using the below to strip out the ...

**1**

vote

**2**answers

19 views

### How do I identify duplicate rows in an Excel cell?

I have an excel file with thousands of rows of contact info.
I need to get a list of all the rows that have duplicate first and last names.
I have been able to use conditional formatting to ...

**3**

votes

**1**answer

3k views

### How to change Excel Pivot table “Report Filter”s values cell formatting

My Excel is in Finnish, but don't let that bother you...
First Report Filter "Kupi" has only number values in my source table, for example 643203, 3533, 253244, etc. How ever in Pivot's "Report ...

**1**

vote

**1**answer

33 views

### Assistance with Excel macros

My company uses Excel to track inspections and maintenance of portable fire extinguishers and I'm trying to add some functionality to it but don't have the first clue about how to do it. I'll do my ...

**0**

votes

**0**answers

9 views

### Microsoft Excel transform table data

I have the following table (#1) in Excel which I'm trying to convert to format shown in table 2. I tried pivotting, but I could not get it to work.
Table 1
Time User Ref Average
8-Dec ...

**2**

votes

**1**answer

15 views

### How can I filter which colums will be shown on a spreadsheet?

I have filters set up for each column, however I also want to be able to filter which of the columns show. Eg: I have 70 different columns, all with different headings. How can I create a filter that ...

**0**

votes

**2**answers

26 views

### Excel Data Not Refreshing

I have an EXCEL sheet that is connected to an outside Flatfile. I have the report set to open up and refresh the data automatically. However, the data does not refresh and I still have to manually go ...

**1**

vote

**5**answers

17k views

### Sum if ONLY all the cells have a value?

I need to sum 9 cells of data, each one on a separate sheet, but always in the same location. I only want a figure returned when all the cells have data, even if it's a 0. But, if one of the cells is ...

**2**

votes

**2**answers

3k views

### Right Click on Column or Row does not show Context Menu

I have the following issue: When right clicking in a row or column in Excel 2010 no menu is appearing. In Excel 2003 right clicking in a row lets you insert/delete rows.
Do you know if this ...

**0**

votes

**1**answer

2k views

### Cells are not showing date as per Format in Excel 2010

In my excel sheet, I have selected date in Format Cells as 3/14/01 (which is M/DD/YY)
Some cells in DATE column are showing date in correct format like 5/31/12 (M/DD/YY), while some are showing it as ...

**-4**

votes

**1**answer

32 views

### Formula to find the upper case in the sentence as true

i have one worksheet which has a sentence in-between uppercase words, i want to know which cells has a uppercase word in the sentence. Please someone help me out with the right formula to find.
I ...

**0**

votes

**1**answer

20 views

### Display prefix units in excel cell

I have a specific cell in my excel sheet that contains a value from 0-100 (The value can be changed by the user). Whose value is used in some formulas at different places in the sheet.
I would like ...

**1**

vote

**2**answers

28 views

### How can I compare two linked columns from one table with other two linked columns in another table? [on hold]

I need some help on getting the proper formula for validating the following.
We have Customer list with Customer name, Customer number registered in our system, Customer number in another billing ...

**1**

vote

**1**answer

22 views

### VBA code to change the selection of a drop down list (combo box)?

I ran the macro recorder and changed the selection of a drop down list that is formatted with data validation, and nothing was recorded. Does this mean that there is no way in VBA to change the ...

**-2**

votes

**0**answers

34 views

### Excel 2010 formula?

cell L26 being a date of 12/15/14
cell K26 = Y or N
cell J26 = Y or Y
Still not working. Here is what I am trying to accomplish. in looking at 3 cells, the 1st condition that must be met is ...

**0**

votes

**1**answer

10 views

### match product and copy a row range to Sheet 2

I have 2 Sheets. In Sheet1 I have a list of products (400) in column A. In colums B to M is the space for the names of 10 different owners, but each product could have any number of owners in one of ...

**1**

vote

**2**answers

171 views

### Look up a value in a list and return ALL multiple corresponding values

The basic answer to my question is provided here: How to look up a value in a list and return multiple corresponding values. However, once the formula is entered, I need to drag down, or copy/paste ...

**1**

vote

**1**answer

28 views

### Excel Copy Formulas Horizontally

On Row 1, Column A I have =Sheet!1K2, on Column B I have =Sheet!1K3, Column C =Sheet!1K3 and so on.
On Row 2, Column A I Have =Sheet!1L2, on Column B I have =Sheet!1L3, Column C =Sheet!1L3 and so on.
...

**1**

vote

**4**answers

17k views

### Extracting Data Between two Characters in Excel

I have the following format in Excel and I am trying to extract the data between the characters:
First Last <flastname@xxxx.com>
I need to extract the email address between < and > into ...

**1**

vote

**3**answers

192 views

### Can't click on ActiveX control in Excel 2010 Standard

I have a .xlsm file that has ActiveX control button with a module macro assigned to it. Problem is I can't click the ActiveX button from my Excel 2010 Standard. I tried to repair and reinstall Excel ...

**8**

votes

**2**answers

2k views

+50

### Date based sum in Excel / Google Docs spreadsheets

I have a bunch of rows with a date and a dollar amount (expenses).
I want to produce a list of the days of the month and what the balance of the expenses is. So, for example the 5th entry in the ...

**1**

vote

**2**answers

3k views

### MS Excel: Can I link images using a relative path?

I am working on an MS Excel document that contains a lot of (around 200) images. They are currently saved within the document, so the file becomes huge and working gets very slow.
Linking the ...

**-1**

votes

**0**answers

16 views

### query about excel joining data on sheets

just wondering if its possible to link cells in excel, say i have in column A 1,1,1,2,2,2,3,3,3,5 all below each other and in column B a range of names matched to the numbers. Then in a second sheet ...

**2**

votes

**1**answer

28 views

### Can I run a VBA function whenever excel calculates, even when I don't click F9?

This is a followup question to this one: Can I make Excel beep when a calculation is finished?
The answer relies on me pressing F9.
However, even with calculations on manual, sometimes calculations ...

**0**

votes

**1**answer

2k views

### Call PowerShell script from Excel macro

I'm trying to call a PowerShell script from a macro in Excel.
I have seen a number of examples along the lines of:
retval = Shell("powershell ""C:\MyTest.ps1""", 1)
When I try to use this, ...

**-6**

votes

**1**answer

24 views

### Deleting some cells in Excel 2013

I have 30,000 contacts on my excel sheet and some have not included their emails. I am a beginner at excel, and would like to know how to delete all cells without emails as well as the corresponding ...

**6**

votes

**3**answers

25k views

### Can I make an Excel VBA macro available to all workbooks?

Is it possible to write a VBA script in one workbook, and use it in other workbooks in the machine? I guess I'm looking for a way to write a macro package.
EDIT
Following the instruction in the link ...

**-1**

votes

**0**answers

32 views

### Excel Does not Recognize Comma Separated Columns

I have a .CSV file that is populated through a system, and I use MS Excel to open it. When i open the file, the data in each record (Row) are shown in one column only, MS Excel doesn't recognize the ...

**1**

vote

**1**answer

103 views

### How can I copy cell contents from multiple sheets at once?

I would like to select cells in each sheet in my workbook and then copy them all at once, is that possible? Or even better, if I could mark those cells (group perhaps) so that I could get the SUM of ...

**1**

vote

**1**answer

42 views

### IF formula incorporating sequential answers

I am trying to write an IF-THEN formula that outputs sequential numbers (See the example at the bottom). If you need further clarification on the process, just let me know. Here is what I am trying to ...

**0**

votes

**2**answers

31 views

### How to find time difference between two rows of one column in excel sheet?

I have an excel sheet containing the Entry and Exit time for users from bio metric software. I want to find how much time the user had stayed i.e. sum of difference between entry and exit times, but ...

**0**

votes

**1**answer

43 views

### How to find number rise within 1 hour in Excell?

I have numbers logged over the period of time. In one column, lets call it A there is a time in seconds from 0 to 10000, in the column B temperature logged accordingly to the time. Temperature usually ...

**0**

votes

**2**answers

53 views

### Format dates so they are split across two lines

See the dates above? I'd like to format them so they are split over two lines, as illustrated below (Note: the Oct 13 is a mistake; it should have been split as well).
In other words, between the ...

**0**

votes

**2**answers

39 views

### How can I automatically fill a series in excel, based on the value of another cell?

How do I automatically change the length of a column with the numbers 0-n, where n = a number in a certain field?
I'm thinking of something like this:
EDIT:
Seems like I was bad at explaining ...

**3**

votes

**2**answers

11k views

### AutoFill Large Number of Cells in Excel?

I have a formula in Excel that I would like to autofill to 999,999 other cells. How can I do this without dragging the autofill handle down the entire sheet?

**0**

votes

**1**answer

19 views

### Copy Full worksheet including multiple defined range names using macro or VBA

I've been trying to build a workbook for my company to use to track sales.
The problem I'm running into is that I want each user to have their own workbook saved on their local computer for their ...

**4**

votes

**2**answers

11k views

### How can I create a properly aligned curly brace that spans multiple rows or columns in Excel?

I would like to group a couple of columns or rows together and add a note to them. When I try that with normal letter-resizing, it gets ugly, misaligned to the rows, too bold and the centered text ...

**1**

vote

**3**answers

80 views

### How to split numbers into columns with negative and positive values, without empty cells?

Given positive and negative values in column A of an Excel sheet, I want column B to list the positive values from column A, and column C to show the negative values, in the order in which they appear ...

**0**

votes

**2**answers

37 views

### Obscure DateTime Format

I have a document with dates of the form 2014-05-14T9:15:20. Unfortunately, Excel does not recognize this DateTime format. Is there a way to tell Excel to read this as a DateTime format without ...

**0**

votes

**2**answers

28 views

### Numbering Identical Items in A Column

Suppose I have multiple, repeating names as follows:
John
John
John
John
John
Tom
Tom
Tom
Tom
Tom
Tom
Anna
Anna
Anna
Anna
Anna
Anna
I would like to find a way to tell Excel: while the name is ...

**5**

votes

**5**answers

10k views

### How to tell if an Excel cell has a formula or is hardcoded?

Does anyone have a special tip (non-VBA strongly preferred) to tell systematically if a cell has a hardcoded value or is a derived formula?
Am dealing with some data that has messy subtotals embedded ...

**1**

vote

**2**answers

5k views

### How do I calculate the total difference between two columns of figures in Google spreadsheet/Excel?

Usually I would just calculate the difference of each row like this: =B1-A1
Then I would sum up the values of the column like this =SUM(C1:C10) and get my desired value.
I don't want the C-column. ...

**0**

votes

**0**answers

24 views

### Email Macro Assistance [on hold]

I am not experienced in writing VBA Macros & need assistance to create the following Macro. What I am working with is 25 rows of data in Excel where I need a macro written. The request is that the ...

**1**

vote

**1**answer

21 views

### How do I copy rows based on single cell value in Google Sheets?

I have two sheets in Excel, which is duplicated on Google Sheets. Sheet 1 is a list of names with various bits of information for example
Name Number Outcome
Colin Smith ...

**0**

votes

**1**answer

37 views

### Can I use a worksheet as a function in Excel?

I have a worksheet set up such that I can input a value, do some math to give me a bunch of values, repeat math a few times, and add up all the values and return an output value. It is complex enough ...

**0**

votes

**1**answer

30 views

### Excel-function IF

Column C calculates the earliest date from column A and B.
What would be the shortest function to display Row A1 or A2 in Column D as per the value of Column C?
Overhaul 1 Overhaul 2 Earliest due ...

**18**

votes

**7**answers

133k views

### In Excel, how do I check if a cell is in a list of values (a range of cells)

I've got a range (A3:A10) that contains names, and I'd like to check if the contents of another cell (D1) matches one of the names in my list.
I've named the range A3:A10 'some_names', and I'd like ...

**2**

votes

**1**answer

4k views

### COUNTIFS over multiple worksheets

I am trying to make COUNTIFS go across two worksheets in the same excel file (Final Driver Forecast Model), just on different tabs. I need it to count if a driver returns between a certain time, then ...

**0**

votes

**2**answers

4k views

### Copy drop down list from excel 2007

How can i copy a entire drop down list from excel 2007 one document to another excel document, i have tried copying and pasting special, some forms told me to copy it through data validation process ...

**2**

votes

**0**answers

41 views

### How can I publish excel workbook with data populated using PowerQuery to SharePoint or website and have the data refresh on the site?

I have an Excel Workbook that gets data from an API using PowerQuery, to populate the tables. There are also filters and slicers in the workbook.
Is it possible to publish this workbook to ...