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
16 views

Compare value from one cell with other sheets with different names

i have a workbook, where i create one sheet per employee, the sheet is named after the employee. The sheet has two columns Variable and Values. The Variables will differ for departments I create a ...
0
votes
0answers
39 views

How do I pull the ASIN code from an Amazon url in Excel?

How do I pull the ASIN code from an Amazon url in Excel? Variable length URL's, example: Want to derive the cell result : B00BQ59SYM from this ...
-1
votes
3answers
41 views

Excel : How to select cells with more than a number of characters?

Only search one column, then highlight all cells in that column with more than (a number) characters, so i change the data one by one? Thank you. Its phone number, thousands of them, many are typed ...
0
votes
1answer
44 views

How to sort sheet by groups of three rows without changing internal arrangement of groups

I created an Excel file showing a list of golfers and their scores on 18 holes. I want to sort by the Net Total, while preserving the rest of the formatting. When I try to sort the usual way, I ...
0
votes
2answers
34 views

Use INDEX to lookup multiple values in a list

I am using this formula to Look up all instances of CUCUMBERS in column B on the first sheet of my workbook: "ITS" I have identical to column B in Column X. So far this works great, just as I want ...
0
votes
1answer
33 views

Plot two columns against eachother

I don't think this should be difficult, but I'm pulling my hair out trying to do it. I am trying to make a chart of age vs BMI. I have a column with age and a column with BMI. The table looks ...
0
votes
2answers
25 views

Insert spaces in excel number sequences

I am trying to format cells so when I type in phone numbers it automatically formats them as follows: - Landline Nos e.g. 02012345678 to appear as 020 1234 5678 Mobile Nos e.g. 07123456789 to appear ...
0
votes
1answer
33 views

What prevents Excel from staying current with the years. For instance, why aren't I using Excel 2015? [closed]

Just curious on why Excel (along with other Microsoft applications) are not "up-to-date".
0
votes
1answer
30 views

Copy named ranges to another workbook

I have this VBA code to copy my named cells from one workbook to another, but it gives me Error 9: Subscript out of range. Any ideas please? Sub namexfr() wbs = ...
0
votes
1answer
21 views

Excel 2011 plotting difference between logged sent-time / acknowledgment-time

I have an excel sheet which is a log containing the time that a message has been sent and the time that the corresponding acknowledgment for that message was received. It also contains the time ...
0
votes
0answers
28 views

Mysterious “Reference not valid”

Error dialog: Reference not valid I have a big sheet with 30+ pivot tables made from the same 3 named tables. Every time i run refresh all I get the Reference Not Valid-error. I have no idea which ...
0
votes
2answers
31 views

Google Docs / Excel how to transform redundant row in columns

I have a list of redundant rows like this See my Google sheet Target FRBBED05517 Job state EXECUTION_ORDERED Target FRBBED05523 Job state EXECUTION_ERROR Target ...
0
votes
2answers
38 views

Excel: Validation rule with value that should be in the list of another column without blank

On excel, I've two tabs: one listing all people participating to an event, with a lot of details. I've a "FullName" column which is basically defined by: =[@LastName]&" "&[@FirstName] This ...
0
votes
2answers
26 views

How do I create an excel formula to pick out differences in 2 cell values?

I have a column of company names (column A), a column of the 2014 revenue (column B) and a row of the 2015 revenue (column C). I want to somehow pick out which companies had zero revenue in 2014 and ...
3
votes
1answer
24 views

Excel Conditional Goal Seek

Is it is possible to have the Excel Function Goal Seek stop when a certain is value is met or exceeded? E.g. Set cell A1 to be >10 by changing cell B1. Thanks
0
votes
0answers
23 views

Create Xbox Music Playlist from excel list (csv)

I created a few playlists in Excel (just the artist & song title) that I wanted to Import into Xbox Music. Unfortunately the only way I could find was to search for each song indivdually and then ...
0
votes
1answer
29 views

EXCEL: Additional COUNTIFS / Condition Needed for Value Ranges

I am recording multiple channels from individually housed birds, and sometimes their vocalizations bleed-through to other channels. I want them to be tagged for removal in some way. ...
1
vote
2answers
78 views

How to convert a number for a salary amount, to a specific, 9 digit, format in Excel

If I enter a salary dollar amount as 34512.15, I'd like to have a formula return this amount in a specific format as follows: M(HT)(TT)(TH)HTOCC M=Millions (HT)=Hundred Thousands (TT)=Ten Thousands ...
0
votes
0answers
15 views

Trying to create a tag system for historical expenses on Excel [duplicate]

I've imported a .CSV of historical transactions downloaded from my bank's website into excel. I'd like to create a new column in which I can list some tags associated to each transaction. For example, ...
0
votes
2answers
45 views

excel add cell if percentage or dollar amount

If I have a total column and want to add to that total a cell that would house either a percentage or a dollar amount, what is the formula? Is that possible.? For example a1 = freight b1 would be ...
0
votes
1answer
24 views

Count items in comma separated list in single cell

Is there a formula that will count the number of items in a cell, each separated by a comma? For example: CELL A1 = "Dell, Apple, Samsung, Acer" Formula would return 4.
0
votes
1answer
30 views

Conditional formatting- use a formula

I'm getting a bit tripped up with Excel. I've got 5 columns of retirement account contributions and balances over 30 years, and I'm trying to highlight the year where the year-end balance first ...
0
votes
1answer
24 views

Inserting missing values in EXCEL column [closed]

I have two columns of data in EXCEL. In one column, I have the time (say in hours), and in the second column, I have the stock price data in each time. Time stock price 09:00:00 AM ...
0
votes
0answers
35 views

Saving Images as Filenames in Excel

I have a product information sheet from a supplier that needs to get uploaded into an ecommerce platform. However, the spreadsheet contains actual images in the image column instead of filenames. I ...
-1
votes
0answers
20 views

Deleting columns from Excel [duplicate]

You responded to a question on How to delete specific columns from all excel workbooks in a particular folder. When I tried to use it, an error said that "Title" was undefined. Thanks for your help. ...
0
votes
1answer
69 views

How to use Index and Match formulas for multiple criteria

I have a spreadsheet that contains Olympic information, with the following fields in columns: A) Athlete, B) Age, C) Country, D) Year, E) Closing Ceremony Date, F) Sport G) Gold Medals. I want ...
1
vote
1answer
45 views

Excel: Get rid of gaps in line chart

I have a table that contains the data with some absent values. If I create a line chart for that, there are gaps in place of absent values, but I'd like to have the line just follow through to the ...
0
votes
1answer
39 views

How can I make a Scattered chart in excel where the dots are different colors?

I have the following info: Question | Importance | Percentage 1 | 2 | 15% 2 | 1 | 98% 3 | 1 | 35% 4 | 3 | 22% 5 ...
2
votes
1answer
23 views

Horizontal array constant definition issue

I can't understand where I fail (except following MS-original help :-D) in attempt to enter horizontal array constant (C+S+E seq) per MS guidance accessible either from Excel 2007 or 2010 help, or at ...
1
vote
1answer
25 views

Getting CHAR function to return multiple characters in Excel 2011

I'm using Office 2011 on Mac. I'm trying to write a formula to strip lower-case characters (and ideally spaces as well, but that's less important) from text in a cell. The purpose is to convert ...
0
votes
1answer
30 views

How to activate specific excel window and specific excel sheet using com objects autohotkey?

I am using following script to activate specific excel window- f5:: WinWait, Microsoft Excel - B [Compatibility Mode], IfWinNotActive, Microsoft Excel - B [Compatibility Mode], , WinActivate, ...
1
vote
1answer
41 views

How to get rid of “The following features cannot be saved in macro-free workbooks” in excel 2013?

Every time when I try to save a file, I'm getting the following error message. The list of available Add-ins in Excel I tested with a fresh file saved with simple word, closed, re-opened and ...
0
votes
1answer
33 views

csv file formatting issue in excel

I have a csv file when opened in notepad looks like this: sep=, ProgramXX, PXXXXX, .... IDXXXXX, XYZXXXXX, .... This should open well formatted as csv file in excel program but what I see is this: ...
1
vote
1answer
32 views

In Excel, How can I add values in a specific column if I have a checkbox type spreadsheet?

The Excel sheet is linear with column B being the distance walked each day. Across are a column for each participant. As they join the walking group each day, I'd like to keep a count on total ...
0
votes
2answers
32 views

SUMPRODUCT with VLOOKUP

I'm trying to get the Product and Sum of what matches in the TC Ref column and the Earn Type. For example 7926 would be (45.32 x -3) + (45.32 x -3) + (45.32 x -4) for REG and (45.32 x -4) for OT. I ...
0
votes
2answers
24 views

Calculating the deviation from range of values?

I'm trying to find if there is a function to do what I could do with several IF statements, just to make it more robust and standard I suppose (and more readable) I have a spreadsheet with 4 columns ...
1
vote
1answer
23 views

Trouble using “HLOOKUP” in Microsoft Excel 2010. Sometimes formula generates an error

Hi I have a table setup as- A B C D E F G H I J K L M 1 Row SDR_1 SDR_2 SDR_3 SIR_1 SIR_2 SIR_3 ...
0
votes
1answer
14 views

Limiting editable fields in Excel

Can I limit only specific fields to be non-editable by users in Excel? The 'Protect sheet' function only offers protection to the entire file with specific fields editable, I want the opposite (most ...
0
votes
0answers
16 views

How to validate autonumbering in MS Excel

I've made a running numbering function that autofills the numbers in every new row of my table. In most cases, I want to limit editing for this field, though sometimes I would need to keep it ...
0
votes
0answers
10 views

OneNote format changed after export to Excel

Following an export of the OneNote data into an Excel file for sharing, I cannot now make changes in the OneNote file. There is a cross shaped icon instead of a cursor that allows typing. ...
0
votes
0answers
15 views

Cannot use Buttons with VBA in 2003 but can use buttons from same sheet in 2010 Excel

I have excel 2003 and 2010 installed on our computers. I reinstalled both, did a system restore. I manually uninstalled all updates from the past month (this started happening 1-1.5 weeks ago) I am ...
-2
votes
2answers
35 views

Adding 2 formulas in excel

How do I add these 2 formulas together? =IF(OR(AND(G14="No"), AND(G25="No")), "F") If this formula does not result in "F", then ...
1
vote
2answers
30 views

How do I compare two list of data that contains a certain number in Excell?

How do I compare two lists of columns that contains a certain number? Please look at my example below: Column 1 Column 2 ------------------- 300 Room 305 301 Room 306 302 Room ...
0
votes
2answers
28 views

Removing the duplicate values and showing them in a new sheet [duplicate]

I have created an excel file for deliveries in my company and when we order products i put their dispatch number in the file. But when I try to check these dispatch numbers with post I always have ...
0
votes
2answers
53 views

Adding multiple IF formulas into one cell

I have the four formulas below that I need compiled into one cell block. Please help! =IF(SOURCE!C24>=90,"A"," ") =IF(AND(SOURCE!C24>=80,SOURCE!C24<90),"B"," ") ...
0
votes
0answers
12 views

automatic insertion of the date of filling an adjacent cell in excel [duplicate]

I have created an excel file for my company and several people have access to this file. because of that I need to know when a cell is filled. I want to dedicate a cell to show the date and time of ...
0
votes
2answers
31 views

Excel fill dates except Sunday

I want to fill a series of dates but Skip Sundays. When I right click the fill handle it only has weekday option, which will skip Saturday too. That's not what I need. How do I approach this? thanks!
-1
votes
0answers
11 views

To format data in excel cell from html to text

I have exported data from database to excel but couple of columns having data in HTML format, can anyone please help me with vba code or excel functions to format it. Data in my report change ...
1
vote
1answer
33 views

Fill cells with a repetitive pattern in excel

I have cells like 1,1,1,2,2,2. How do I use fill handle to continue to fill with 3,3,3,4,4,4,5,5,5 and so on? I have tried the fill series but it doesn't seem to work.
-1
votes
0answers
21 views

Mass edit hyperlinks on a Microsoft Project file

We had to replace our file server and long story short, user had Excel sheets and MS Project files with hyperlinks pointing to the old server which are now no longer working. I was able to find an ...