Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. If your question is about programming Excel in VBA then also tag it excel-vba. If it is about an Excel formula or worksheet function, then also tag it worksheet-function.

learn more… | top users | synonyms (2)

2
votes
0answers
21 views

align column with text and numbers

In Excel, I need to align on the decimal point a column of numbers that contains a mix of: numbers, and numbers followed by x's For example, the following data should be aligned as: 0.100 ...
0
votes
0answers
12 views

Convert macro to save as Excel file and not PDF

Sub SaveAsPDF() Dim fName As String Dim StartRow As Integer Dim EndRow As Integer Dim a As Integer With ActiveSheet fName = .Range("AA17").Value & ".RG116.150420." ...
1
vote
1answer
9 views

Lining up sets of data in Excel (both with unique keys)

A related question asks how to line up two sets of data in Excel. I am struggling to figure out how to do this when you have values in both lists which don't exist in the other list. Ie: how would ...
1
vote
0answers
10 views

Taking an indirect reference in excel and making it a direct reference

For many somewhat complicated reasons -- it has to do with transposing columns and rows because of third party software limitations etc. -- I have had to use the indirect function in order to make ...
1
vote
0answers
8 views

How to reference cells by name in Libreoffice 4.2

In the Libreoffice version that came with Ubuntu 12.04, I could select a column, name it, and then construct a formula that referenced this name. e.g. Say I had two columns A=Price and B=Quantity. If ...
1
vote
2answers
20 views

In Excel, what is the appropriate function to use to find an item in a column that corresponds to an item in a column beside it?

Imagine that I have an Excel column ABC DEF GHI JKL MNO Then I have the following table option1 | ABC, DEF option2 | GHI, JKL, MNO option3 | PQR, STU .... (could be hundreds of comma separated ...
3
votes
1answer
26 views

Excel to count number of concurrent sessions based on start/end times

I have a massive set of data that I'm trying to work through. In Column A, I have a username, in Column B I have a session start date/time, in Column C I have the session end date/time. I am trying ...
2
votes
0answers
14 views

How to output a CSV file from a matrix of Excel formulas using multiple files?

I am receiving on a weekly basis a list of Excel spreadsheets from a supplier (around 40 spreadsheets) with data in a specific format. Since the format is a bit complex and can't be converted to CSV ...
0
votes
2answers
26 views

Check if a cell contains any of words from a dynamic list

I want to use a formula to populate the "RESULTS" cells. I need it to check if the adjacent "CHECKED CELL" contains any of the words listed in the "KEYWORDS" cells. Ideally, I would be able to add ...
0
votes
0answers
6 views

How to save .xls file to tab-delimited(.txt) and specify Shift-JIS encoding

What I want to do is save .xls file to tab delimited .txt file with specifying SHIFT-JIS encoding. I tried specifying encoding in web options however when I save to tab delimited still japanese ...
0
votes
0answers
10 views

Using if to compare name of a worksheet with worksheets in workbook

I have two files Main file and Result. Main file have multiple worksheet like delhi, moscow, paris, scotland and each one has same type of date and same heading ie.: S_No. , Vendor, VendorId, ...
-1
votes
0answers
11 views

Picking up data in excel with the date check

Let's say I have the following data: On the first row, there (mostly) will be dates in specific format. But sometimes there can be some texts as well. Now, I would like to get the average values ...
1
vote
1answer
26 views

I am trying to use the if function to look at cells to the left and leave the cell blank if they are blank or calculate if they are not

I am trying to use the if function to look at cells to the left and leave the cell blank if the reference cells are blank or calculate if they are not. for example I have E14 that im putting the ...
0
votes
1answer
21 views

Attendance Tracker - Deduct points if no points within pay period

I have a spreadsheet where I keep track of whether or not someone called in, was late or left early. On the 1st sheet I have their names, the number of times they've called in, were late or left ...
0
votes
1answer
35 views

How to make data shown on excel drop down list appear as numbers (shortcuts)?

Is it possible to have the data (choices) shown when clicking the drop down list to appear as numbers (or any text other than the actual text from validation data source)? Let's say the choices ...
0
votes
2answers
20 views

Locate Cells With a Simple Criteria

I have data like: I need to locate (get row numbers) for cells starting with the letter A.My current approach is to use a "helper" column. In B1 I enter: =IF(LEFT(A1)="A",1,"") and in B2 I ...
0
votes
0answers
25 views

How can I import multiple excel files into one master excel file? [duplicate]

I am trying to create a master excel file that would contain all relevant information from other excel files that are added to a directory. Specifically if I have an excel file of multiple workers who ...
0
votes
0answers
17 views

Is ther any other way apart of =Text(A2,“dd/MM/YYYY”) to get date in date format , having used any formula like lookup of concatenate [on hold]

Is ther any other way apart of =Text(A2,"dd/MM/YYYY") to get date in date format , having used any formula like concatenate
0
votes
2answers
35 views

How can i delete specific multiple rows in excel?

I have five sheets in one document. First sheet has the rows which contains values in first column. I need to delete all those rows from the rest of the sheets which has the same value in the first ...
-2
votes
1answer
21 views

Add a cell content to another cell if a different cell has a specific content

How can I fill a cells value (e.g row 29 col A) with =sum(B1:Z1) but then only add the content of a cell in that row 29 if row 4 of that column says "UK IR". That way I can add all the cells together ...
1
vote
0answers
21 views

Dynamic choice dataset Microsoft Excel

I'm currently setting up a database for my thesis, but the way I am working is not efficient enough. I have got two datafiles that I currently need to link manually, but that takes too much time. I ...
0
votes
1answer
9 views

Data Validation - Require a Custom Message Flash Up [on hold]

I have deployed a drop down in A2 that require the user to select "Yes" or "No". As long as A2 is blank, that is no selection has been made, a particular cell (say A3) can remain blank, however as ...
0
votes
0answers
20 views

Windows 7 breaks appearance inside office documents (word, excel)

When I scroll the excel sheet, sometimes the ribbon and even the top bar are being covered by cells. The visualization is being broken. The same thing occurs with MS Word, too. The problem occurs even ...
1
vote
1answer
18 views

Sumifs function where I want to sum a range not just a single row or column

I am stuck. I am entering timesheet date into an excel sheet: Column A - Resource Name Column B - Project Phase Column C - Resource Team... Column D to AAA is a date Therefore a single resource could ...
-1
votes
0answers
22 views

msgbox doesn't display current value [on hold]

I am wondering why don't the msgbox display a new appended value from a cell rather just the declared variable. I've declared a variable called "Newentry".I am adding a string value to a cell & ...
0
votes
0answers
24 views

How do I format numbers with abbreviations in Excel 2003?

In Excel 2003, is there any way to format positive numbers with abbreviations (specifically K, M, & B) while displaying all decimal places but not trailing zeroes like so: 878.1K 100M 1.478B ...
-1
votes
0answers
19 views

Excel Formula will not update [on hold]

I have a formula in excel that will not update automatically even though it is set to do so. If I hit F9 it still will not update. I have to be in the formula bar and hit enter for the update. Any ...
4
votes
1answer
154 views

How to automatically fill range by interpolating between lower and upper bounds

I apologize I do not have any code or examples too show for this. I am not sure how to even approach or identify the function or result I would like to achieve. What I have is spreadsheet with ...
2
votes
1answer
29 views

Excel - keyboard shortcut to double click on format painter

Double clicking on Format Painter has the effect of allowing you to click a few times and apply the same format in all those places. Alt-H-FP has the same effect as a single click on format painter. ...
4
votes
3answers
39 views

Keep Specific Columns From Repeating in Excel

There is a report that I pull from our ERP system that lists order detail information. It will list the order number, customer code, customer name, order date, order status, order total, product code, ...
3
votes
4answers
391 views

Splitting the string by space?

I have a string like timestamp 32.828000? I want to extract only 32.828000 from above string and store in adjacent cell. I do =left(b1,len(b1)-1) i get timestamp 32.828000 Now how do I split the ...
-7
votes
0answers
28 views

Excel Check if part of the value in a cell match another list and if yes return the list value [on hold]

Excel checks if part of the value in a cell match another list and if yes return the list value. For example: Cell LA, USA List: USA China UK LA Function: find out the cell match usa and ...
2
votes
0answers
23 views

Append values to Access table from excel with ID autogenerated

I have a access database with some tables which get updated daily with some values. I need the tables to have a ID field which is autogenerated when the other values of the table are imported from ...
1
vote
1answer
28 views

How to add higest ten values from odd/even columns in Excel 2010

I tried to combine sumproduct and large like this. =SUMPRODUCT(LARGE(((MOD(COLUMN(E48:AD48),2)=1)*E48:AD48),ROW(INDIRECT("1:10")))) This worked for odd columns. When I changed 1 to 0, it didn't ...
2
votes
1answer
15 views

Validate that a combination of cells are unique in a row in Excel

I have an Excel sheet where 3 columns (A, B, and C) form a unique identifier for each row, but the values in the columns are not unique. For example: ABC REF 001 ABC REF 002 ABC ...
-8
votes
0answers
24 views

Employee Salary Calculation [closed]

Employee compulsory time is: 7:00 hours per day. If employee slary is 10,000 per month: C2 = In time : 10:00 AM D2 = Out time : 13:00 PM E2 = In time : 17:00 PM F2 = Out time : 21:00 PM Total ...
0
votes
0answers
26 views

How to export images from Excel table [duplicate]

I have an Excel table with two columns: id and picture. id is a string and picture contains a single jpeg picture. This table contains almost 1,000 rows. Is it possible to export the images as jpeg ...
0
votes
1answer
25 views

Excel 2013 - PC - conditional formatting with multiple sheets

I have a project that covers 2 sheets. It concerns doing inventory for small businesses. On sheet 1 there is a schedule of inventories and purchases that a business can make each month. On sheet 2 ...
0
votes
0answers
22 views

Excel, macro move one row down and then delete the row

I'm trying to clean up duplicate rows. My data is in a table with filters applied. I have tried using the Excel feature to remove duplicates, but get the following error. Cannot complete ...
1
vote
0answers
22 views

Excel function Return all row that in the list cell match specific key word [closed]

I wanna make return all item from a list that any cell contain specific key word. If possible in more advanced level, make the return from a range of cell instead of list of row. Thanks.
0
votes
1answer
31 views

Multiple Formulas in one Cell for hotel

I am trying to create a housekeeping spreadsheet where when a room number is entered into a cell a 0 or 1 (0 is for studio and 1 is for a 1 bedroom) is automatically populated in another cell. I have ...
2
votes
0answers
17 views

How to return results of SQL query to Excel sheet with VBA function [duplicate]

I'm trying to create a VBA function in Excel to affect dynamic value from Access to Excel sheet. This is my code. Public Function SQL(DB As String, Query As String) Dim conn As ADODB.Connection ...
1
vote
3answers
39 views

Is there a way to set Excel up whereby trailing spaces are visible?

I know lots of techniques to remove trailing spaces from cells in Excel (e.g. TRIM), but sometimes I get given large sheets from other people which contain trailing spaces in dangerous places, where ...
0
votes
1answer
20 views

adding image from excel to word using mail merge

I'm using mail merge to generate a word document from an excel sheet and some cells contain images (office 2013). Is it possible to export them as well to word directly with mail merge without putting ...
-4
votes
3answers
34 views

Convert a group of letters into a date in excel [closed]

I'm trying to convert a lettered date code into a date. Example: SWITCHGEAR = 1,2,3,4,5,6,7,8,9 & 0. So when I enter a combination of the letters "SIRISC" it would read 13/03/14. I have tried ...
0
votes
0answers
20 views

Query/Reports in Excel only

I'm trying to use Excel in a way probably more suited for Access. Unfortunately I have no access to Access or Visual Studio (outside the VB prompts in excel.) I have an excel "database" with several ...
-2
votes
1answer
20 views

How can I find cell with minimum value in a column and add the values next to it to another range?

I have values in range A1:A3 and also in B1:D3.I would like to find the cell with minimum value in range A1:A3 and to add the all row values next to that cell to another range by hitting a command ...
0
votes
4answers
35 views

Excel 2007 How do I get rid of the 0 (zero) in this formula

I have dates in columns U,X,AA,AD,AG and AJ and Names in V,Y,AB,AE,AH and AK. I have the following formula to select the latest updates as they are updated. Columns U and V will be filled first and ...
0
votes
1answer
19 views

MS Excel - Cumulative sum of a column based on “id values” in another column?

I have been trying to figure out how to make a formula that calculates cumulative sums of rows in a column based on their id values in another column but still haven't found any solution for it. I try ...
0
votes
0answers
24 views

Excel formula returning different results on different machines

For a piece of work I'm doing, I use a formula that calculates the difference between two dates for each row in the report that the system generates. Essentially, the software I'm using generates the ...