Tagged Questions

0
votes
1answer
26 views

Having trouble creating certain graph in Excel

I want to create a graph which given a list of dates, will produce a line graph representing the number of occurrences of list dates. For example, this would be ideal. But when I try to recreate ...
0
votes
1answer
38 views

Correct sorting after text to columns in EXCEL

I have some data in which one column represents the Days of Operations, as below: ------- Days ------- 15 7 1234567 etc. I want to "break" the column (via text to columns option in the Data tab of ...
-1
votes
2answers
53 views

excel data validation in cells wit

In excel I was wondering how you go about adding a simple list (data validation) to a range of cells but have the data validation list only appear if the adjacent cell is filled? For example a simple ...
0
votes
1answer
131 views

Excel Formula for filtering data from one sheet to another

I have table that have the following columns (Agent Name, Client, Policy #, Premium) with the name of agents repeating several times since they have multiple clients... I don't want to give all the ...
1
vote
3answers
142 views

how can I split data into multiple columns seperating only after the first colon in excel

I have a huge excel list (20k+ rows) and want to split that one column list into multiple columns. Previously I used the Data|Text-to-Columns Wizard but it appears to have a limitation: I cannot ...
1
vote
1answer
46 views

Excel formula for extracting prefixes

I have a table of 2 columns - file name & PC ID. What I need is list of all 3-letter prefixes - for each PC ID separate. For example: For: BUSstop1 PC1 BUSstop3 PC2 TRMstop8 PC1 BIKnet1 PC1 ...
1
vote
2answers
182 views

Find alike data in two worksheets and put in 3rd worksheet

What is the best/easiest way to combine data from two different Excel spreadsheets into a third Excel spreadsheet? Spreadsheet 1 will have the username only. Spreadsheet 2 would have lots of ...
0
votes
1answer
396 views

How to extract unique data from cells in a single column with thousands of similar values?

I have a single column in an Excel sheet with around 25,000 cells (numbers). Most of them are identical that in the end there are only - I guess - maybe 200 different numbers. Is there a way to ...
0
votes
2answers
109 views

Merging 2 spreadsheets on Excel 2010

I was wondering if it was possible to merge data from 2 different spreadsheets together. I'm looking at at world development indicators, so I have 1 spreadsheet which has human development index ...
3
votes
2answers
90 views

Extract items from 1 huge cell in Excel

I have a huge spreadsheet of PC's and the software that is installed on them. Unfortunately the report lists all the software installed for a PC in one cell. I need a formula or macro which will go ...
0
votes
2answers
363 views

Data validation - require nearby cell not be blank

I'm trying to create a "comments" field in a worksheet for error-checkers that can only be used when certain errors are flagged as present. (by writing a whole number in the relevant cell) I've tried ...
1
vote
1answer
81 views

Excel =IF(ISBLANK … ) not working

I have (letters up top are column names): | J | M | N | O | | |kennedy| 2 | 4 | | |nixon | 3 | 2 | | | | 8 | | | | bush | | | | | ...
0
votes
0answers
60 views

How to copy non table data into excel using data from web funcion?

I want to copy some data from say wikipedia, the data apears to be formatted as a table, however when I use the data from web function there is only one table to copy and that is the whole page, is ...
1
vote
1answer
93 views

Finding instances across multiple excel columns and rows

I am working in MS Excel 2007 with data regarding a series of forum posts. Each post is represented by a row of data that includes a unique ID for each post, the unique ID of the user that posted it, ...
2
votes
1answer
116 views

Import data in Excel that doesn't have a row delimiter, but number of columns is known

So i have this text file that looks something like this: Header1 Header2 Header3 Header4 A1 B1 C1 D1 A2 B2 C2 D2 and so on. When imported, I'd want the data to format itself in 4 columns. I ...
0
votes
1answer
44 views

How to edit a formula that I already have to take into account another cell's data

I have an Excel sheet that keeps track of bonus for our paralegals. Because we need the clients to be listed in one sheet all the paralegals are also in one sheet instead of each having their own. I ...
1
vote
1answer
185 views

Excel data range - to sum series within date range

I have a set of data that I would like to manipulate but my problem is not straight forward. In this data I have date ranges that include multiple entries of the same date on some days and not on ...
1
vote
1answer
201 views

Excel data validation formula

I have a table with an input column and have set up two tables with the allowable input values. The correct table depends on the value in a cell at the end of each row. To determine which table is ...
-1
votes
2answers
103 views

Recomposing data structure

I've a worksheet of 35k rows of the kind in the first table below that I want to reshape as in the lower table. So, I want to reshape this data in a way to get all the people within a specific ...
0
votes
2answers
271 views

Excel macro to extract specific data

I have a spreadsheet with a cell which contains every app on a computer. I want a macro to extract a specific application from the list and delete the rest of the apps and simply display the ...
0
votes
1answer
154 views

data safety in excel

If protecting workbook in ms excel (2010, 2007, 2003) is enough safe for a sensitive data? There is a possibility to choose encryption aes 128 bit in ms excel 2003 and 2007 (as default), from that ...
1
vote
2answers
373 views

date format excel

Problem 1: I have an Excel Cell which has the number format as dd.mm.yyyy. I need to add limits to that particular cell, using Date criteria in Data Validation. In the data validation I set the ...
1
vote
1answer
2k views

Excel, merge two sheets with one column as key

Let me start by saying I exclusively use Excel to view things and that's where my experience ends. I have two sheets with some common data, and most importantly, a column in each that has the same ...
1
vote
2answers
5k views

Easily Plotting Multiple Data Series in Excel

I really need help figuring out how to speed up graphing multiple series on a graph. I have seperate devices that give monthly readings for several variables like pressure, temperature, and salinity. ...
1
vote
3answers
1k views

Remove data from a cell in Excel

I want to remove data from multiple cells in a spreadsheet using Excel 2010, so I only have the email address left. They are in the current format: M: 04545 545 545 e: test@email.com h: 01187 475 ...
2
votes
1answer
158 views

Microsoft Excel Data Transformation

I have an Excel document that looks like this: Country Property Value Canada Capital Ottawa Canada Population 38 Canada Language1 French Canada Language2 ...
2
votes
1answer
273 views

Can I do a Multiple Regression with Excel?

I have performance data for 3 years for about 50K employees. Each employee has 3 ratings associated with them. I would like to create an equation that will predict (or try to predict) the future ...
0
votes
1answer
115 views

What is the best way to set up an impressive front page for a Microsoft Excel Workbook that references specific data within the individual worksheets?

I have created a very quick CMDB (Configuration Management Database) within excel and it has different worksheets that refer to laptops, desktops, printers etc. I want a front sheet that I can brand ...
3
votes
4answers
10k views

How to search for newline or linebreak characters in Excel?

I've imported some data into Excel (from a text file) and it contains some sort of newline characters. It looks like this initially: If I hit F2 (to edit) then Enter (to save changes) on each of the ...
0
votes
1answer
122 views

Use Excel to select the most recent row from a CSV?

I have a CSV that starts with a date/time field and I need to import, and select the most recent row and refer to it in my formulas. I'm experimenting with Pivot Tables, and just now Rank and ...
0
votes
4answers
232 views

What is the best way to manually edit and update data within a large table in MS SQL Server?

I have a table in MS SQL server which currently has around 800 records and 20 columns. I want to manually update and add to the information within this table on a frequent basis. Would exporting the ...
1
vote
2answers
393 views

Dynamic data validation in Excel

On my first sheet I have all my options: A B ============= yellow DOG Green DOG PINK DOG YELLOW CAT Pink CAT black BIRD RED BIRD On my next sheet I want: Animal ...
0
votes
1answer
248 views

Excel scatter graph line only “connects data points with line” even with #N/A in source cells?

Excel scatter graph line only "connects data points with line" even with #N/A in the source cells. I have tried using different scatter graph line types but all interpolate the data over the ranges ...
1
vote
1answer
370 views

Where is a Web Query stored in an excel file?

I have a Web Query looking at a site for data, and it gets the table selection wrong. Viewing source of the linked to web page I am able to identify the correct table. In an Excel Web Query you are ...
0
votes
3answers
499 views

Selecting all data in Excel column regardless of size

I have a repetitive process that I must do in Excel for test data collected. I have to do this process for every data point I collect. I collect over 200 data points each test. My data is auto ...
6
votes
3answers
5k views

Excel: How do I reference an entire row except for a couple of cells?

I want to be able to sum together the values of an entire row except for the first 2 cells. So something like this: =sum(A3:A*infinity*) How do I do this?
3
votes
2answers
3k views

Import data into excel that doesn't use a line break as a row delimiter?

Is there any simple method that doesn't resort to macros whereby a plain text file or string can be imported into excel without using a line break as a row delimiter? Example ...
3
votes
2answers
2k views

Pass parameter from Excel to Access query

I have a Access (2010 but I've also tried Office 2003) database with a lot of tables, forms and nested queries which rely on data entered in a form, e.g. WHERE query1.year=[Forms]![Form1]![Text0];. I ...