**0**

votes

**2**answers

22 views

### Excel Find+Replace lowercase after a certain character

I have a column that requires specific formatting for summaries of articles. Everything after a : should appear as an uppercase for consitency
Example 1 - Markets: Comment on Ugandan Shilling
...

**2**

votes

**1**answer

52 views

### Split data from single cell into multiple records

I have a table with an Invoice field that contains values and dates. There can be more than one invoice per record. If so, the invoices are listed separated by line breaks within a single cell. An ...

**-2**

votes

**1**answer

27 views

### Formula within Excel 2010 [closed]

I want to copy contents of cell A2 ("SE0001") to paste into cell A3 to result ("SE0002"). Please help with formula.

**-1**

votes

**0**answers

5 views

### merging data from one sheet to another with variations?

We have a sheet with 1350 product listings. Is there a way to automatically ad variations like size without doing each listing one by one?
they are tshirts with different designs on them. would ...

**0**

votes

**1**answer

30 views

### Show current workbook name in a cell

I am trying to view the name of the file that I am working on in Excel. I would like to use a formula to return the file name to a cell on the spreadsheet. For example, if the file was called ...

**0**

votes

**3**answers

32 views

### How to reference cell to the left (Excel) [duplicate]

I'm trying to do some calculations based on team results in Excel. The format is:
Team | Player | Yards
A | x | 100
B | y | 142
A | z | 93
I'd like to be able to sum all ...

**1**

vote

**1**answer

37 views

### OpenOffice Calc “if” formula for currencies

I have a spreadsheet that has many different currencies in it ($, euro, shekel). I want to display the actual price in the original currency and then show the converted price (in this case to ...

**0**

votes

**0**answers

25 views

### How to retrieve the name of the current sheet? [duplicate]

Is there a way to retrieve the name of the current sheet in a workbook?
As an example, would it be possible to have a formula which brings the string Identify to cell B25?
UPDATE: one of the ...

**0**

votes

**1**answer

23 views

### Define conditional formatting formula in Exel outside of conditional formatting formula bar

It is possible to use a formula to determine which cells to format. I don't think the formula bar of the CF menu is very user friendly for editing formulae.
My current solution is to write / edit ...

**0**

votes

**1**answer

75 views

### How to find matching cell values between 2 columns but return the value of another cell. Excel 2010

Image of the excel file is above/attached.
I have data in Column D that are matching in Column A
What I need is for Column C to output the value in Column B same row
So in an essence:
D2 has a ...

**0**

votes

**0**answers

25 views

### I need help on duplicating Excel sheet

I am preparing a student report card. I have a sheet called (ENTRY) which contains the student's names in column and marks for the various subjects they wrote in corresponding rows like this:
Now, ...

**0**

votes

**0**answers

13 views

### Is it possible to pivot on a table twice?

Background:
I have three tables in my power pivot data model.
Students [1…n] StudentsClasses [n…1] Classes
Classes:
- ID
- Name
- Building
I want to do a pivot table that does the following:
...

**2**

votes

**2**answers

39 views

### How to convert a string referencing another worksheet to an equation?

I have this cell:
="='C:\Daily Reports\" & A1 & "\" & B1 &"\[Report " & C1 & ".xls]Report'!K4
which creates a string like so:
='C:\Daily Reports\2015\11\[Report ...

**0**

votes

**0**answers

21 views

### Different Sharepoint filepaths in different environments

We have a VBA application in Excel (UserForm) that users use to update another excel workbook via SQL. The two files are side by side in an MS Sharepoint folder. There are two kinds of users – first ...

**-1**

votes

**1**answer

39 views

### How to compare values and apply formatting when one cell is a formula?

I need to apply conditional formatting in one cell based on its comparison against another cell that is of a different format. For example; Column A contains cells with formula. Column B contains ...

**-3**

votes

**1**answer

28 views

### Find duplicates in two different tabs [duplicate]

This is what I would like to do: Tab A Column A has a mass of numbers, Tab B Column B will have numbers inputted into it. I need to have the Tab B Column B highlight showing a match to a number in Tab ...

**0**

votes

**1**answer

22 views

### Excel lookup match date product

I have two spreadsheets:
S1 is a product list detailing column A the product and column B the price.
S2 is a list of separate transactions detailing column A the date, column B the product and ...

**-1**

votes

**1**answer

48 views

### Excel auto sort rows?

I know how to sort rows given their value, however as I keep adding new rows the values keep changing and I would like Excel to auto sort every thing I add something. On sheet 1 I have a table like ...

**-2**

votes

**0**answers

28 views

### Calculating project amounts

I need help with an Excel formula for calculating project amounts.
I have three cells (say G12, H12, I12) which are supposed to carry project codes. I have another 3 cells (say D20, D21, D22) which ...

**-1**

votes

**0**answers

31 views

### Create CSV from a formated table in Excel using Macro

I need a little help, I have a table in an Excel File, but I need to create differents CSV files according to when a field change in one column.
I need to create a different CSV each time that the ...

**-6**

votes

**0**answers

23 views

### Choose data if argument is true

DATE: 1/1 3/1 5/1
Lenny 1 1 1
Marie 1 0 1
Clara 1 0 1
Peter 0 1 1
Table above is the example data.
This table is to ...

**-1**

votes

**1**answer

42 views

### Excel code to create multiple copies of a sheet, copies named based on list in other sheet

I'm a relatively basic Excel user and need help with something that I know is possible but is too complex for me to figure out.
Basically, I have a list in a sheet on Excel (called 'List'), and each ...

**0**

votes

**1**answer

14 views

### Excel Data Connections - getting duplicate entries when there aren't duplicates in the original

So you're using Excel data connections to bring a table from one workbook into another. Perhaps you sometimes struggle with the connection seemingly at random deciding that some of the entries in the ...

**2**

votes

**0**answers

47 views

### Currency Values Pasted From Firefox Becomes Text in Excel 2003

New here. This is a commonly asked question but cannot seem to find the answer specific to my issue.
Just got a refurbished computer Windows 7 Professional 32bit. Installed Office 2003 and Firefox ...

**0**

votes

**1**answer

25 views

### Categorising overall probabilities of jobs in Excel

EDIT
So I've managed to get everything largely working using the SUMIF function as follows.
For <30% and >70%:
=SUMIF(D2:D392,"<30%",E2:E392)
For 30-70%:
...

**0**

votes

**1**answer

41 views

### Remove Duplicates inconsistently choosing which records to delete

So generally when using the remove duplicates function in Excel the oldest record will be kept - and that's exactly what I want to happen!
But recently when running Remove Duplicates, it is ...

**0**

votes

**0**answers

11 views

### Excel indicator box turned invisible

I'm using Excel 2013, and when I try to link sheets the green hashed indicator box has disappeared. For example: the keystrokes = ctrl+page down and then any subsequent keystrokes to highlight cells, ...

**1**

vote

**0**answers

30 views

### Programmatically rotate a pie chart to fix the labels

Part 1
I'm looking at a way to automatically rotate (with VBA) a pie chart depending on the data. The data is changed dynamically depending on the month selected. Here is an example of the kind of ...

**0**

votes

**2**answers

20 views

### formula for results based on multiple column criteria

in excel, have a 3,000 line report with a column where i enter the month that a product inquiry came in (Jan., Feb., etc.) & another column noting if this inquiry ended in a sale (Yes, No) - would ...

**1**

vote

**1**answer

54 views

### How Do I merge Duplicate Cells Col A Whilst Summing Their Values In Col C Whilst Pulling Through Their identifiers In Col B Excel 2013 Using VBA [closed]

This is what I want.
Merge Duplicates From Column A
Pull Through Identifiers From Column B
Sum Values From Column C
Sub SkuSorter()
Dim x As Long, y As Long
Dim rng As Range
Dim wSrc As ...

**0**

votes

**0**answers

26 views

### Placeholders for filename characters in Excel hyperlinks

Assisting another group that keeps an Excel file to quickly reference PDF's on a network drive. Problem is, the PDF's are revision controlled and the last two characters of the file name changes each ...

**0**

votes

**0**answers

23 views

### Excel 2010 - multiple sheet error

I have a problem with multiple sheets: every time I try make a change in more than 1 sheet at a time it doesn't work properly.
The problem: If I select 2 or more sheets and write anything in cell A1 ...

**0**

votes

**1**answer

22 views

### Conditional formatting on blank cells in non-blank rows

I'm looking for how to apply conditional formatting to blank cells - but ONLY if the row they are in is not completely blank.
For example, I'm making a project tracking sheet, and I want incomplete ...

**0**

votes

**0**answers

42 views

### Can users who don't have vba installed still use a file with excel macros?

Our company doesn't have the VBA pluggin installed for every user.
If I install the vba plugin for my excel, code a macro, and share the file on the company server, will my macros work for people who ...

**0**

votes

**3**answers

44 views

### Excel formula not working with column references

Hi,
I have 7 soccer matches results:
B D
Team A
2001 0 - 12
2002 1 - 5
2003 1 - 11
2004 4 - ...

**0**

votes

**2**answers

48 views

### How to format cells to use hh:mm:ss.000 correctly?

I am working with Excel 2013 and I have a column with time in seconds in the format 0.013, 0.033, etc. I would like to show this information in the the format 00:00:00.013, 00:00:00.033. But I am ...

**0**

votes

**1**answer

47 views

### Command Prompt output to CSV

I'm using the forfiles command to list files and folders (included sub folders) which is piped to a text file. My subsequent process requires this output to be in comma delimited format (.csv).
This ...

**0**

votes

**0**answers

23 views

### Conditional Formatting

I am working on a excel sheet for a client,
now i have a bunch of codes which are approved as "contract prices" by the client
and then there a bunch of codes which are "non contract prices" awaiting ...

**0**

votes

**1**answer

25 views

### ffmpeg -flags2 +export_mvs … to in *.txt

I'm doing research and practices on ffmpeg, I could see the motion vectors on a video between frames through the command "fFmpeg - flags2 + export_mvs ...".
Is it possible to record the change of ...

**-1**

votes

**0**answers

11 views

### Classifying subsets according to their relationship in Excel

I need to conduct a basic descriptive statistic analysis for a population.
The data is on a excel spreadsheet with approximately 5,000 cases that looks like this (first row = headings):
'id' ...

**1**

vote

**1**answer

34 views

### Show only one window in taskbar per file in Excel?

In MS Excel 2010, under Options -> Advanced -> Display, there is a checkbox called "Show all windows in taskbar". As far as I can tell, this options is global for all files opened and local to the ...

**0**

votes

**1**answer

20 views

### Date range for jobs & conversions SUMPRODUCT

I'm trying to run a report within Excel that shows the total number of jobs completed by employees within a date range and also a count of the number of conversions per employee within the same date ...

**0**

votes

**1**answer

22 views

### how to concatenate the output of vlookups in one step

I'm trying to run two vlookup operations and concatenate the results in one formula as such:
=CONCATENATE(
VLOOKUP($A$6,'TRP'!$A$7:$D$655,2,FALSE),
"/",
VLOOKUP($A$6,'HCP'!A5:B655,2,FALSE)
)
The ...

**0**

votes

**1**answer

18 views

### Can a function be used to alert if values are present in a table more than twice or not at all?

I am trying to help someone in my office with a surgery schedule spreadsheet. She would like a formula that will check a group of cells for a set of initials, and be alerted if the initials are ...

**0**

votes

**1**answer

22 views

### IF function: equals a sum does not work

I have a cell (A40) in an Excel worksheet which contains the sum of a range of values (formula: =SUM(A1:A39)).
Another cell should print "OK" if the sum is 0 and "ERROR" if the sum is not 0. I have ...

**-1**

votes

**0**answers

28 views

### Excel need formula for if (multiple criteria) and vlookup

I have been having issues finding a formula to fit the following situation. I have a part number with several components. I need a formula to say, if my item number matches cell a96, and the ...

**1**

vote

**1**answer

26 views

### EXCEL VBA code that searches info between two tabs. And returns what info is missing [closed]

What is the best/easiest way to search through data from two Excel tabs on the same spreadsheet. To see if the field is on another tab. For example, on tab 1 there is a list of fruit and vegetables. ...

**1**

vote

**1**answer

43 views

### How can I use a macro to group and average the values in an Excel column?

I'm new here and I've been struggling with macro writing. I was wondering if anyone could help me out with making/explaining a macro that could be used in my data set.
I have an Excel file that looks ...

**0**

votes

**2**answers

26 views

### Excel: count unique instances across two columns

I have a spreadsheet that has a column for cell sites and another column for frequency like this:
SITE FREQUENCY
MA1084 687
MA1084 687
MA1084 687
MA1084 4382
MA1084 4382
MA1084 ...

**-2**

votes

**0**answers

15 views

### VBA - have a base in common and separates each sheet

I am a beginner with VBA, still trying to figure out this great tool.
I have a file wwith 30 sheets I need to save separately, but two needs to be always there.
For example
Sheet A - Needs to be ...