**0**

votes

**0**answers

7 views

### Split Excel Cell by last Delimiter

I need to split a cell by the first delimter (reading right to left) so that I can put that value in another cell.
For Example, my data in cell A1 could look like:
"something - more something - a ...

**-2**

votes

**0**answers

12 views

### Modify the Chart

First of all great article!
Now the issue - I am doing some reporting and I really need a radial MS Excel chart that will show me a system of qualities in a diagram.
Your version is almost what I ...

**-1**

votes

**0**answers

12 views

### Why are my frequency values changing to zero in my histogram output

I am trying to create a histogram in Excel 2013 by using the data analysis add in.
I am entering data in for 10 frequencies and 10 standard deviation values.
On my frequency table, I only have ...

**0**

votes

**0**answers

13 views

### Split name column to csv file

How can I easily transform columns information to CSV line or file output?
Input (From file or excel column):
ABC1
ABC2
ABC3
ABC4
Output (To file or excel line):
ABC21,ABC2,ABC3,ABC4
I don't ...

**0**

votes

**0**answers

7 views

### Print two arbitrary excel worksheets as one page, double-sided

I have an Excel file. It contains several worksheets (ex: A, B, C, D ...). Each worksheet prints on one page in the same orientation.
How do I quickly print any two of these worksheets (ex: A & ...

**0**

votes

**0**answers

11 views

### Excel formula weekdays

I am trying to create a formula that will give me the expected due date of a task (15 business days), and that needs to exclude weekends, that its easy and I did it with a simple weekday formula:
...

**0**

votes

**1**answer

10 views

### How to change the icons in Excel quick access toolbar?

Excel 2013 (32-bit) Windows 7 (32-bit)
I have several macro shortcuts in the quick access toolbar, however Excel has only one type of icon for macro shortcuts, which creates lots of confusion. Is ...

**0**

votes

**0**answers

6 views

### Excel macro shortcuts do not work for macros showing absolute macro name in “view macros” window

Sorry for the long title, but that pretty much covers it.
We are using a spreadsheet at work - it has a number of macros, all of which have keyboard shortcuts assigned to them.
Some of them always ...

**-1**

votes

**0**answers

16 views

### How to calculate and input data from one excel sheet to another [on hold]

I want to be able to input data daily onto the first sheet of my excel file for six different things. I then want to have a separate sheet for each thing that will then show the daily value inputted ...

**0**

votes

**0**answers

16 views

### Excel lookup table based on time

I need to set up a way that I can tell which shift certain things happen in. I have a table that has all the times, but I would like to attach each time to a shift (i.e. if this happens between 14:00 ...

**0**

votes

**1**answer

14 views

### Build a lookup query in Excel using named ranges stored in a cell

I have a spreadsheet which has a lot of named ranges, each of which is a table. I want to be able to run a lookup that will retrieve a value from any of the tables. I want to be able to store the name ...

**0**

votes

**0**answers

10 views

### Null string formula result as advanced filter criterion

I am trying to set up an advanced filter criteria range in my spreadsheet. I'm putting in formulas that are supposed to set the criteria based on other data in the spreadsheet. For example, I have a ...

**0**

votes

**1**answer

15 views

### Sheet numbers do not change when I fill. All other numbers change consecutively but the sheet number stays the same

=SUMIF(Sheet11!$K$3:$K$200,B$66,Sheet11!$O$3:$O$200)
So I want the next row to be:
=SUMIF(Sheet12!$K$3:$K$200,B$66,Sheet12!$O$3:$O$200)
=SUMIF(Sheet13!$K$3:$K$200,B$66,Sheet13!$O$3:$O$200)
and so ...

**0**

votes

**1**answer

26 views

### When finished “looping” Select first cell in range

I have a script that loops through sections on one sheet (Function Test Procedure) and pastes those values into another sheet (Results) in cell L2.
The way it is currently set up is to loop for the ...

**0**

votes

**0**answers

12 views

### Excel 2010/2013 - Need to count number of doses of a medication given on the same date, to the same patient MR#

Okay, a colleague is trying to compile some dosage information. He has a spreadsheet containing Dates of Service, the patient's Medical Record #, and the name of the Medication. So, if Oxycodone ...

**0**

votes

**2**answers

19 views

### How can I filter out only those values that have appeared more than once in a column?

I have the following data to start with:
Sr. No Conf. By Prod
1 A X
2 B Y
3 A Z
4 B X
5 A X
6 ...

**0**

votes

**1**answer

9 views

### Most recent date for ID in Excel 2003 Pivot Tables

I'm trying to automate a process in our office with pivot tables. I have multiple customer numbers per vin. For my process to work I need a 1:1 ratio of customer numbers to vin numbers. Only the ...

**0**

votes

**1**answer

12 views

### Excel UDF within UDF giving #VALUE error

Firstly, thanks to nixda for the hashing code!
I am kind of new to VBA. I am trying to create a function that takes an email address and obfuscates the username portion so a report containing the ...

**2**

votes

**1**answer

15 views

### How to average ten cells below when rows are inserted

This is a question about Excel, not VBA. I have a simple formula in my top row that averages the ten cells below it. I want to copy the row below this one and insert a copy as a new row. (My range is ...

**0**

votes

**1**answer

12 views

### Formula that execute lookup on first match of a criteria

In cell C26, I want to use a formula to print the earliest date at which: Consolidated target > Total # of skus
Thanks in advance for your help!

**0**

votes

**0**answers

17 views

### Get time plotted data to automatically line up in correct date order regardless of blank cells

I have a set of data points plotted over time. Time is plotted monthly and the results for Suplhate (example given) are plotted quarterly. Results are entered in the same month every quarter for each ...

**0**

votes

**1**answer

14 views

### Running excel line graph

I have a set of data points in a spreadsheet with another set of line graphs plotting that data over time. New data in entered every month and each month I have to manually update the charts to ...

**2**

votes

**0**answers

13 views

### Legend-placement in two different charts is different with same settings

I have two charts, and in both of them I want I want to place the legend in the upper right corner of the chart-area like so:
However when attempting to add a legend to the second chart, it is ...

**0**

votes

**1**answer

22 views

### Text to Columns feature finding second space

Is it possible to split on the second space only? I am looking for a method that doesn't require VBA, however, I will use it if that is the most effective option.

**0**

votes

**0**answers

47 views

### How can I auto increment only columns reference in formula?

I have the following formula:
=COUNTIFS(Sheet1!$A:$A;"=Women";Sheet1!E:E;"1")
I'm working in Sheet2. Suppose I have in Sheet1 the following table:
| A | B | C | D | E |
...

**1**

vote

**1**answer

18 views

### Running a macro in excel 2013 every time workbook opens or closes

I want to run a macro every time an excel files opens and before it closes. I've tried using the below script but it didn't work.
Private Sub Worksheet_Activate()
'my macro
End Sub

**0**

votes

**1**answer

19 views

### Automating cell movement preferably using if/when style conditions

I want to fully automate the process of cleaning up exported data. I want to:
Move the data in the overflow rows into their prospective column. I have tried the following code in VB. (This is ...

**0**

votes

**1**answer

11 views

### Similar Excel Extensions as CSV

This query is related to Mainframes & Excel. If we have to transfer a file from mainframes to excel and it is .CSV, then automatically excel delimits the contents with comma. I need to know how to ...

**1**

vote

**2**answers

77 views

### Interpolate a collection of values to expand the number of points in the pattern in Excel

Suppose I have six cells (A1:A6), containing the values 1, 2, 4, 8, 16 and 32.
These values form a pattern, which I can graph. I want to expand the list of values to include intermediate ones ...

**-2**

votes

**0**answers

7 views

### search multiple words in excel using VBA

I need to search 10 words in 10 excel files at once. Can anyone give me a macro for doing this? For example i want to search london,doha,delhi in 10-15 files in a folder at once. Is this possible with ...

**0**

votes

**0**answers

37 views

### Excel 2013 Single Table Interpolation

How to Interpolate a single table?
I have a table with ten entries at A1:A10:
2.9
5.06
7
8.84
10.87
13.24
16.22
20.25
36
The highest value is 36 at A10.
I need to generate a new table with 36 ...

**0**

votes

**1**answer

20 views

### inserting en equation inside a cell and super/subscript

I'm using OS X office 2016 and i want to insert the equation inside the cell. I'm planning on pulling it out as data to Word later (using exceltoword!).
also i can't figure out how to use subscript or ...

**0**

votes

**1**answer

12 views

### Trying to show in one cell the date at which a cash flow will become negative

I made a cash flow projections sheet with columns going from D to FE and Rows going from 1 to 65.
On the top of each column I have a row with dates from D8 to FE8.
On the bottom I have a row with ...

**0**

votes

**0**answers

13 views

### Excel Icons for matching cell size

The old Excel had two icons - one for columns and one for rows. Clicking one of these would automatically match the size of all the columns and go all the way across or down the page. I am now using ...

**0**

votes

**1**answer

36 views

### Can I have two LOOKUP functions within a single IF function in Excel?

I am attempting to organize a dashboard of sorts that will place the name of the appropriate owner in a column on the spreadsheet. The two criteria is the location or US state the item is located in ...

**0**

votes

**2**answers

14 views

### Excel Indirect #ref error

Trying to use the INDIRECT formula to pull a summary at the end of a large workbook. I have listed the Worksheet names in a single tab and now wish to use these to pull specific cell data into a ...

**2**

votes

**1**answer

31 views

### Adding Value to cells in Excel

For the spreadsheet pictured below, I am trying to create a formula that will calculate the amount of shirts ordered for each size, then calculate the cost of each shirt ordered for a balance (total) ...

**0**

votes

**1**answer

14 views

### Change language of command in Excel

How can you change the language of the commands in Excel to English? Now the language of the commands are in Dutch (equal to the language of my pc). But can you change it into English? I use Windows ...

**0**

votes

**2**answers

20 views

### How to retain the original value when a referenced cell changes in Excel?

I'm having a problem in MS-Excel. If I entered a value in sheet1 cell A1, that value appears everywhere that cell is referenced. Is it possible to retain that value in the referencing cells if I ...

**0**

votes

**1**answer

17 views

### Find the product of a sum in excel?

I want to know how to calculate the product of the sum of a set of cells while being nested in a IF function. I have already tried =IF(=sum(B2:E2)>10000, =sum(B2:E2)*0.05, =sum(B2:E2)*0.02) but it ...

**0**

votes

**0**answers

9 views

### Excel, Worddoc and VBA guidance

Is it possible, using VBA and Excel, to have a button that retrieves a Worddoc Template and populate certain fields in the document with data from the excel document?
Long story, I am working on ...

**0**

votes

**0**answers

15 views

### Ledger Balance Sheet Assitance

Need your help again....I am building a ledger in Excel. Tab 1 has a Form to input data into cells in tab 2. Tab 3 is Reference Information that the form pulls data from for drop down menus. On tab ...

**0**

votes

**1**answer

11 views

### Excel 2013 normal curve area not lining up

I have a small excel sheet that I'm using to learn more about the value of normal random variables. I created a graph with a normal curve (-30 to 30) with the appropriate formulas.
Column A: General ...

**0**

votes

**1**answer

11 views

### How to find table_array referenced in Excel formula in cell

I was given an Excel spreadsheet that I have to convert into a SQL view.
In the cell formulas VLOOKUP is used and for almost all of the table_arrays I can find where the table_array is. But for one ...

**0**

votes

**0**answers

15 views

### How to change Microsoft Office default save location from OneDrive

I have Office 2016 for Mac, and when I go to Prefs for each app, I can't find any option to change the default location for Open/Save operations to local from OneDrive. I really don't want to use ...

**2**

votes

**1**answer

22 views

### INDEX and MATCH in Excel providing results 1 row lower than desired

In using INDEX and MATCH to perform a multiple-condition VLOOKUP, I'm currently getting results for the desired column using the below formula, but the result is consistently 1 row lower than desired.
...

**-2**

votes

**0**answers

23 views

### Macro to Copy/Paste rows into new worksheet depending on criteria

I have a list of names and data with the following headings:
Year Forename Surname DOB Gender UPN
The data variable is in that there are 7 years (Year 1-Year 7) in column 1 (A)
I would like ...

**1**

vote

**0**answers

11 views

### How to make groups/hidden rows behave like filtered lists so changes only affect visible cells, to prevent accidental data loss?

When rows/columns are hidden in a group or by manually hiding rows/columns, and cells are highlighted like so
If formatting is applied, or something is deleted, it applies to the hidden sections ...

**0**

votes

**1**answer

44 views

### Why is Excel (sometimes) changing casing of a text in an imported file?

So this is a bizarre problem some users of ours are seeing, that I've been able to confirm, and that makes absolutely no sense to me.
Basically, I work on an application that will export files in CSV ...

**0**

votes

**0**answers

13 views

### Excel's ActiveX controls' fonts explode when accessed via RDP - why?

Amongst other problems with using ActiveX controls in Excel, accessing the worksheet on a PC via RDP seems to cause the ActiveX fonts to explode :
This is on Excel 2010 Standard running on ...