**-2**

votes

**1**answer

22 views

### Macros to parse excel data [closed]

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

**2**answers

37 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

**1**answer

32 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

**0**answers

25 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

**2**answers

16 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

**0**answers

22 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

**1**answer

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

**1**answer

32 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

**0**answers

21 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

**2**answers

38 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

**1**answer

26 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

**1**answer

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

**1**answer

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

**1**answer

15 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

**2**answers

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

**3**answers

32 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

**1**answer

33 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

**1**answer

31 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

**1**answer

25 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

**0**answers

35 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

**0**answers

17 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

**2**answers

27 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

**2**answers

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

**2**answers

21 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

**2**answers

25 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

**1**answer

37 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

**1**answer

30 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

**2**answers

39 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

**1**answer

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

**-1**

votes

**1**answer

10 views

### Transpose rows to columns in Excel using formulas

I have the following table of results that i would like to transpose from rows to columns using formulas.
Name Details Values
Server1 CPU 1
Server1 Cores ...

**-1**

votes

**1**answer

49 views

### How do I count attendance in Excel?

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, or L for latecomer. I want to get the number of P or L in a range to calculate ...

**0**

votes

**0**answers

8 views

### =VLOOKUP() function performed on dollar value displays value without “$”

I'm not entirely sure how to present pleasant-looking spreadsheet representations on SE, so I would appreciate any advice on that issue given on the side.
I want the B2 cell to display the salary ...

**-1**

votes

**0**answers

4 views

### Ref in external linked excel files

i have a problem with two external linked excel files,
the first called Revenue Analysis and the other called FS - WB
Revnue Analysis reads from FS - WB
When i open the Revenue Analysis it gives ...

**-2**

votes

**0**answers

18 views

### Don't want to FOLLOW hyperlink with one click or Click to hold - Option like Ctrl-Click in word no VBA [duplicate]

Hi DId you ever get response to
I echo the original poster's request. I want to be able to create a spreadsheet with hyperlinks in it, but I don't want to FOLLOW said hyperlinks every time I merely ...

**1**

vote

**2**answers

27 views

### conditional formatting excel 2013

Is there a way to highlight a cell (possibly with conditional formatting) if one of the cells to the left of it has data, but it is empty?
for instance,
A B C D
...

**0**

votes

**1**answer

33 views

### Excel - How do I make the text in a cell flow over into the cell below

I want the text in a cell to flow vertically, that is, flow over into the cell below. When writing in a simple text that is longer than the column width the text flows over automatically into the ...

**2**

votes

**1**answer

42 views

### Excel Number Input restrictions

I have a spreadsheet that I have cells that I want to restrict entry to be either a whole number, or a half number.
Allow say 5 or 5.5 or 9.5.
NOT allow say 3.2 or 5.7.
I'd like to do this ...

**0**

votes

**2**answers

36 views

### How can I find out which parts of an Excel workbook are the biggest in size?

I have an Excel .xlsx that weights 47MB. I'd like to know which parts of the workbook are the heaviest and work them, since I haven't made much progress manually trying to identify and reduce the ...

**0**

votes

**1**answer

19 views

### Removes rows (based on condition) and copy cells (based on condition)

I have to modify a huge VBA script, I am new to VBA and I must also say that I am not loving it :(
I need some help writing an efficient For-loop, let me explain with an example.
During the first ...

**0**

votes

**2**answers

21 views

### Two columns (pounds, kilos) convert and fill opposite column depending on which data is entered.

I'm trying to keep two columns of data. One in Pounds and one in Kilos. (1 kilo = 2.204 lbs)
The problem is that when I add a row, it might be in kilos, it might be in pounds. Is there a formula I ...

**0**

votes

**2**answers

23 views

### Assign triggered code to multiple images - Excel VBA

I wanted to assign some specific actions when clicking on one of the images I have inserted in my Excel sheet. The problem is, I got 52 images (Poker cards for those wondering). So, my question is, is ...

**0**

votes

**1**answer

31 views

### Importing an excel sheet with many empty cells into R

I have a big excel sheet that have lots of empty cells. I'd like to import it in R. I'm fine if in R, all the empty cells are replaced by "NoData".
Replacing all empty cells by "NoData" on Excel and ...

**0**

votes

**2**answers

29 views

### Graphing patient data, multiple dates, multiple patients

In Excel, is there a way to graph multiple series from one column of data? I have lab values for patients. Column A is date, column B is patient identifier, and column C contains all the lab values. ...

**0**

votes

**0**answers

29 views

### merge two functions to plot 3D graphic on Excel or gnuplot

I study the emission of particles from a component. I get a nice curve of the variation of particles concentration C(t) on time(t) using Excel.
I have also a curve of the variation of particles ...

**3**

votes

**2**answers

29 views

### Automatically updating bar chart?

So for a project at work I have a table in excel that contains numbers for each month of the year up to this one in four categories. It looks (a bit) like this:
...

**0**

votes

**2**answers

27 views

### Correct function to use in Excel with “word” variables

So I have a column header saying Home City (without the quotation marks). However, I want to assign that Home City to a Province (which is equivalent to a State in America). I don't think the IF ...

**1**

vote

**1**answer

34 views

### Countifs array with number of days

I'm looking to see how many days people are around between certain blocks.
e.g. with people and the days they are around for listed in the first table (A1:C5) and the blocks in the second table ...

**0**

votes

**2**answers

3 views

### Total number of instances of single-digit numbers w/in two-digit numbers w/in same cell.

Our legacy payroll system reports each day of the month, i.e., 1 through 31, across a single row of cells, e.g., A1:AE1. Below each day, an empty cell or a two-digit number is reported. An empty cell ...

**0**

votes

**2**answers

42 views

### Where does Internet Explorer save the files which I have opened? [duplicate]

I opened an Excel file from Internet Explorer, worked on it for 2 hours and saved it. But now I can't find the file. The file was really important. Is there any way I can retrieve it? I'm using ...

**0**

votes

**2**answers

31 views

### Cannot delete created excel table

I have created an excel table. However, I now want to delete or change it because my range changed.
However I can't delete it in the excel Name Manager:
Any suggestion why I cannot delete it?
...