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
1answer
8 views

Can Excel copy and paste formulas and automatically adjust by more than one cell?

I have one column with values in every nth cell that I also want to have one after another in another column. Individually referencing every nth cell is impractical, so I'd like to copy and paste one ...
0
votes
1answer
30 views

Document tracking ms-excel facing problems?

I want to do which is so 90s at least ; this is the view if I google it. I want to add www.sometrack.com/blah.gif My goal Embed a trackable element (i.e gif) in excel. I want to send a person ...
0
votes
2answers
40 views

From column to matrix

I have few addresses in a single column. Need to move it to rows as below: name1 street1 city1 state1 phone1 email1 name2 street2 city2 state2 phone2 email2 NAME ADDRESS PHONE EMAIL name1 ...
1
vote
2answers
28 views

How to i convert a date entered as dd-mm-yy or dd-mm-yyyy to excel date

I have a sheet with date column entered as dd/mm/yyyy eg 15/12/2014 However excel does not treat this as a date ,hence I cannot apply any date functions to this column . Is there a way to convert ...
0
votes
1answer
21 views

How to replace characters?

I have numeric data such as 8,1, 9,2 etc. and I need to use this data on Weka Data Mining program. So I need to replace commas with dots (8,1 --> 8.1). I have selected data and replaced with dots(Ctrl ...
-1
votes
0answers
20 views

Excel Weird with Filter & Match to get 1st result from filter

as view in this Forum from the Excel sheet Get first data after Filter Data 2 3 4 5 6 7 8 9 10 11 12 13 ...
0
votes
1answer
28 views

How to implement conditional border formatting in Excel?

I need to force cells B, C, D, E to have an upper border IFF cell A is not empty. How can I do this ?
0
votes
2answers
35 views

Superscripts in Excel chart labels

I have data like this: 2 | 5 4 | 6 8 | 7 I want to plot them (scatter plot) with x={2,4,8}, y={5,6,7} but in the x-axis show 2 as 2^1, 4 as 2^2, 8 as 2^3, but not with the ^ symbol but as powers/ ...
0
votes
1answer
24 views

String compatible equivalent of Excel Small()/ Large()/ Rank()

I'm wondering if there is a string version of the Excel Small()/ Large()/ Rank() functions, i.e. a function that could look at a list of strings and tell you how they rank. E.g. in the following ...
0
votes
2answers
27 views

CSV File Import Error - Question Marks / Brackets Everywhere

I have a few .csv files that were sent to me, but when I try to import them either as .txt files or as .xml files I only get blocks of question marks (?) and brackets (CONTENTS) of the type that would ...
1
vote
1answer
19 views

Unable to format datetime in Excel Table

I have an Excel document with a table linked to a table in sql server containing a datetime field. The datetimes display as yyyy-mm-dd hh:mm:ss.sss and I'm unable to format the cells directly to a ...
1
vote
2answers
27 views

Vlookup across multiple columns

Within one workbook, I have two spreadsheets. Sheet A ("Master") looks like the following - it shows a main branch with it sub branches. Sheet B ("Query") looks like the following: The ...
-2
votes
1answer
23 views

How can I remove the duplicate values from this excel spreadsheet

I have a spreadsheet with around 15K rows of data. I have duplicate values in this spreadsheet that consist of a combination of columns A & B. How can I remove the duplicates from this spreadsheet ...
-1
votes
1answer
22 views

With VLOOKUP, if N/A, keep original value

I'm using Vlookup to find a value, but when it doesn't work, it returns N/A. How do I keep the previous value instead of having NA. I have found the answer HERE How do I implement this? Do I just ...
-2
votes
1answer
18 views

attendance software in excel [duplicate]

I want to make an attendance sheet in excel. If a child is present, the teacher will write ‘P’ in a cell or ‘A’ for absent.I have to add ‘l’ (which indicate late comer) also with attendance.So 'P' ...
2
votes
3answers
12 views

How to Find Specific Sheet Name in Excel

I have a excel file with 55 sheets in it It is very tedious to find a specific sheet name in the excel file since it has 55 sheets in it I have used the search function to find specific sheet name ...
0
votes
1answer
25 views

EXCEL: VLookupwith dummy variables

I have data that has dates, returns, and two columns of dummy variables. I would like to know how to use a formula to only show data when the dummy variable indicates a hit. My data looks like this: ...
0
votes
1answer
37 views

Complex drop-down lists

I want to make a spreadsheet to calculate energy consumed by a system. To automate I want to select some equipment and with this selection, the consumed energy appear at side. I try using INDIRECT ...
0
votes
2answers
19 views

Removing Specific Duplicates from an Excel Array

I have a workbook that has a list of account numbers and their attributes. Assume these are the only two columns on the sheet: 12345 Equity 12345 Cash 12345 Cash 55555 Fixed Income 55555 ...
0
votes
2answers
29 views

Excel: Applying Condittional formatting to every other row

I would like to apply a specific conditional format to every second row in my spreadsheet. In my specific case I have regression results, where the first row indicates the beta coefficient and the ...
0
votes
2answers
22 views

Excel: deleting duplicate records based on an int value

In a sheet that has two columns, the first represents a string and the second represents some field value associated to that string as shown below. I roughly have 30,000 rows like that. My Question ...
-2
votes
1answer
21 views

Macros to parse excel data [on hold]

When I am copying the data from putty after queries like ( Select * from tis_zfb where rownum<2; ) the data is getting shrinked, the null values are getting replaced by the values from there right. ...
1
vote
2answers
35 views

How can I use the row number in an Excel chart?

I have an Excel table which is simply one column of dates. Each date has a distinct value, and they are already sorted. Something like: 5/29/2011 6/21/2011 6/26/2011 7/1/2011 7/3/2011 ...
0
votes
1answer
29 views

I don't want Ms excel to scroll down by cell units

When I scroll down (or up) in Ms Excel 2007, it scrolls down so that only whole cells (or at least it tries to do so) could be displayed next in that page. And it keeps jumping down one complete row ...
-2
votes
0answers
24 views

Win 7. Use the contents of manually updated .xls to create a batch file that deletes files in folder to match spreadsheet?

Win 7.Use the contents of manually updated .xls to create a batch file that deletes files in folder to match spreadsheet? Hi. I have a folder that has a number of subfolders. Each sub contains lots ...
0
votes
2answers
13 views

Link to a formula in a different cell

I would like to be able to pull a formula through onto a second tab (not copy a formula). For example on sheet 1 I have a range of cells that calculate amounts (cell A) divided by a number of months ...
0
votes
0answers
21 views

Powerpoint 2013 - CPU spike

for some reason when i run PPT and/or Excel 2013, and even despite pretty robust and new system (see below, please correct me if i am wrong), my computer commands of large amounts of memory and CPU, ...
0
votes
1answer
16 views

One Cell OR Another

I am working on a formula- If A3 returns an error #NUM! then use A1 or A2 (whichever one does not have an error message). I am going to use ISERROR but can not figure out how to tell it to use A1 or ...
1
vote
1answer
26 views

Excel 2013: Change text in cell based on date in another cell

I have the the following spreadsheet: http://postimg.org/image/nti4akie5/ My formula in Columns A to E is the following: =IF(ISNA(VLOOKUP(Query1_2[@Branch],Master!A:J,10,FALSE)),"Branch Not ...
-4
votes
0answers
20 views

EXCEL HELP.Comparing 2 columns [duplicate]

Please Help me regarding this issue. I have 2 columns 1st column-676 rows 2nd column-1006 rows All the data in 1st column are there in column 2 I want the ones which are not there in column 1 and ...
-1
votes
1answer
21 views

Search price Grid

I am looking for a way to find values within a table: Lets say I have width of 575 and a drop of 575 then the search values should round upward to 600 width x 600 drop and the answer should be 66.6. ...
0
votes
1answer
25 views

How to control individual functions in excel chart?

I'm not sure this is the right place, but I'll give it a try. I have this graph: All of the functions' X Axis were given the same data (12,24,36,48), except ROULETTE and TOURNAMENT which were also ...
0
votes
1answer
11 views

Count the number of times a value/string is in a column when other columns are filtered

I am trying to count the number of times a value/string is in a column when other columns are filtered. Example: I want to be able to filter any column, A through V, and then count how many times a ...
0
votes
1answer
30 views

How do I group and chart date ranges in Excel?

I want to visualize the use of vehicles in a family through time. I have collected the dates each vehicle was being used as follows (example data) : And want to somehow chart the data to visualize ...
1
vote
1answer
12 views

Microsoft Excel lookup match without sorting data

Have a value list and need to insert points by looking up the data table. Data table has value for points in 1000 increments. Actual value that I lookup will not be rounded to 1000 so I tried using ...
0
votes
2answers
25 views

How can I summarize age ranges and counts in Excel?

I have a table with a long list of individuals, and their age. From this data, I was able to derive a list of all ages, and then count how many people were of each age. Here is some simple, sample ...
0
votes
3answers
28 views

In Excel need to copy a range of cells based on single criteria

I am trying to copy/insert a range of cells based on a single criteria. I have tried using the IF function as follows =IF(B6="RHH1",Sheet2!A4:J15,Sheet2!A18) The FALSE statement works and the ...
2
votes
1answer
32 views

Excel 2010 Pivot Formatting - Can't indent and wrap fields?

When working with pivot tables in Excel 2010, I want to show my pivot in compact form, with each field being indented as you move through the data, like so: However, some of my data strings are ...
1
vote
1answer
30 views

Excel - 'Concatenate' columns with Alt + Enter

I am trying to combine three cells into one, with Alt + Enter or Char(10) separating each value. When I use a simple Excel formula =B2 & Char(10) & C2 & Char(10) & D2 and wrap the text ...
0
votes
1answer
23 views

Excel reformatted numbers to times

I have a spreadsheet stored on a company sharepoint site. Only one person in my team will use it at any time, when they're finished it saves and is available to another user. Periodically when someone ...
-1
votes
0answers
34 views

Cell alignment in Excel by same value or within a number of character

I have different text cells so: As you can see: Some of the cells in column A are equal to some cells in column B. Some of the cells in column A are equal from last / or second-last / to some cells ...
0
votes
0answers
14 views

Does MSOLAP.5 automatically ship when the Power Pivot addin is installed

We have been getting the following error on some user's PCs when they are trying to connect to Analysis Services OLAP cubes: XML for Analysis parser: The restriction value provided by the ...
0
votes
2answers
24 views

Find last instance of a character in string and keep anything that comes before

I have the following data and I need to get rid of the numbers. This means I will have to find that last occurence of the character " " and keep everything that comes before however I dont know how to ...
2
votes
2answers
19 views

Formating a cell based on another

I have a cell A with values of either "Cancelled" or "Completed". I have another cell B with numerical value e.g 9. I want to format cell B such that if cell A is "Cancelled", then the value of cell B ...
0
votes
2answers
15 views

Numbers are not displaying properly in excel report

n excel report generation, numbers are displaying 7.70225E+11 but it should display like 770225145579 . Any one please help to solve this issue. My code is, <?php include("connection.php"); ...
0
votes
2answers
21 views

Excel 2010 - how to prepend a “0” to make an 8 digit number 9 digits

I'm running Excel 2010 using a output file from our database software that exports a list of our affiliate stores. The affiliate stores have a 9 digit code and a number of these codes start with "0". ...
0
votes
1answer
35 views

Excel if/then formula

I am wondering if there is an if/then formula for the following situation. I am trying to populate a monthly calendar. I want the calendar to show the value in A1 if the value in B1:B100 is equal to a ...
1
vote
1answer
29 views

How do I create a dynamically-growing graph which ignores empty tail cells?

I have a table on an Excel 2010 Worksheet 'Consolidated Data' where: Column A is filled with arbitrary dates sorted by increasing age Column F has numeric data relevant to this question Row 1 is the ...
1
vote
2answers
37 views

Looking to extract individual user (@) mentions from a list of Tweets in an excel document

I have a list of ~1000 tweets from a user I'm monitoring. I would like to be able to track how many unique user mentions (i.e., appearances of @anyUserName) are within the strings. Each tweet is ...
-1
votes
1answer
17 views

Excel adds Values when I copy and paste headings in Powerpoint Chart

When I use Excel from Powerpoint to insert data, and I want to copy the Column headings, Excel adds an extra value - see below Dec - 13 Jan - 14 Feb - 14 Dec - 132 Jan - 143 Feb - 144 ...