**2**

votes

**2**answers

284 views

### Deleting specific rows/columns from excel

I want to delete specific rows from Microsoft excel. My data set has around 900,000 rows, I want to get ride of rows/columns that are for example, from b325890-b500000 without dragging my mouse down ...

**0**

votes

**1**answer

72 views

### run time error 1004 - vlookup

this my code:
Sub index_test()
Dim i As Double
Dim Newsht As Worksheet
Dim countnonblank1, countnonblank2 As Integer
Dim myRange, nuRange As Range
Dim nuClass As Variant
Dim inpt, Msg, Title, MyInput ...

**0**

votes

**1**answer

269 views

### Hide and unhide rows based on multiple cell values (Comparison)

I am trying to do a comparison the details for a few companies (a,b,c,d), which is presented in a drop-down list in cells A1 and B1.
I am using a VBA routine (presented further down) to hide rows ...

**0**

votes

**3**answers

86 views

### How to include an entire column starting at a particular row in a formula in Excel?

I am looking to do summary statistics on a column of varying lengths.
I want to do something like =sum(A:A) except I want to avoid the first 5 rows of column A. Is there a way to do it?
EDIT: ...

**0**

votes

**1**answer

39 views

### Formula Logic Woes

Trying to calculate the ROI of the lighting equipment I'm renting, but I can't seem to figure the formula out.
As it stands, a single rental is calculated by:
=IF(J62>1;((J62-1)*G27)+F27;J62*F27)*...

**1**

vote

**1**answer

35 views

### How to embed numeric string in text in Excel?

I need to copy and paste thousands of numeric values, from A2-A10000 to B2-B10000, with some text around it. Here is one example:
A2:
5047612445
B2 then needs to be:
http://www.example.com/...

**0**

votes

**1**answer

52 views

### Duplicate rows based on its data

I have an excel file which I'll use to import hundreds of products in an e-shop. The excel have columns like this
Title | SKU | Size | Price | etc
I asked my clients to make the excel in very ...

**0**

votes

**1**answer

59 views

### How to view all sheet labels in MS excel?

I have a MS excel file with many sheets and I need to move to them.
How can I list all the labels and move to a specific one?

**0**

votes

**1**answer

17 views

### How to type Multiple lines in cell (B)

When I type multiple lines in a cell (A) in Excel it works fine. but then I am unable to type from the first line in the adjoining cell. (B) ... it starts from the bottom line.. How do I avoid this?...

**0**

votes

**0**answers

21 views

### Keep the first row on 2 sheets identical, regardless of changes on either sheet

I want the first row of 2 sheets to be the same.
For example, if both sheets first row starts out as 'USA', 'Canada' in A1, B1, and then on Sheet1 I enter 'Brazil' into C1, and then 'Germany' into D1 ...

**1**

vote

**2**answers

50 views

### How do I delete/ignore error-producing results in an Excel named range?

I have two ranges, RangeA and RangeB. I would like to essentially do the following:
=SUMPRODUCT(RangeA, 1/RangeB) / TotalItems
To get an average percentage. However, both of the ranges may have ...

**0**

votes

**0**answers

28 views

### Identify row for which value in Column B is closest to key value out of all rows with the same value in column A

Excel 2013
I have a large set of model output (215K rows) Column A is Julian date at approximately 2 hour increments, column B is depth in approximate 0.6 m depths, but with variable starting depth.(...

**0**

votes

**0**answers

38 views

### Dynamically delineate Excel cell

Is there a way to dynamically delineate an Excel text cell by semicolons such that the two words are then stacked in a column?
For example:
word1;word2
word3
becomes:
word1
word2
...

**2**

votes

**2**answers

142 views

### Excel survey data pivoting, plotting and analysis

I have a set of data from Google forms survey. I ran into a problem representing the data for a specific question type, grid to be exact.
So for example you get a question like this one:
and ...

**1**

vote

**1**answer

32 views

### Excel 365 recover information box always pops up

I've been using Excel 365 for several months now and as of last week I have this box pop up every few minutes randomly it also happens when I open, close, and save sheets.
It is not harming my data ...

**0**

votes

**1**answer

29 views

### Can excell put fields in a template that can then be copied as regular text?

Ive been trying to figure this out but havent found many answers for this function. Essentially what I am trying to do is have Excell put my data fields in a text template so I can copy and paste ...

**0**

votes

**0**answers

24 views

### Excel changing data order in chart

I have an excel chart with the source data sorted from largest % to smallest % by salesperson. However, the chart that is created from that data set is showing the data listed alphabetically in the ...

**0**

votes

**2**answers

58 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

134 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.

**0**

votes

**1**answer

57 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

66 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

141 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 shekels)...

**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

35 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

396 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

26 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

18 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

125 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 03Nov15.xls]...

**0**

votes

**0**answers

34 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

92 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

83 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

34 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

207 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 ...

**-1**

votes

**1**answer

217 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

51 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

**1**answer

108 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 41....

**0**

votes

**1**answer

35 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%:
=SUMIF(D2:D392,">=30%",E2:E392)-...

**0**

votes

**1**answer

47 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

13 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

147 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

**3**answers

41 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

108 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

52 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

40 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

162 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

71 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

61 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

302 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

1k 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 ...