**0**

votes

**0**answers

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

**0**answers

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

**3**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**2**answers

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

**2**answers

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

**2**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**2**answers

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

**0**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**0**answers

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

**0**answers

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

**2**answers

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

**2**answers

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

**2**answers

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

**2**answers

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

**0**answers

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

**2**answers

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

**0**answers

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

**1**answer

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

**0**answers

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