# Tagged Questions

**-2**

votes

**0**answers

24 views

### How to have cell text from one tab show up on another tab?

I have several worksheets in my excel file. One worksheet has the information for Company A, another worksheet has the information for Company B
Company A Worksheet:
| DateA | CheckA | ...

**-1**

votes

**0**answers

22 views

### How do I create a chart showing distribution of values from a list?

I have the following list of values, representing time duration of operations in seconds:
5,5 4 6 6,1 3,7 9 9 9,1
I need to create a chart showing frequency of operations based on their ...

**0**

votes

**0**answers

18 views

### Efficient removal of duplicate records across multiple Excel sheets

I have a workbook with 2 sheets. Sheet 1 has 3 columns (1A, 1B and 1C) and sheet 2 has 2 columns (2A and 2B). Now I need to delete rows from sheet 1 if 1A and 1B match any row in sheet 2 (i.e. 1A=2A ...

**0**

votes

**2**answers

30 views

### How to plot positive and negative values on both sides of the axis in Excel?

Could anyone please tell me how is it possible to plot a graph in Excel or LibreOffice in which different values for a single variable can be plotted on both sides of X-axis but in a way that both ...

**0**

votes

**1**answer

14 views

### Excel Pivot: make 1-dimensonal data 2-dimensional

I have an Excel table with a structure as follows
Customer1 Domain1 Domain2 Product1
...
Customer1 Domain1 Domain2 ProductN
Customer1 Domain2 Domain3 Attribute1
...
Customer1 Domain2 Domain3 ...

**-1**

votes

**0**answers

16 views

### How does Excel to recognize the header row when filtering?

I have googled a lot ,they all pointed that the spreadsheet would "guess" the header row.But I don't know how to guess.What are the rules when guessing a header row?

**0**

votes

**0**answers

13 views

### Formatting a chart with many data points for a small display area

In Excel 2013, I need to display a chart with dates on the X axis and errors (already computed) on the Y axis. The problem is that I have 916 data points taken every six hours spanning approximately ...

**5**

votes

**4**answers

482 views

### How can I record a transition from a 0 to 1 in a column in Excel?

I need to record the number of transitions from a down state (0) to up state (1) in a single column in excel and I am wondering whether there is some kind of logic like this available in Excel or ...

**0**

votes

**2**answers

28 views

### Identify records with multiple IDs in Excel

I have a spreadsheet which is an export from a CRM database. There are two fields, email address and ContactID which I need to run a check against.
I need to know for a given email address, if it has ...

**1**

vote

**1**answer

23 views

### Excel 2010 : How to compute the number of non blank cells in a column among the entire workbook

Let's say I want to compute the number of non blank cells in some column (A for exemple) among the entire workbook, for a fixed range of cells. How can I do this ? knowing that for just one worksheet, ...

**0**

votes

**0**answers

35 views

### Advanced 'text to columns' in Excel - is there an add-in/macro available anywhere?

Often I need to split text which has multiple differing delimiters or other difficulties that the default 'text to columns' tool cannot handle e.g. ignore the first x columns
Is there a ...

**0**

votes

**0**answers

45 views

### Check if substring of cell in one row matches with another cell on column values in another row

I have a table with 2 columns (ID number, Description) as shown below:
ID no Description
1001 A letter to george william
1001 ...

**3**

votes

**1**answer

51 views

### Excel Formula to Check if a Word Begins with a Keyword

As the picture shows, I have 3 keywords from cell A2 to A4: a, bb, and ccc.
I have 5 words to check, listed in B2:B6: aa, bb, bc, ccand d.
I'd like to check, for each word in Column B, that if it ...

**0**

votes

**1**answer

17 views

### MS Excel: Count the max spaces between a number frequency

I have a column of numbers (i.e. 7,2,5,2,6,7,5,3,7,8,9,2,3,5,6,7) What I am trying to do is count how many numbers are between each 7. Not just the first, second, third, etc. but each instance. So, ...

**0**

votes

**1**answer

14 views

### Excel cell value (text) based on 2nd cell value (number) appearing in a named range

I have a spreadsheet where I want a contact name to appear in a cell (F166) if the department number (P166) appears in a named range ("PS Depts" on Sheet2).
Here is my existing formula, but it only ...

**0**

votes

**1**answer

16 views

### How to dynamically copy data to other sheets in Excel

I have one sheet with master data and four sheet with sub-sets of the data. I want to copy entire row contents to other sheets named ABM-I, ABM-II, ABM-III, & ABM-IV based on the 4th column "ABM". ...

**0**

votes

**1**answer

26 views

### Excel - how can I count rows based on three column values?

I have the following columns:
bonus1 bonus2 bonus3
1 2 3
4 1 2
3 4 0
0 0 0
I want to count each row once if the any of the columns is ...

**0**

votes

**1**answer

38 views

### Identify in what of the given ranges is a random number

I have this table with the first column being just an Identifier Code and the second one being the ranges.
So for example if a number is between 0 and 1134, it corresponds to the first row ...

**0**

votes

**1**answer

26 views

### Excel logic AND and OR functions

Does my formula below need to read (Occupancy=1)*(Gender=2) to consider the occupancy for both genders?
=(MIN(IF((Occupancy=1)*(Gender=1)+(Gender=2),Gross_Rev)))
I guess as a general question, ...

**1**

vote

**2**answers

38 views

### searching for a set of strings in Excel

I have set of terms and a set of strings that may or may not contain one or more of those terms. I'd like to search for if there is a match for one or more of the terms.
Search terms (cells A1:A17 in ...

**0**

votes

**0**answers

26 views

### Macro to increment date from a start date to finish date

I'm a beginner in macros.
I have start_date value in cell B4 and end_date value in cell C4.
I need a macro that can write the dates from a start_date (the saturday just before the start date) to ...

**0**

votes

**0**answers

15 views

### Excel 2010 “lastcell” issue with formula in complete column

I'm currently using a formula throughout a column in an Excel 2010 worksheet. It works fine, but I'm not really using the entire worksheet, I only don't want to have to worry about adding the formula ...

**0**

votes

**1**answer

34 views

### Changing the maximum value on an axis in Excel 2013

How do I change the max value on the axis option for Excel 2013?

**-1**

votes

**1**answer

39 views

### split information in single cell to multiple cells [closed]

I have this information in an a single cell
Please register for me:
NAME: Zaki Bin Manjoy
PS NUMBER: 675676
DIETARY PREFERENCE (halal/vegetarian): Halal
LOCATION: KFELS MPH KOM Tower Level 10
...

**0**

votes

**1**answer

25 views

### organizing columns in excel into standard format

I have data in a excel spreadsheet in a regular pattern that needs to be organized in a format friendly to statistical analysis.
Here is the format:
Clinton 29.30% 22
Edwards ...

**0**

votes

**1**answer

13 views

### Does Excel 365 vba (or 2013) have the vbscript Regular Expression that found in Excel 2010

I'm considering moving to the cloud, but I use a lot regular expressions in Excel and was curious if Excel 365 had vbscript regular expressions.

**0**

votes

**1**answer

33 views

### Find First Letter in a String

I need a formula to find and return the first letter in a string. So if a cell contains:
1234(*&^%$23ADFG54
the formula would return:
A
EDIT#1:
I am currently using the following UDF:
...

**0**

votes

**1**answer

37 views

### VBA code not working due to syntax error

I'm new to VBA.
My objective here is to create a function to show the lowest price of a steam item, given a URL.
Here's the mash-up code I've put together so far. However, there seems to be a problem ...

**0**

votes

**2**answers

79 views

### Color scale for text values in Excel

I would like to apply color scale on text values. But unfortunately, it works only on numbers!
I’m doing this to easily identify the repeated values sorted by other column.
This image explains the ...

**0**

votes

**2**answers

35 views

### Make Excel marks the repeated rows with a lot of data in each row

I have this Excel archive with 5 columns of data, and then, about 4,000 rows of different data for each column, but I can’t find a way to make that Excel marks the repeated rows?
I have tried using ...

**1**

vote

**1**answer

35 views

### Chart format corrupted or size is wrong when I copy from Excel 2013 to Word 2013

When I copy charts from Excel 2003 or Excel 2013 to Word 2013 the charts are corrupted:
the fonts are too big so the titles and legend text is a mess.
If I don't want the chart to update in Word ...

**0**

votes

**1**answer

25 views

### Excel 2013 charts - how can I setup default chart with distinct line colours and fonts as in Excel 2003

The default line colours in Excel 2013 have poor contrast and are not easily distinguishable. I would lie to use the same chart colours, fonts, borders, symbols etc. as was in Excel 2003. How can I ...

**2**

votes

**1**answer

54 views

### Unable to enter anything into a cell

While working on a Excel for Mac, I suddenly cannot enter any data in ANY cell. Also the same thing with all my spreadsheets, unrelated to the one I was working on. I can type numbers and letters on ...

**1**

vote

**4**answers

167 views

### Count the number of rows with equal values in two specified columns

I have two columns in MS Excel/LibreOffice Calc/Google Spreadsheets with numbers. I would like to count the number of rows which have identical values in both columns.
In the following example:
...

**-1**

votes

**1**answer

30 views

### Excel formula to collect data

I have this type of table in Excel:
A | A1
B | B1
A | A3
A | A4
B | B3
What I need is to create a new table where the data would look like this:
A | A1, A3, A4
B | B1, B3
Is ...

**0**

votes

**1**answer

28 views

### Sum values in range if lower than a threshold otherwise sum the threshold value

As per the title, the best I could come up with is this, however it yields an error. My unremarkable knowledge of Excel prevents me from making further progress.
This example formula should add all ...

**0**

votes

**2**answers

35 views

### Excel: how to remove leading characters of a string with a function?

I have a text column in Excel full of hexademical values like this:
0000000000000c10
00000000000036f0
00000000000274da
00000000000379e0
Which function can help me strip the leading 0's up until the ...

**0**

votes

**0**answers

19 views

### excel chart data labels failing to apply to all series

if I have a multiple series chart (pivot chart to be exact, can be line or bar) and I select (from the ribbon)
layout
data labels
more data label options...
then it automatically slaps ...

**1**

vote

**2**answers

60 views

### Macro for cleaning all sheets in a workbook (VBA - Excel 2010)

I have a macro file with 5 sheets and I would like to add a VBA command button into the same file to clean all workbook contents with a single click. Does anyone know how to do it by using VBA on ...

**0**

votes

**1**answer

18 views

### Can I filter out all rows corresponding to reference list in excel

I have a list of IDs that I would like to select in a excel sheet. I am used to using the filter function to search for 1 ID, but now I would like to filter out all the rows with that match the ID in ...

**0**

votes

**1**answer

20 views

### Excel formula - Return value from lower row

I'm looking for a way to search for a value in a single column and return a value in that same column two below it. Example:
A1: Apples
A2: Bananas
A3: Oranges
A4: Pears
If I search for ...

**0**

votes

**2**answers

21 views

### Why is using this code to replace a formula giving me an error?

In Excel I use the following to clear cell E5 and replace it with the word name.
Sheets("Invoice").Range("E5") = "Name"
I can also use the following to replace G11 with the VLOOKUP code I have here ...

**1**

vote

**2**answers

32 views

### How do I format cells in one column based off cells in another column?

So I found some similar questions to this already answered here, but they don't go deep enough for what I want to do, and was hoping to find some more help.
At a high level I want to format some ...

**-1**

votes

**0**answers

25 views

### How to write % change formula in Microsoft Excel

I have a spreadsheet that I am building and I need to show staffing level changes. I currently have several cells with 0 counts that will be changing to 1, 2 or 3. How do I write the formula to show ...

**0**

votes

**1**answer

26 views

### Excel Conditional sum on same row

I have a rather basic Excel question, but my Excel skills suck.
What I want is a conditional sum, but I'm not sure how to do it.
Example:
A B C D E
...

**0**

votes

**1**answer

20 views

### Excel saves absolute references to other sheets in my workbook. This causes problems when emailing the workbook to colleagues

I have this the following problem.
I create a pivottable and set a reference to anther Sheet, for example:
=Sheet1!A:C
When I save, copy, cut and paste file to various locations, I end up with the ...

**0**

votes

**0**answers

19 views

### Scan only to excell cell

I am trying to set up a system where particular cells on various spreadsheets can only have data scanned into them. It will also be necessary to disable the ability to input data into that particular ...

**1**

vote

**2**answers

41 views

### Formatting of output .csv file generated by a software

I've been using a software which gives the output in .csv format automatically. In my .csv output file "." is used as a decimal separator. In my colleague's computer, the same software outputs the ...

**0**

votes

**2**answers

25 views

### Finding the right graph to display inter-department connections [closed]

I have a task of displaying the interconnection between departments at my university. The idea is to show how many departments come together to work on a project. The data I have lists the projects in ...

**-1**

votes

**0**answers

26 views

### Macro to update Date in Specific row in excel

I want macro to update current date in cells M10, M15, M18 and M19
Ex:
If format of the date is 01-11-2014,then,
macro should update cells M10,M15,M18:M19 with 1 ...