A spreadsheet application by Microsoft. Use this tag along with [vba] if your question involves programming Excel in VBA, and with [worksheet-function] if it involves an Excel formula or worksheet function.

learn more… | top users | synonyms (2)

2
votes
2answers
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
1answer
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
1answer
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
3answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
0answers
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
2answers
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
0answers
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
0answers
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
2answers
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
1answer
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
1answer
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
0answers
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
2answers
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
1answer
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
1answer
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
1answer
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
3answers
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
1answer
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
0answers
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
1answer
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
1answer
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
0answers
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
0answers
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
2answers
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
0answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
0answers
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
0answers
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
3answers
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
1answer
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
0answers
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
0answers
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
1answer
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
0answers
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
3answers
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
2answers
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
1answer
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 ...