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)

0
votes
0answers
8 views

Excel in Cell Function VALUE for Formulas

I have an excel sheet which I need to run on Android. Only problem, I used VBA for the Evaluate Function and VBA does not work on Android Apps. I was searching for an alternative and came a round the ...
0
votes
1answer
27 views

Why can't I switch between workbooks in Excel 2010 using ALT-TAB?

When using Windows 7 and Excel 2010, I found that I was suddenly no longer able to switch between workbooks using the keyboard accelerator ALT-TAB, although I could use ALT-TAB to switch between ...
0
votes
0answers
11 views

How to PDF a Word document that has an embedded Excel document

I created a PDF policy manual compiling several Word documents with custom headers & footers. Some documents now have attached excel exhibits. NOTE: it isn't necessary to link the spreadsheet, ...
2
votes
1answer
14 views

Dropping icon onto excel Cell rather than the actual content

In Word you can drag and drop files onto the document and have it show as an link to the file rather than copying the contents of the file onto the the word document itself. When double clicked this ...
0
votes
3answers
26 views

Excel - Copy cells without formatting / style data

I'm trying to copy a range of cells from an Excel 2010 spreadsheet and paste them into a table in AutoCAD LT 2016. My problem is Excel applies formatting information to each of the cells. AutoCAD uses ...
0
votes
1answer
22 views

adding criteria to an existing equation

I have this existing equation with two criteria =SUMPRODUCT((kshc2013D=A6)*(kshc2013A=1)) what I want to achieve is if I add a third criteria wherein it will only count month January and April to a ...
1
vote
1answer
24 views

Excel VBA: setting shortcut to Ctrl+Shift+5

I've made a bunch of shortcuts to format numbers, as follows. All of them work, except the Ctrl+Shift+5, Ctrl+Shift+6 and Ctrl+Shift+7 shortcuts. The problem seems to be with the shortcut keys, ...
0
votes
1answer
24 views

Excel countif formula that will subtract from another number if cell contains certain values

I am dealing with job applications for 8 different sites. People can apply for any combination of sites i.e 1 of them, 2 of them, all of them. Some applicants have specifically said they don't want ...
0
votes
1answer
22 views

Using named range between two excel files

I have two excel files. My named range data is located in file 1, and the result should be retrieved from file 2. How do I link named range from file 1 to file 2 using the equation below? ...
1
vote
1answer
20 views

Summing up values from a user-defined range

I have a spreadsheet from January 1 to present. and I needed to sum up the value parallel corresponding from the range which the user defines. For example: in Column A are the dates January 1 - ...
1
vote
0answers
20 views

Barcode in Excel 2010

I need for my company the possibility to create easy a barcode in excel. It should convert 123456 into a Barcode Code 128. Is this possible? We don't want to download a Software or any other stuff ...
-1
votes
1answer
17 views

Count How many times an item appears in relation to a value from another cell

I have 2 worksheets, what I want to achieve is to count how many times an item in column B appears if column A has a value of "1" on it. Worksheet 1 Column A (A2=1, A4=1, A7=1, A10=1, A13=1, A14=1, ...
1
vote
2answers
20 views

Excel Function: Count the number of Rows that do not have a certain value and are not blank

I am trying to count the number of rows which do not have the values "X", "Y" or "Z". Also, the values should not be blank. I am using the formula below to count the number of rows that have the ...
0
votes
2answers
26 views

Count only rows containing one of a specific set of values

I am trying to build a formula in Excel 2010 to count rows in which columns A1:A1005 and U1:U1005 contain either Y, N or NA. I want to exclude rows that are blank or have any value other than Y, N or ...
0
votes
1answer
12 views

Xls sheet (or XML) to formatted doc

I have an excel sheet with four columns (Name, Address, Country, Description) with about 300 rows. I want to create a word document with this info, having each field in different format, i.e. Name ...
0
votes
2answers
22 views

How to combine values from multiple rows into a single row with a comma separator

I have an Excel file that lists product SKUs in one culumn and product image URLs in a another column. My problem is that the file has multiple rows for the same product... ...when the CMS I use on ...
1
vote
2answers
25 views

Counter in Excel

My file has 50 sheet inside, which each sheet is a standard form. Lets name as Form1, Form2, Form3. I want to create a print sheet, where I select which form I want to see, so that I don't need to ...
1
vote
1answer
25 views

Create Excel chart of blood sugar level over time

I have a .csv of my blood sugar levels over time from the GLUCOFACTS application. I've imported it into Excel 2013 with the intention of making a visual chart of my data to my doctor. Unfortunately ...
6
votes
2answers
53 views

Conditional concatenate cell content across rows

I have a worksheet with thousands of rows which contain a unique ID A, and one 3 different error codes M. Each individual ID may have 1, 2 or 3 errors. They will always be in the same order. I have ...
0
votes
1answer
22 views

Excel Formula Is unwantedly automatically changing

I have created a product referral log and needed to have a system that automatically calculates points for those products once they are closed. My solution for this was to make a separate sheet ...
0
votes
1answer
20 views

Clicking a cell to fire a macro

I came across the following VBA for generating a msgbox when clicking a certain cell: Option Explicit Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Selection.Count = 1 Then ...
0
votes
3answers
16 views

Copy Background color from Master sheet to worksheet - not the contents

I wonder if anyone can help, I'm a noob when it comes to excel. I have to create a speadsheet which will be used in Datacenter management and hardware tracking, so what I've done is created a master ...
1
vote
0answers
19 views

Excel - disallow formatting locked cells, allow formatting unlocked cells

When i lock cells in excel How can i prevent users from editing the background color, text color, bold text etc in cells that are locked. But allow them to change background color etc in cells that ...
2
votes
1answer
20 views

How can I copy spreadsheet data at regular intervals

I have an Excel spreadsheet that is continuously updated throughout the year. At certain points in time throughout the year, say monthly, I would like to copy the data from some cells into other ...
1
vote
1answer
21 views

How to format the size of multiple link images in a power point simultaneous (2007)?

I've a powerpoint with one link image on each slide. I must update these images regularly but when I do, the size format of each link image changes. Can someone tell me, without using a macro, a ...
2
votes
1answer
19 views

Excel pivot table - unable to get graph to display correctly

I have a pivot table (Excel 2013) of results for a helpdesk. In column A it lists the agents, grouped by year (this divides up into months). In column 2 it lists the number of tickets closed by each ...
1
vote
2answers
30 views

How to find value of last cell in an Excel row

I have a spreadsheet with a delimited list of directories and files in rows with varying numbers of columns. I just want the filename value (e.g. 123-E-001.xls, situated in the last cell of each row) ...
0
votes
0answers
18 views

How to merge tables with multiple colums alike?

Table-1 (contains 120K Records) - contain missing/misspelt data CUSTOMER_CRM_ID||SIGMA_ID||Customer NAME||TELEPHONE||CITY||PO_ZIP||HOUSE_NUMBER||STREET Table-2 (contains 62k Records) - contain ...
-1
votes
0answers
30 views

IF statement is false, do nothing - GetPivotData

Unfortunately, I'm unaware of an if statement that will leave a cell unchanged when the if statement is false. Goal - If the text in Column E matches the value in B1, I want it to take the data ...
0
votes
2answers
26 views

Day of the week and Time Graphing in Microsoft Excel

I have an Microsoft Excel document with two columns, date (mm/dd/yyyy) and time HH:MM(a/p). Each row represents an order (The day it was placed and the time it was placed). How can I graph this so ...
-1
votes
0answers
15 views

How to use Comma Separated Value in Excel 2011

I'm creating an Operations Manual for a company and need to know how to date each page individually. There will be a checklist that needs 30 copies printed and I need to have the date listed ...
2
votes
1answer
15 views

generate line graph from spreadsheet with month and category column?

Trying to generate a line graph that shows the amount a certain category happened per month. The spreadsheet has the category of an instance as well as the month it occurred. Easy way to do this? ...
0
votes
1answer
18 views

in ms excel, is there a way to look up an array and edit data on the looked up row?

Just for a quick example, I have this table: A B 1 student grade 2 john 90 3 paul 93 4 peter 87 5 bill 84 6 7 Range or array is A2:B5. I ...
0
votes
1answer
28 views

In Excel, 'ALT and =' is returning a symbol instead of the sum function

In Excel 2010, Alt= is returning a symbol instead of the sum function. How do I get sum function back?
0
votes
1answer
29 views

Loop through cells in a column and concatenate

I would like to take all cells in column A: *bla* *someWord* *two words* *two & words* *other - words* Loop through them and concatenate as follows: “my custom text” + “(”+“*[index1]*”,” * ...
2
votes
1answer
23 views

How to prevent office 2007 from opening an *.xls file?

I recently installed Office 2007, parallel to Office 2003, so they coexist :) The thing I didn't anticipate is, that Office 2007 will bruteforce its way around. I don't want it to open old (*.xls - ...
0
votes
0answers
18 views

Reg. excel if formula

I am working a task list. I want that when I put done in column H3( in pending tasks sheet) the entire data from column B to G moves to next sheet (Tasks completed) in the same work book. Can it be ...
0
votes
1answer
37 views

Excel - Look up list of substrings within large strings

I've been struggling with the following; might be a bit of a challenge. I have an Excel file that was exported from an XML application. Sheet 1 contains rows of strings like those below. Every ...
3
votes
1answer
19 views

Changing the Excel 2013 Sheet Selector to a Vertical Orientation

Is it possible, and if so, what is the best way to change the orientation of the sheet selector bar at the bottom of the window in Excel 2013 to be vertical rather than horizontal? I have a large ...
0
votes
1answer
23 views

Calling a function from another workbook

I've got a pile of data in one worksheet that I am trying to save to individual workbooks based on values in several columns. The approach I am taking (for better or worse!) is to copy the relevant ...
1
vote
1answer
32 views

What exactly is this SUMPRODUCT and MID formula doing?

In an Excel spreadsheet I have text entries H23, w67, P45, etc. and I want to sum the numeric parts of these, i.e., 23,67,45. I have the formula ...
0
votes
0answers
17 views

Explain SUMPRODUCT formula

In an excel spread sheet I have entries H23, w67, P45 etc. and I want to sum the numeric parts of these i.e. 23,67,45. I have the formula ...
0
votes
0answers
19 views

Excel for Mac 2011: cannot enable add-ins

I have a UDF I've been pasting into one new Excel workbook after another. Thought I'd finally get smart and make it available to all workbooks, so I re-read a couple of tutorials and Saved the ...
0
votes
1answer
43 views

Microsoft Excel 2010 if(or(and I am confused

I am trying to query two cells by using If function but unfortunately have no luck. I will give you an example below. Please let me know how I can solve this issue. If C2="Car" and D2="Toyota_Mazda" ...
1
vote
2answers
22 views

How to populate a cell with values from another worksheet but increment cell address by 3?

I know how to populate a cell with values from another worksheet. But how do I skip to the 3rd cell? Here's what I am trying to do: A1 ='2nd Worksheet'!C4 A2 ='2nd Worksheet'!C7 A3 ='2nd ...
0
votes
2answers
20 views

Keep same row when new rows are inserted

I have a CountA formula: =COUNTA('0 Data Summary'!B10:B108) and a macro that creates a new client data row in row 10 every time and all other client data shifts down by one row. It works fine but, ...
0
votes
1answer
33 views

How do I stop the Now() function from updating everytime I open the file?

I need it to automatically grab the value of current time at a particular moment when the user does a specific action (like pressing a button maybe). The thing is, I need it to keep that value of ...
0
votes
0answers
26 views

Find and pick smallest value (date) on row based on the product name in column so that it do not pick the value twice for specific product [on hold]

I am trying to simulate full pallet order picking in warehouse so that it would be possible to pick the oldest pallet of specific product in warehouse. Problem description: In Excel sheet I have a ...
-2
votes
0answers
20 views

Excel Formula Multiple If Statements with text value [on hold]

I am trying to develop a closed product log. The hope is to have a product, say "Apples" or "oranges," be selected and then once it is also selected as a closed sale, it will apply a point value for ...
0
votes
0answers
24 views

Make Excel 2010 workable under high contrast theme

(started this topic first at answers.microsoft.com, but I have no high hopes it I will get a solution there...) Finally bought a new laptop with Windows 8.1, installed my Office 2010 on it, got all ...