##
97 posts tagged with excel *and* spreadsheet.

Displaying 1 through 50 of 97. Subscribe:

## Help me escape Excel hell

I need to build a database that's viewable on the web, but for internal use only, among friends. How to do this painlessly? Google spreadsheet is not exactly making it any easier. [more inside]

## Spreadsheet - Naming calendar quarters with custom date

I'm struggling to do something in a spreadsheet (I'm using Google Spreadsheets, but could use Mac Excel or Numbers if needed). I want to automatically fill one cell with the name of the calendar quarter (e.g. "Q3-2015") based on a user-entered date in another cell. To make it more complicated, the "quarters" don't begin/end on standard dates. [more inside]

## Excel 2013 - Using data from two columns to identify a row in a third

I have data on one sheet of an Excel document with three columns. I want to extract this for use on another sheet as follows: If a row in Column A contains X (text string) and a row in column B contains Y (also a text string) then what does the row in column C (always a value) which matches these two criteria contain? With the data I have, this will always return a single result. [more inside]

## Help me quantify extra hours, please, please, a please please.

I need help with gmail functionality. I need to figure out how many(ish) extra hours I generally work. I think an easy way to capture part of this is to check out the volume of email sent outside of my working hours. Is there a reasonably easy way to do this? [more inside]

## Another "data management & research database for dummies" question

I'm undertaking a research project in which I'm evaluating several different organizations based on specific yet qualitative criteria, e.g. "promotes outreach", "reports on progress", etc. I need to able to capture the information and then display the results in some sort of meaningful way so that it can be incorporated into a report. [more inside]

## Counting rows in Excel that match condition?

Can an Excel expert help me with counting rows in a spreadsheet that can match one of 15 possible combinations? [more inside]

## Tracking reimbursements for employees

I'm in charge of a tuition reimbursement process in my company-- people give me their approved applications along with their grades and receipts and I calculate the reimbursement and send it along to accounting. Part of this process is keeping tabs on what's being spent on what. Right now, I'm using a massive Excel sheet to do this and it is

*messy*. [more inside]## Taking data from a PDF and putting it into a spreadsheet

I have a PDF with several hundred pages. Each page is formatted identically and contains data on a single person, divided into various tables. I want to parse the PDF so that each person's data is a single row in a spreadsheet, with various key points (e.g. "name") in the same column. I feel like this has to be an already-solved problem. How can I do this?

## Excel Filter: IF Statements and Concatenate

I'm trying to test if a a series of cells exist, and then concatenate the values that do exist with a paragraph I have. [more inside]

## Help me use Excel to save my job

So, I just got promoted to a new position at my company (Yay!). Unfortunately, the new requirements involve scheduling a ridiculous number of people. It turns out my predecessor has just been doing dozens of iterations manually until one kind of worked, but every slight change puts a bunch of other things out of wack.
I feel like Excel could probably be capable of doing it, but I have no idea how I would go about designing such a spread sheet. [more inside]

## Need help with getting things to sort correctly in Excel

I have a spreadsheet with items that I am trying to organize by part numbers made up of both letters and numbers. When I sort them, though, "HMDL32000" comes ahead of "HMDL3700", even though 32000 is a bigger number. In the warehouse, HMDL32000 is behind HMDL3700 and it seems unintuitive to have it appear first on the spreadsheet. How can I get Excel to organize first by the alphabetical portion of the part number, and then in the correct numeric order?

## Extra-applicational extraction of Excel form

I have an MS Excel spreadsheet which uses drop-down menus which affect the content in multiple fields. It's used for buying inventory, so you'd change the "category" menu to "paperware," upon which the fields "account number" "responsible admin" etc. would all populate depending on what I've chosen in "paperware."
Now we're redoing the form and I'm tasked with mapping all available functions and how they are related [more inside]

## How can I get Excel to create multiple averages from a single table?

I have a table of data that I need to average, but I need to come up with averages using multiple different rows. For example average A=row 1, row 2, row 4: Average B= row 1, row 2, row 3: Average C= row 2, row 3. I would like to add a column that has the names of each average I need, (A, B, C) and then let excel average them based on which set they belong to. I have been looking around at other excel related forums, but I am not sure what this process is called, so I don't know how to find it. Right now I have been copying rows for each time they show up in a set I need averaged. It would be nicer to have column that says, this row belongs to set A and C, next one belongs to set A, B, and C.

## What is the Comic Sans of Excel spreadsheets?

For my new position at work, I'll be putting together a large number of Executive Overviews. This is a new area for me and I'd like to avoid unknowingly committing a spreadsheet faux pas. [more inside]

## Matching two spreadsheets via one matching column

I have two separate marketing lists on spreadsheets, both of which were originally opt-in, but have been residing on different systems - System A for email marketing and System B for SMS marketing. List A has the users' email addresses, cellphone numbers and names. List B just has the users' cellphone numbers (plus a column called "unsubscribed" for those people who. I want to combine the two spreadsheets to create one spreadsheet while keeping the column called "unsubscribed" so I know which people to keep permanently removed. Can you advise me on how to synchronise these two spreadsheets using the cellphone number as the common data? Thanks!

## Is there a better type of spreadsheet?

I'd like to make a spreadsheet, which would include not just text but images and sets of tags, and maybe other interesting fields of information. Is there a better spreadsheet out there which is more flexible and more like a database? [more inside]

## Adventures in giant-CSV land

Hi, I have a .csv that exceeds the maximum number of rows that Excel can handle, and before I can import it into a geodatabase in ArcGIS, I need to make one small edit – I need to delete the first row. Is there any way to do this and resave the file (preferably in a format other than .csv) in a way that retains the rows unable to be loaded in Excel?

## simple excel 2007 question

I need a solution to a pretty simple problem with counting instances of different text phrases in Excel. [more inside]

## Using Excel conditional formatting to do a name/ID data check?

I'm hoping there's an easier way to do this than my current manual process: I want to highlight text cells in Excel 2010 that are a duplicate of ONLY the cell below. Specifics inside. [more inside]

## Need help with conditional lists in excel

I'm creating a workout training program in excel, and I want to show a range of data based on certain conditions. Using Excel 2010 More after the jump. [more inside]

## Excel spreadsheet to pretty clips report?

I have an Excel spreadsheet with couple hundred rows: URLs, a few fields of identifying information (outlet, etc.), for media hits on the organization I work for. I need to make this into a pretty (or at least semi-legible to the computer illiterate) document that I can give to board members, senior staff, etc.
What I would like is to use some form of scripting to automate this. Bonus points if the script can somehow open the URL and take a screenshot of the story so that I don't have to.
I have a Mac, and both the Adobe and Microsoft suites. How do I not spend tedious hours manually doing this? Especially since I have to do it each month and quarter.

## Why can't spreadsheets work like brains?

Former excel magician attempts to use Google spreadsheets, fails. It should be easy to make a function that can tally a monthly total from a column of dates and a column of numbers, right? [more inside]

## Can a sortable spreadsheet exist in a PDF?

I have a PDF document and a spreadsheet in XLS format. We want to be able to put the spreadsheet into the PDF and allow users to click on the sheet's column headings to sort the data alphabetically depending on need. Is this possible? If so, what is the best way to do it? [more inside]

## Calculating durations and times in Excel

Excel help needed in calculating times.
I need to calculate and predict times based on fixed distances and a known average speed. [more inside]

## Building the simplest payroll template in Excel. No, really simple.

I'm dusting off my rusty Excel skills to try to build an easy-to-use, easily updated very basic payroll spreadsheet for a userbase which is completely unfamiliar with Excel. [more inside]

## I Know What I Know.. But How Do I Know What I Don't Know?

Excel Filter: I have a long list of file names in numerical order in an Excel spreadsheet. I need to know what numbers are missing, so I can track down the related files. Is there a quick and (relatively) painless way of doing this without having to sift through all the numbers manually?

## stymied by excel

There has to be an answer for this, but I just can't figure it out. In Excel, I've got 5 columns (A-E). I need to return a list of values from column A if either column B or C equals 'foo', *and* if either column D or E equals 'bar'. What's the magical formula (or whathaveyou) that will make this happen? For bonus points, results need to appear on a separate tab than the source data.
asking on behalf of mrs spinturtle, I personally have no idea what I'm talking about.

## Spreadsheet Data Sorting

Excel Spreadsheet - AutoMagically re-arrange data from one sheet to many based upon Alphabet? [more inside]

## Edit a master spreadsheet remotely with a Droid over Bluetooth?

What's the best way to edit a spreadsheet on my PC from across the room, using a Droid over Bluetooth (not WiFi)? [more inside]

## How can I reformat some rows into columns in Excel?

How can I reformat some rows into columns in Excel? [more inside]

## Make 0.000 display as 0.000 and not 0 in Excel

Microsoft Excel Filter: When I type 0.000, I want the cell to display "0.000" and not "0". How do I stop all of this ridiculous autoformating in Excel for good? [more inside]

## What would you do with a BIG spreadsheet on a SLOW computer?

My very important spreadsheet has become too big to use without excel/calc slowing so much that I want to take an axe to the computer. Help! [more inside]

## Excel 2007 Conditional Formatting

Excel 2007 conditional formatting help! [more inside]

## Microsoft Excel or Substitute?

Microsoft Excel substitute (Open Office seems not to work) needed to open a spreadsheet (directory of businesses) based on macros. [more inside]

## Spreadsheets, Databases - Help Me. Please.

Well, I created a spreadsheet in Google docs. A simple, no frills document where there are various columns - one s for email addresses.
Those addresses I want to go into my Address book in either Gmail or Thunderbird. Downloaded the spreadsheet into Excel - in CSV format - tried to save it to text - it's obviously not working. Someone online directed me to the Google Scripts and to API.
This is so not my forte' and it's for a non-profit and am getting lost in a sea of geekage. Is there a simple way to just export the column of email addresses, convert them into a database separated by columns, fit for my email program?
Thanks in advance.

## How does one auto-fill an Excel spreadsheet with terms?

How does one auto-fill an Excel spreadsheet with terms from another data source? [more inside]

## Filtering an Excel Spreadsheet

Problems filtering a large Excel worksheet that resides on a shared drive. [more inside]

## Dear Excel 2003, I need my columns back.

A few questions about Excel 2003. [more inside]

## Need to print Excel spreadsheet so it turns out like a vertically-folded half-sheet card.

Need to print Excel spreadsheet so it turns out like a vertically-folded half-sheet card. [more inside]

## CONCATENATE/ CATASTROPHISE

In-over-my-head-Excel-filter: I need to put little braces {like, brackets}around a whole column of values using the concetenate function.. column A has all the values I need braced- but how do I get those same values {braced} in column B? [more inside]

## Escelfilter: Making a dummy worksheet to simplify display of information?

I have a massive spreadsheet that's simply too difficult to read, because of its size. Is there any way of making a second spreadsheet that is exactly the same as the first, except that the 2nd's cells just show an "x" if there is information in the 1st's cells. i.e., the 2nd spreadsheet would just show whether or not the cells on the 1st spreadsheet have been filled in, but not the actual information itself. If sheet 1 looks like this, sheet two should look like this. [more inside]

## How do I bring HTML data into Excel?

I once used a web-based spreadsheet tool that let me copy data from pretty much any webpage into a properly formated spreadsheet. Upon pasting an entire page worth of HTML-formatted search results, for example, it prompted me for the desired cell arrangement in the spreadsheet and applied it to the entire set of data. I can't remember what it was called, I can't seem to google the right terms and this will save me (not to mention my employer) countless hours copying and pasting data this week and next. Alternatively if you have another solution, please share.

## Need a formula to lookup/match two values and return a third in Excel

Need a formula to look for two values in another sheet, and return a third corresponding value. Example provided (google spreadsheet.) [more inside]

## Blind Spot in my Excel Formula Abilities

Excel Idiot Filter: Is there some simpler way to calculate the averages of the same cell along multiple worksheets? [more inside]

## I've just spent 16 hours on a lab. Never again.

What spreadsheet/graphing software should I use to do physics labs? [more inside]

## Reverse my percentage?

How do you find a number that minus a percentage of itself is a certain number? [more inside]

## Evaluate the meaning of a string in Excel.

How do I store a string in one cell in Excel and interpret it as a (or for a) function in another cell? More info inside. [more inside]

## Excel can do this, right?

Can I set up an Excel spreadsheet so the user is presented with a series of fields, like a form, instead of having to enter data directly into the cell? [I'm having a hard time even wording this question properly, so I haven't been able to find the answer anywhere. I turn to AskMe. Further explanation follows...] [more inside]

## How do I link excel spreadsheets to create an inventory breakdown?

How do I create an inventory database using Excel? [more inside]

## I need a list of all the countries

I'm looking for a randomized list of every nation state in the world, preferably in spreadsheet column form. Is there anything like this?

Page:
1 2