# Tagged Questions

5 views

### Can I link my google spreadsheat data to my excel file to sort out data of registered one [on hold]

Can I link my google spreadsheet data to my excel file to sort out data of registered one
18 views

### excel help me pls [on hold]

dear sir i am a great this website nd now i have a problem i am working in a clg as a placement coordinator now my quest is we have attendance data stuff of students in excel format but when ever a ...
11 views

### Copying cells from one Excel sheet to another (more involved but I don't have the term to describe it)

I have data on one spreadsheet that I'm copying over to another. It's easy to copy over a few required cells from the details sheet to the report sheet. For example: =SUM(details!C10) What I need ...
3 views

### How do I sum the last 4 cells in a column that have a value greater than 0 & contain only numbers in excel? [migrated]

I have created a spreadsheet for working out the pay of our employees. The data starts in Row 14. Col A contains that week's pay date eg. 24/3/15 etc. Col B has the total hours the employee has worked ...
30 views

### Sum rows of a array function that outputs a matrix [Google Spreadsheet]

I got a arrayfunction that is returning a matrix. I want to edit this to only return a vector, where this vector contains the sum of each row. I tried applying sum(), but that summed every element of ...
7 views

### How to import data from MS Excel to MS Word

I want to make around 500 piece of certificates for my university program. I have a MS Excel file from where i can get the name of the participants. I have made a design in MS Word. I made a text box ...
20 views

I have a table with column A having a 0 or a 1, and column B having a value that I want to average. I know I can use averageif(A:A, "=1", B:B) to get the average of all of the values that have a 1 in ...
17 views

### Import text from email body into Excel? [closed]

I am receiving a lot of email enquiries from an e-burst sent out by a marketing company on my behalf and the manual data entry is getting a bit tedious. I was wondering if there is a way to have ...
36 views

### Syncing Excel & Mailchimp

I would like to sync automatically a list managed in Excel and the copy of that same list used in Mailchimp. I.e. that in a simple manner unsubscribes, bounces, etc. are synced from Mailchimp to ...
15 views

I have a problem creating a formula for my sheets. I want google docs to put either "yes" or "No" in a specific cell depending on the values in other cell. in other words I want it to put "Yes" when ...
47 views

### How to make my Excel formula work when transferring it to Google Spreadsheets

I am trying to convert an Excel program that tracks repairs inputed by staff and updates a master file. I had the formula working and once I had transferred it to Google Spreadsheets it stopped ...
28 views

### counting multiple entries to equal 1 item in pivot table [closed]

I am pretty much useless at formula writing. I need a pivot table or formula to be able to calculate the following data (below) as number of different subjects (count all duplicates as 1 but only for ...
36 views

I'm creating a table for a friend to input information but he is not very good at computers. I had him work on a table in Excel and locked the page and this worked great but now I want to check his ...
60 views

### Equivalent of Google's ImportXML in Excel Online

I wonder what is the equivalent of Google's ImportXML in Excel Online? I basically need my workbook to get an external XML data, and refresh it every X minutes.
16 views

### How to get formulas to do the calculations

I have a column from A1:A398 in a Google spreadsheet. Each cell either has an "f" or is blank. I want to count how many of each there are. In row 399, 400 and 401 I put the following formulas ...
180 views

I'm importing an Excel spreadsheet into Google Drive. Its a huge spreadsheet, and overall Google spreadsheets has converted everything, except the following: There are a few cells with formulas like ...
25 views

### Using Office Offline on Samsung Galaxy Note (2014 Edition)

I am trying to use Microsoft Online on a Samsung Tablet (Android 4.3). I was under the impression the online version was browser based and not as OS specific as the apps. I can use Excel fine via ...
578 views

### Does Excel Online support filtering columns by value?

One of our customers shared to us an Excel Online document for exchanging notes and bug reports, the file is starting to grow quite a bit, and could benefit from filtering: one of the columns ...
64 views

### How to calculate average screen reso. based on number of visitors using a spreadsheet?

I want to find out what the average screen resolution is for visitors to my website – or rather, what is the average width and the average height in pixels. To qualify what I mean by "average" – and ...
202 views

### Why is data suddenly being pasted in Excel as a single cell when copying from Google Docs?

I have been using Google Docs for some time now and have been able to copy certain sections of columns of the spreadsheet and paste it into an Excel sheet and up until now it has transferred exactly ...
365 views

### In Google Spreadsheet, how to left align currency symbol but right align number?

How to left align dollar sign and right align the number, like Excel currency format? For example: \$ 3,546 \$ 44,345 Also, is there a way to create a custom format?
246 views

I have an XLSX spreadsheet. It has 68251 rows and 94637 cells, and it's on-disk size is 1510842 bytes. When I try to upload it, Google claims that it exceeds the 400,000 cell limit. The cell count ...
333 views

### Microsoft Excel 2010 is password protected but opens in Google Spreadsheet showing all locked and hidden formulas

This is a huge problem. When we email a password protected Excel file with hidden and locked cells to protect formulas, they open on a Droid showing and allowing manipulation of all protected ...
664 views

I emailed an Excel spreadsheet as an attachment to my Gmail account. I then chose open as a Google Spreadsheet. When I opened the Google Spreadsheet, it was missing some formulas and had changed some ...
1k views

I'm searching for few hours for a web app which allows me to create a spreadsheet and embed in to my webpage. I've looked through Microsof Excel Webapp and Google spreadsheets but none of them allow ...
318 views

### Using an Excel file in a web application

I currently am using a macro-enabled Excel sheet that gives me an output based on several input fields with client specific information. I want to automate the process of entering the input values, by ...
699 views

We've created a commission calculator to help our resellers work out what commissions they will receive on a deal. We built it in Excel 2010 but want to move it to a web based platform that will ...
1k views

I've created an Excel file where a non-technical co-worker of mine organizes a bunch of data into rows and columns. I then have formulas concatenate across those rows and columns and add some HTML ...
9k views

### How do I Export Data to Excel

I am using Trello as the Scrum tool of choice but need a way of exporting data to populate my burn down charts. We are using Google Chrome but have data security concerns, so exporting to Excel is ...
17k views

How do I select multiple cells in Google Spreadsheets (non related cells, other cells between them)? In MS Excel I just press Ctrl and click on all the cells, in Google Spreadsheets it doesn't work. ...
2k views

### How do you insert an Excel sheet as part of a new mail message?

How do you insert an Excel sheet as part of a new mail message? I tried inserting a MS Excel document directly / via a Microsoft document. But when I copied into a new Gmail message, the formatting ...
639 views

### formatting excel sheet to organize data properly

I have an excel sheet which has approximately 2000 Rows. The columns are First Name ,Second Name, email 1, email 2 I want to be able to use all these contacts in one go in gmail in following format ...
3k views

### What is the equivalent key in Google Spreadsheet to Excel's F2 for editing a cell?

In Excel When you want to edit the highlighted cell, and you don't want to move back to the previous cell when pressing the <- key, you press F2. Pressing F2 ensures that when you're editing the ...
774 views

### How do I get my data out of Trello? [duplicate]

Possible Duplicate: Is it possible to export my data from Trello, to back it up? Is there a way (or is it planned) to export Boards, Lists or specific cards to an external downloadable file ...
4k views

### Is there a way to search and replace a regular expression in Google Docs spreadsheets?

The problem is that I entered a lot of formulas like =round(x+y) into a Google Docs spreadsheet. Now I need them exported to MS Excel and the latter only accepts =round(x+y,0) as a valid format. ...
7k views

I want to be sure all my Google Spreadsheet work can be converted OK to Excel. How many of the Excel formulas match the formulas of Google spreadsheets?
1k views

### How exactly does sharing work in Google Docs?

I have an Excel spreadsheet I made to track my own scores for an XBox game I play (TrialsHD, if you are curious). I've made it available to other players so they can track their own scores, but it ...
708 views

### open source analogs of google doc

I am looking for open source analogs of google docs that could work with word and excel. Or maybe some script that can convert .doc to html and than back to .doc
1k views

### Embedding an excel like spreadsheet with formula calculations?

I wish to create an Excel-like spreadsheet which gets a few simple inputs (let's say 3 cells with the input of a number), where then a fourth cell will calculate the sum of the square of the three ...